JNDI with tiles controller

[Jim Douglas]

My first question is a design one.  Is JDNI the best way to access a 
database from a Tiles controller?  If so, this is the JDNI class problem I 
have.

This is the tomcat/conf/catalina/localhost/myapp.xml file,
<Context path="/Myapp" docBase="Myapp" debug="5" reloadable="true" 
crossContext="true">
	<Resource name="jdbc/UserDB" auth="Container" type="javax.sql.DataSource" 
/>
	<ResourceParams name="jdbc/UserDB">
		<parameter>
			<name>username</name>
			<value>SYSDBA</value>
		</parameter>
		<parameter>
			<name>password</name>
			<value>password</value>
		</parameter>
		<parameter>
			<name>driverClassName</name>
			<value>interbase.interclient.Driver</value>
		</parameter>
		<parameter>
			<name>url</name>			<value>jdbc:interbase://localhost//usr/opt/tomcat/webapps/database/main.gdb</value>
		</parameter>
	</ResourceParams>
</Context>

This is my Myapp/WEB-INF/web.xml entry,
<resource-ref>
  <description>DS Connection</description>
     <res-ref-name>jdbc/UserDB</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
</resource-ref>
...and this is the error,
ERROR - ServletException in '/layouts/classicLayout.jsp': Cannot create JDBC 
driver of class '' for connect URL 'null'
javax.servlet.ServletException: Cannot create JDBC driver of class '' for 
connect URL 'null'
	at 
org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:880)
	at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:460)

For whatever reason it doens't seem to be loading the driver class.  This is 
the line causing the error,

                Connection conn = ds.getConnection();
I'm using Tomcat 5.5.4(if JDNI is not the best way to acces a database from 
a Tiles Controller, what is, what is?)

 (I can query by other means using the JDBC driver which is located in 
...tomcat/common/lib/, so it's JDNI that giving me the problem.)

Thanks,
Jim,

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]