Can't get DBCP Connection Pooling to work with H2 database

[cpjust]

Hi,
I've got a servlet on Tomcat on Solaris and I'm using the H2 database (

http://www.h2database.com).

It currently works without using DBCP, but to improve performance, I need to use connection pooling. I tried following the instructions I found here:

http://www.archivum.info/comp.lang.java.databases/2008-06/msg00007.html

But it's throwing a NoInitialContextException during the call to lookup().
Here's my getConnection() function:

private Connection getConnection() throws QueueException
{
	try
	{
		Context initContext	= new InitialContext();
		DataSource ds = (DataSource)initContext.lookup( "java:comp/env/QueueDB" );
		return ds.getConnection();
	}
	catch ( NamingException e )
	{
		throw new QueueException( e );
	}
	catch ( SQLException e )
	{
		throw new QueueException( e );
	}
}

Does anyone know what's wrong? I've never used DBCP and barely know anything about Tomcat configuration.

 

[prosper]

I guess your configuration in JNDI may not be sucessful.

http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html

 

[cpjust]

Which configuration are you referring to? The Tomcat configuration (context.xml and/or web.xml) or the getConnection() code?
I tried using the code from that link first and couldn't get it to work either, so I went looking on other sites for specific H2 examples...

 

[cpjust]

OK, I think I was debugging the wrong thing. Now it's getting the InitialContext, but I'm getting a new exception on the return statement:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.h2.Driver'

	Context initContext	= new InitialContext();
	Context envContext	= (Context)initContext.lookup( "java:comp/env" );
	DataSource ds = (DataSource)envContext.lookup( "jdbc/h2" );
	return ds.getConnection();

 

[cpjust]

OK, I got it fixed.
Apparently I had to put h2.jar in $CATALINA_HOME/lib instead of in my servlet's WEB-INF/lib directory.