ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guido García Bernardo <ggb...@tid.es>
Subject Re: connection fails with sybase
Date Tue, 05 Jul 2005 12:04:25 GMT
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
>
>
>  
>


-- 
Guido García Bernardo - ggarciab@itdeusto.com
Tfn. +34 983 54 89 08
ITDEUSTO - Valladolid


Mime
View raw message