B4J Question MySQL Connection Pool

[Eumel]

Is it possible to find via code, how many connections a webapp currently use ?

Since ABMaterial 2.0 i have to restart my webapp all 4-5 days because of

java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

I checked my code carefully for open SQL connections or resultsets, but they are closed after use.

So i think, eventually there is an unknown error somewhere that let the programm jump out a routine before closing the connection or something else .

So i would like to put in some controllcode, that show the actually open connections.

Can someone help ?

------------
Eumel

 

[Erel]

Are you always closing the connection, even if there is an error?

Dim con As SQL = Main.db.GetConnection
Try
 ...
Catch 
 ...
End Try
con.Close

 

[Squiffy]

This will show some of what you're asking for :

    Dim jo As JavaObject =Main.dbpool

    Log("Failed Data : pool connections = " & jo.RunMethod("getNumConnections",Null) & " out of a max. " & jo.RunMethod("getMaxPoolSize",Null))

(lifted straight out of my app)

 

[Eumel]

Thank you.

 

[Eumel]

java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Method: getNumConnections not found in: anywheresoftware.b4j.objects.SQL

Hmmm .. Not found . I´m using jSQL 1.30

 

[Squiffy]

Are you assigning your pool object to the JO you create?

Contrived snippet :

Dim dbpool As ConnectionPool
dbpool.Initialize(DriverClass,JdbcUrl,DBUser,DBPassword)

dim jo as JavaObject = dbpool

 

[Eumel]

Found it, i assigned the sql object instead of pool ..


Thanks again