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-issue-importer opened this issue May 28, 2009 · 10 comments
Closed

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 22, 2010

Modified by: Roman Rokytskyy (rrokytskyy)

Fix Version: Jaybird 2.2 [ 10053 ]

timeestimate: 0 [ 0 ]

timeoriginalestimate: 0 [ 0 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 22, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 22, 2011

Modified by: @mrotteveel

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 30, 2011

Modified by: @mrotteveel

Link: This issue relate to JDBC176 [ JDBC176 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 27, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 27, 2011

Modified by: @mrotteveel

Fix Version: Jaybird 2.2 [ 10053 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 17, 2011

Modified by: @mrotteveel

Fix Version: Jaybird 2.3 [ 10440 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 2, 2012

Commented by: @mrotteveel

Eliminated deprecated datasources from org.firebirdsql.pool

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 2, 2012

Modified by: @mrotteveel

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 7, 2017

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants