Re: connection fails with sybase

[Roomity]

I too had the same problem with MySQL and having the driver jar in 
classpath solved it :-)

Guido García Bernardo wrote:
Is your driver in the classpath?
Dropping the driver .jar file into your TOMCAT_HOME\common\lib directory 
should work fine...

Regards

Bertulu Gianluca wrote:

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