Hi,
I have an issue connecting to MSSQL 2000 from Tomcat 6.0 (Linux) using
JNDI. When I try and lookup the DataSource object it comes back as
null.... I have configured;
In my server.xml:
<Context path="/myApp" DocBase="myApp" debug="0" reloadable="false"
crossContext="true">
<Resource type="javax.sql.DataSource" name="jdbc/myDB"
auth="Container"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="100" maxIdle="30" maxWait="10000" username="user"
password="pass"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
removeAbandonded="true" logAbandoned="true"
url="jdbc:jtds:sqlserver://xx.xx.xx.xx:XXXX/myDB"/>
</Context>
The class calling the data source does so like this;
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/myDB");
This does not throw any exception, however, ds is null and no physical
connections are made to the database. I would appreciate any advise on
this, its driving me insane.
Also, I have put the following jar's into $CATALINA_HOME/lib on the
advice of other threads;
commons-pool-1.3.jar
commons-dbcp-1.2.2.jar
jtds-1.2.jar
Normal jTDS connections to the same database work fine, so it's nothing
as trivial as a firewall issue.
Thanks in advance
Craig
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
