[jboss-user] [JCA/JBoss] - Re: How to connect my EJB to Firebird database?

[g_zaspa]

I inserted the code

InitialContext context = new InitailContext();
DataSource ds = (DataSource)context.lookup("java:/FIrebirdDS");
Connection con = ds.getConnection();

in a servlet. Running that I got an exception with the trace:
----------------------------------------------------------------------
18:13:10,343 INFO  [CachedConnectionManager] Closing a connection for you.  Plea
se close them yourself: org.firebirdsql.jdbc.FBConnection at a4effe
java.lang.Throwable: STACKTRACE
        at org.jboss.resource.connectionmanager.CachedConnectionManager.register
Connection(CachedConnectionManager.java:290)
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:417)
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
        at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:95)

        at web.ComputeServlet.init(ComputeServlet.java:50)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1105)
        at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.jav
a:757)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:130)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:175)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:74)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
ctionValve.java:156)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
kerThread.java:112)
        at java.lang.Thread.run(Thread.java:595)
--------------------------------------------------------------------
In this trace the row
web.ComputeServlet.init(ComputeServlet.java:50)
points on my code row
Connection con = ds.getConnection();


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4008384#4008384

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4008384