Subject Firebird 1.5 with Resin 3.0.5
Author dcabbar

I am using Resin 3.0.5 with Firebird 1.5 (Jaybird 1.5 beta driver),
and I want to setup a simple jdbc connection pool.

I tried to follow directions on Jaybird FAQ and Resin manuals, but
having a bit of problems!

What I want is really simplu: request a connection from a jsp using
the following code:

try {
Context context = (Context) (new
ds = (DataSource) context.lookup("MyPool");
} catch (NamingException e) {
return false;

try {
Connection conn = ds.getConnection();
} catch (SQLException sqe) {

And, my web.xml has the following:


First of all, when I hit this jsp it gives the following error:
WEB-INF/web.xml:8: `url' is an unknown property of

When I change "url" to "database", then I get the same error for
"user", then I change the "user" to "userName", this time server hangs
forever! Also, I get the following error on resin STDOUT:

So I end up with a web.xml as:
[00:42:34.093] `java:comp/env/MyPool' is a conflicting JNDI resource
for `DBPool[MyPool]'

One more thing is that, when I try to instantiate a connection via
regular means, i.e. through the DriverManager, it works fine with url
and user/pass combination.

So, my final web.xml has the following:


Any ideas, thought? Help is appreciated...