ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bertulu Gianluca" <Gianluca.Bert...@urmet.it>
Subject connection fails with sybase
Date Tue, 05 Jul 2005 12:02:30 GMT
Hi, I'm using ibatis 2.0 mith sybase ASE 12.5, but the connection fails with this message:

Failed to queryForList - id [getModuli], parameterObject [null].  Cause: org.apache.commons.dbcp.SQLNestedException:
Cannot load JDBC driver class 'com.sybase.jdbc2.jdbc.SybDriver'


Here you can see my configuration:

SqlMapConfig.xml:
    <transactionManager type="JDBC">
        <dataSource type="JNDI">
            <property name="DataSource" value="java:comp/env/SYBASE_server"/>
        </dataSource>
    </transactionManager>

web.xml:
  <resource-ref>
    <res-ref-name>SYBASE_server</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>


server.xml:
<Resource name="SYBASE_server" auth="Container" type="javax.sql.DataSource"/>
    <ResourceParams name="SYBASE_server">
        <parameter>
            <name>url</name>
            <value>jdbc:sybase:Tds:10.60.4.162:4100/SDG_DB</value>
        </parameter>
        <parameter>
            <name>driverClassName</name>
            <value>com.sybase.jdbc2.jdbc.SybDriver</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>sdguser</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>sdguserpwd</value>
        </parameter>
        <parameter>
            <name>maxIdle</name>
            <value>1</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>3</value>
        </parameter>
        <parameter>
            <name>maxWait</name>
            <value>5000</value>
        </parameter>
    </ResourceParams>
</Context>

Thank tou in advance for your response


Mime
View raw message