8 Replies Latest reply on Mar 22, 2006 11:18 AM by asafz

Connection handle is not currently associated with a Managed

asafz Mar 12, 2006 7:40 AM

I'm using a Data Source Connection and get this messages periodicaly.

The strange thing is that this Exception is not thrown all the time.
What can cause this problem?

I dont think that this is a connection leak becasue i Can see that the pool is not full (I defined 100 connections and only 10 max are used).

I'm closing the connections I'm getting from the pool in the finaly block.

What can cause this Exception?? this is very important to me becasue this is a problem in a production system (5000 users).

thanx,

1. Re: Connection handle is not currently associated with a Man

asafz Mar 12, 2006 7:48 AM (in response to asafz)

the Full Exception is :
SQlException: Connection handle is not currently associated with a ManagedConnection
Actions
2. Re: Connection handle is not currently associated with a Man

adrian.brock Mar 17, 2006 5:51 AM (in response to asafz)

It means you are trying to use a connection after you closed it
(or it was closed internally because of a previous error).
Actions
3. Re: Connection handle is not currently associated with a Man

asafz Mar 20, 2006 8:12 AM (in response to asafz)

I know that this is the problem,

what I dont understand is why this is happing.

the only way I'm getting a connection is throw dataSource and i checked that all my connections are closed I also flushed all the connections to be sure of that but I'm still get this problem.
Actions
4. Re: Connection handle is not currently associated with a Man

adrian.brock Mar 21, 2006 1:29 PM (in response to asafz)

http://wiki.jboss.org/wiki/Wiki.jsp?page=HelpExpertSystem
Actions
5. Re: Connection handle is not currently associated with a Man

asafz Mar 22, 2006 1:10 AM (in response to asafz)

OK i understand this are the details:

1. I'm running on jboss 4.0.1 - this is a production app so I can't upgrade it.
2. the OS is linux redhat 3 ES.
3. the database is Oracle 9i running on a HPUX server.
4. the JDK is 1.4.2.06

the problem is in every sunday, the DB is shuting down for backup and after the DB is up again we are getting this exception (not all the time but every 4 times avg.)

The main direction we think of is that the application is holding a connection and when the Db is down the connection is still active in the pool but not connected to the db but the problem is that we flush the db and saw in the jmx-console that there are no connection open and still we get this exception

any idea?
Actions
6. Re: Connection handle is not currently associated with a Man

adrian.brock Mar 22, 2006 9:15 AM (in response to asafz)

You only answered question 1 of 34!
Actions
7. Re: Connection handle is not currently associated with a Man

adrian.brock Mar 22, 2006 9:19 AM (in response to asafz)

I created that page such that I wouldn't have to make 4 posts to a thread
to get the most logging, config, etc.

You've had your chance.
Actions
8. Re: Connection handle is not currently associated with a Man

asafz Mar 22, 2006 11:18 AM (in response to asafz)

This is not an answer, sorry.

I cannot take out thr logs because my organization is using diffrent closed network.
the problem is very simple and this is not the first time that this happend.

I also looked in the forums and i found few questions about it but no answers.

lets say that the application is holding a connection while the DB is going down:
1. does jboss test the connection before giving it to the application or just give it without checking?
2. does it get the exception from the application and then close the connection or maybe never close the connection?
3. when I flush the pool jboss should close all the free open connections, and close every connection that was taken when it is free again?

I see that adrian dont want to help me so if anyone else got any idea or just simple answers for my questions i'll be very happy
Actions

Go to original post