I am trying to get derby working
on tomcat6 via jndi
my context.xml looks like this:
<?xml version='1.0' encoding='utf-8'?>
<Context path="/testApp" docBase="testApp" antiJARLocking="true">
<!-- ensure the db server is started and that tomcat can find the db
driver -->
<Resource name="jdbc/derbyDB" auth="Container"
type="javax.sql.DataSource"
driverClassName="org.apache.derby.jdbc.ClientDriver"
url="jdbc:derby://192.168.1.100:1527/setupDB"
maxActive="10" maxIdle="5" />
</Context>
my web.xml looks like this
...
<resource-ref>
<description>Setup Database</description>
<res-ref-name>jdbc/derbyDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
...
my java code gets the datasource from jndi just fine
envCtx = (javax.naming.Context) initCtx.lookup("java:comp/env");
ds=(DataSource)envCtx.lookup("jdbc/derbyDB");
but it fails when i try to getConnection
conn = ds.getConnection();
i am not sure what i am doing wrong here.
Any ideas?
Thank you
Michael
ps:
note: the commandline ij tool works fine also:
C:\Documents and Settings\Lisa>ij
ij version 10.3
ij> connect 'jdbc:derby://192.168.1.100/setupDB';
ij> show tables;
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
SYS |SYSALIASES |
...
|