Datasource tomcat 5.5

[Migrated From Jforum.net]

Hi I'm currently creating a new forum site with JDK 5.0, Tomcat 5.5, and hsqldb. One of my requirements is to use a datasource. I have created a datasource in Tomcat and tested it with a jsp I put in my jfourm application. The jsp works fine, but when I try to use the same datasource with the jforum application I get the error below. I have included the database lines from my systemGlobals.properties and the datasource setting from my tomcat config. For the database.datasource.name I have tried everything java:jdbc/TestDB, java:/jdbc/TestDB, /jdbc/TestDB, jdbc/TestDB, java:/TestDB, java:TestDB, /TestDB, and TestDB, none of them seem to work. If any one has experience with this set up or just JDK 5.0, tomcat 5.5 and using a datasource can you please help.

Thanks
Ben


Error Message

javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
	org.apache.naming.NamingContext.lookup(NamingContext.java:770)
	org.apache.naming.NamingContext.lookup(NamingContext.java:153)
	org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
	javax.naming.InitialContext.lookup(InitialContext.java:351)
	net.jforum.DataSourceConnection.init(DataSourceConnection.java:75)
	net.jforum.ForumStartup.startDatabase(ForumStartup.java:75)
	net.jforum.JForum.init(JForum.java:95)
	org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
	org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
	org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
	org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
	org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
	org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	java.lang.Thread.run(Thread.java:595)

systemGlobals.properties

# Database type to use (mysql, hsqldb, postgresql, oracle)
database.driver.name = hsqldb

# Can be net.jforum.SimpleConnection, net.jforum.PooledConnection 
# or net.jforum.DataSourceConnection
database.connection.implementation = net.jforum.DataSourceConnection

# Enable / Disable transactions
database.use.transactions = true

# DataSource name, in case of using net.jforum.core.db.DataSourceConnection
#database.datasource.name = java:/MySql
database.datasource.name = java:/TestDB

Tomcat resource config

<Resource
	          name="jdbc/jforumDS"
	          type="javax.sql.DataSource"
	          password=""
	          driverClassName="org.hsqldb.jdbcDriver"
	          maxIdle="2"
	          maxWait="5000"
	          validationQuery="SELECT * FROM JFORUM_USERS"
	          username="sa"
	          url="jdbc:hsqldb:/C:/Development/tools/hsqldb/data/jforumDB/jforumDB"
      maxActive="4"/>

[originally posted on jforum.net by bmcguire]

[Migrated From Jforum.net]

I have seen this happen in some situations. When I can't put it to work, I do two tests: a raw jsp file (like you did) and the same code in a Java file, usually a servlet. Then a compare the code that works with the code in JForum, and (maybe) change the differences.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

I worked on this a little more and was able to come up with the solution. Retrieving datasources is different for each server. When using tomcat the property database.datasource.name needed to be prepended with java:comp/env/ not just java: . So when using a datasource named jdbc/TestDB the property looks like this

database.datasource.name = java:comp/env/jdbc/TestDB

[originally posted on jforum.net by bmcguire]