You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Kr...@HUD.GOV on 2003/01/17 16:00:01 UTC
Unable to connect to Sybase 11.9.2 server -Help please
Hello Everyone,
I am trying to connect to sybase 11.9.2 database server. Has anyone
encountered this error. Your help on this will be greatly appreciated.
I have created a datasource in Tomcat 4.1.18.
I have the jconn2.jar file in webapps/ROOT/WEB_INF/classes/jconn2.jar
I have the jconn2.jar file in c:/tomcat4/commons/lib/jconn2.jar
However I get this error.
java.sql.SQLException: Cannot load JDBC driver class 'null'
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:529)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
at SecurityCheckServlet.getConnection(SecurityCheckServlet.java:83)
at SecurityCheckServlet.doGet(SecurityCheckServlet.java:37)
I have the following entries in the server.xml
<GlobalNamingResources>
<Environment name="simpleValue" override="true"
type="java.lang.Integer" value="30"/>
<Resource auth="Container" description="User database that can be
updated and saved" name="UserDatabase" scope="Shareable"
type="org.apache.catalina.UserDatabase"/>
<ResourceParams name="UserDatabase">
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
<Resource name="jdbc/MBSDB" scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/MBSDB">
<parameter>
<name>username</name>
<value>jgf</value>
</parameter>
<parameter>
<name>password</name>
<value>mypassword</value>
</parameter>
<!-- <parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter> -->
<parameter>
<name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:sybase:Tds:192.168.7.42:4100/mydatabase</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>6</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
I have the following entries in the web.xml file
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/MBSDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>