(Hopefully THIS post will go through ... sheesh!)

Hello all,

I have been working with the JCA-JDBC in a Tomcat 4 environment, and
am making some progress. However, currently when I try to get a
database connection, I get a ResourceException with the message that
"No ManagedConnections Available!".

Here is my server.xml file (relevant portions anyway):

<Context path="/katana" docBase="katana" >
<Resource name="jdbc/KatanaDB" auth="Container"
type="org.firebirdsql.FBDataSourceObjectFactory" />
<ResourceParams name="jdbc/KatanaDB" >
<parameter>
<name>factory</name><value>org.firebirdsql.FBDat
aSourceObjectFactory</value>
</parameter>
<parameter>
<name>User</name><value>SKK</value>
</parameter>
<parameter>
<name>Password</name><value>skk1</value>
</parameter>
<parameter>

<name>DatabaseName</name><value>localhost/3050:/ex
port/home/katana/katana.gdb</value>
</parameter>
</ResourceParams>
</Context>

... and here's the accessing code ...

try
{
Context initCtx = (Context) new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) ctx.lookup("java:/KatanaDB");

conn = ds.getConnection();
}
catch(NamingException ne)
{
ne.printStackTrace();
}
catch(SQLException sqle)
{
sqle.printStackTrace();
}

... and finally the relevant portion of the web.xml file ...

<resource-ref>
<description>
Object Factory Reference to the registration DataSource.
</description>
<res-ref-name>
java:/KatanaDB
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>

Any idea what I am missing?
Thanks in advance!

Braden Walters