ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roomity <R...@roomity.com>
Subject Re: connection fails with sybase
Date Fri, 15 Jul 2005 16:54:44 GMT
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
>>
>>
>>  
>>
> 
> 


Mime
View raw message