B4J Question [SOLVED] Error trying to get a connection pool

[LucaMs]

In a code module I have a regular routine containing only a Select.
I open a connection to the db (MySql) and I close it after the query execution.

Sub XYZ

    Private sq As SQL = pool.GetConnection
    '<...>
    Private Cursor As ResultSet = sq.ExecQuery(Query)
    '<...>
    sq.Close

End Sub

Exactly at the fifteenth call to this routine I get the timeout error while trying to get a connection:

Error occurred on line: 223 (modDB)
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
...
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
...
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@2ef9b8bc -- timeout at awaitAvailable()

(line 223 Private sq As SQL = pool.GetConnection).


It's not a time matter, I tried to wait between the calls.

It's possible that the Close statement does not release the connection?

[mysql-connector-java-5.1.32-bin.jar]

 

[somed3v3loper]

I think you need this ?

Cursor.Close
sq.TransactionSuccessful

 

[LucaMs]

I think you need this ?

Cursor.Close
sq.TransactionSuccessful

Thank you but I close the cursor and I don't use a transaction in that routine

Also I suppose sq.close also closes them.

 

[LucaMs]

Good "news": I tried just that routine, removing all the rest of my project (from the server and from the client) and... now it works.

Bad "news": who knows where is the bug, then!

 

[somed3v3loper]

Check this
http://stackoverflow.com/questions/14105932/c3p0-hangs-in-awaitavailable-with-hibernate
I am not sure if it is related

 

[LucaMs]

Found the bug: in another routine I had not closed the connection

Thank you.