Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Timout problem with pooled firebird connection on JBoss [JDBC144] #186

Closed
firebird-automations opened this issue May 28, 2009 · 10 comments
Closed

Comments

@firebird-automations
Copy link

Submitted by: Heiko Tappe (tdtappe)

Relate to JDBC176

After a while (of inactivity?) the exception below is thrown. After that I usually have to restart the AS to get rid of the problem. Probably the environment tries to close an already closed connection.

If I comment line #⁠285 (checkValidity call) in AbstractPingablePooledConnection.java the problem seems to be solved:

protected void internalClose() throws SQLException {
/* checkValidity(); */

    if \(currentConnection \!= null\)
        currentConnection\.deallocate\(\);

    jdbcConnection\.close\(\);

    statements\.clear\(\);

    invalidate\(\);
\}

Caused by: java.lang.IllegalStateException: Cannot execute desired operation because pooled connection has invalid state.
at org.firebirdsql.pool.AbstractPingablePooledConnection.checkValidity(AbstractPingablePooledConnection.java:176)
at org.firebirdsql.pool.AbstractPingablePooledConnection.internalClose(AbstractPingablePooledConnection.java:285)
at org.firebirdsql.pool.AbstractPingablePooledConnection.deallocate(AbstractPingablePooledConnection.java:302)
at org.firebirdsql.pool.PooledConnectionQueue.destroyConnection(PooledConnectionQueue.java:252)
at org.firebirdsql.pool.AbstractConnectionPool.getPooledConnection(AbstractConnectionPool.java:254)
at org.firebirdsql.pool.AbstractFBConnectionPoolDataSource.getPooledConnection(AbstractFBConnectionPoolDataSource.java:359)
at org.firebirdsql.pool.AbstractFBConnectionPoolDataSource.getPooledConnection(AbstractFBConnectionPoolDataSource.java:397)
at org.firebirdsql.pool.AbstractFBConnectionPoolDataSource.getXAConnection(AbstractFBConnectionPoolDataSource.java:431)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:449)

Commits: 82c7f08 e95cc1d

@firebird-automations
Copy link
Author

Modified by: Roman Rokytskyy (rrokytskyy)

Fix Version: Jaybird 2.2 [ 10053 ]

timeestimate: 0 [ 0 ]

timeoriginalestimate: 0 [ 0 ]

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

I am able to reproduce this error message with a SessionBean and client similar to the one in JDBC93 on GlassFish 3.1 using Jaybird 2.1.6

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

assignee: Roman Rokytskyy [ rrokytskyy ] => Mark Rotteveel [ avalanche1979 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Link: This issue relate to JDBC176 [ JDBC176 ]

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Removed Fix version; for Jaybird 2.2 use org.firebirdsql.ds.FBConnectionPoolDataSource instead.

This class is considered for removal in Jaybird version after 2.2

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Fix Version: Jaybird 2.2 [ 10053 ] =>

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Fix Version: Jaybird 2.3 [ 10440 ]

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Eliminated deprecated datasources from org.firebirdsql.pool

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants