Problem with JDBC connection from stateless SessionBean
ignac Sep 7, 2003 6:49 AMHi,
I've got problem executing queries to the Hypersonic database from my stateless session EJB.
Below there are pieces of code and of jboss console output.
I've tried on 3.2.2 and 3.2.1 versions of JBoss.
Please, help!!!
Thanks in advance.
The code looks like that:
-------------------------------------
Context c = new InitialContext();
ds = (DataSource) c.lookup("java:/DefaultDS");
conn = ds.getConnection();
getUser = conn.prepareStatement(GET_USER);
getUser.setString(1, login);
System.err.println(" %%%%%%%%%%%% Executing Query ... ");
System.err.flush();
ResultSet rs = getUser.executeQuery();
System.err.println(" %%%%%%%%%%%% Executing Query ... DONE ! ");
System.err.flush();
if(rs.next()) {
....
------------------------------
and the console says:
------------------------------
14:10:51,718 ERROR [STDERR] %%%%%%%%%%%% Executing Query ...
14:10:51,725 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping
14:10:51,729 INFO [TxConnectionManager$TxConnectionEventListener] throwable from unregister connection
java.lang.IllegalStateException: Trying to return an unknown connection1! org.jboss.resource.adapter.jdbc.WrappedConnection@11cf0b
at org.jboss.resource.connectionmanager.CachedConnectionManager.unregisterConnection(CachedConnectionManager.java:264)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:550)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:287)
at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:127)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.resource.connectionmanager.CachedConnectionManager.closeAll(CachedConnectionManager.java:375)
at org.jboss.resource.connectionmanager.CachedConnectionManager.popMetaAwareObject(CachedConnectionManager.java:199)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:190)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:700)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:353)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
at $Proxy52.getUser(Unknown Source)
at org.sourcery.mim.facades.userauthorization.UserAuthorizationEJBBean.checkPassword(UserAuthorizationEJBBean.java:40)