B4J Question [SOLVED] HikariCP active connections

prajinpraveen · Mar 20, 2022

Hi,

Is there a way to get active number of connections for HikariCP? HikariCP library

I have tried using javaobject. I am not great with Java and its implementations

Dim jo As JavaObject
jo.InitializeNewInstance("com.zaxxer.hikari.metrics.PoolStats",Null)

Error: Caused by: java.lang.NoSuchMethodException: com.zaxxer.hikari.metrics.PoolStats.<init>()

and

Dim jo As JavaObject
jo.InitializeStatic("com.zaxxer.hikari.metrics.PoolStats").RunMethod("getTotalConnections",Null)

Error: java.lang.IllegalArgumentException: object is not an instance of declaring class

Class: PoolStats.java

Thank you

DonManfred · Mar 20, 2022

B4X:

 public int getActiveConnections(){
      return connectionBag.getCount(STATE_IN_USE);
 }

is a Method in the HicariCP-Pool-Instance.

See https://github.com/brettwooldridge/...n/java/com/zaxxer/hikari/pool/HikariPool.java

I can not help to get it as i never used this Library. It´s just a note that there is such Method but i don´t know if the Library-Author implemented this Method.

alwaysbusy · Mar 20, 2022

This wrapper for HikariCP I wrote has some additional methods to check info on connections:

[Solved] Out of Memory Issue

My app has been functioning great for many years. July 14, 2021 it started misbehaving... This is the batch file that starts my app, which is large (24 meg).. 'cd\root 'java -Xmx1024M -jar tripinspect.jar 'pause This is the error file (log section)... 'main._appstart (java line: 279)...

www.b4x.com

Note that it is better to use HikariCP-4.0.3 as it 5.x has some memory leak issues.

Alwaysbusy

prajinpraveen · Mar 20, 2022

DonManfred said:
B4X:

public int getActiveConnections(){ return connectionBag.getCount(STATE_IN_USE); }

is a Method in the HicariCP-Pool-Instance.

See https://github.com/brettwooldridge/...n/java/com/zaxxer/hikari/pool/HikariPool.java

I can not help to get it as i never used this Library. It´s just a note that there is such Method but i don´t know if the Library-Author implemented this Method.

Thanks @DonManfred

I bumped into this method. I wasn't successful to implement it. I will give it a try again. Thank you

prajinpraveen · Mar 20, 2022

alwaysbusy said:
This wrapper for HikariCP I wrote has some additional methods to check info on connections:

[Solved] Out of Memory Issue

My app has been functioning great for many years. July 14, 2021 it started misbehaving... This is the batch file that starts my app, which is large (24 meg).. 'cd\root 'java -Xmx1024M -jar tripinspect.jar 'pause This is the error file (log section)... 'main._appstart (java line: 279)...

www.b4x.com

Note that it is better to use HikariCP-4.0.3 as it 5.x has some memory leak issues.

Alwaysbusy

I am going to try this. My app is written using ABMaterial Framework. Is 5.0.0 also problematic?
Thanks @alwaysbusy

alwaysbusy · Mar 20, 2022

Yes. We've noticed problems with 5.x in our ABM apps this summer. We've downgraded to 4.0.3 last week and are keeping an eye on it if it is better.

prajinpraveen · Mar 20, 2022

alwaysbusy said:
Yes. We've noticed problems with 5.x in our ABM apps this summer. We've downgraded to 4.0.3 last week and are keeping an eye on it if it is better.

Tried ABHikari. works like a charm. Been using ABMaterial+c3p0 for a production App for years. At times i see that the open connection using c3p0 just goes up. No warning, No errors. The same code can run for days and weeks without increase in active connections. Wonder why.

Thought of switching to HikariCP and give it a try.

Pendrush · Mar 20, 2022

alwaysbusy said:
We've noticed problems with 5.x

I'm using HikariCP v5.0.1 in production with over 10M queries per day, without any problems in last two months.

tchart · Mar 20, 2022

DonManfred said:
B4X:

public int getActiveConnections(){ return connectionBag.getCount(STATE_IN_USE); }

is a Method in the HicariCP-Pool-Instance.

See https://github.com/brettwooldridge/...n/java/com/zaxxer/hikari/pool/HikariPool.java

I can not help to get it as i never used this Library. It´s just a note that there is such Method but i don´t know if the Library-Author implemented this Method.

I can add this to the library if it works. When I looked there was only a private method to get the count. This was shown in the test sources only so I didn’t add it to the library as it relied on changing the access from private to public.

MichalK73 · Mar 20, 2022

Pendrush said:
I'm using HikariCP v5.0.1 in production with over 10M queries per day, without any problems in last two months.

When there is a continuous connection via Hicari it will not disconnect. Leave for 1-2 days without connection and it will be discarded. With such a number of connections, you cannot be kicked out. I was also using Hicari (the project died already) for over 2 years with a few thousand online users and it worked much better than mysql itself.

Pendrush · Mar 20, 2022

MichalK73 said:
Leave for 1-2 days without connection and it will be discarded.

I don't think that anyone without connections in 1-2 days need Hikari at all.
Every connection recycle it self every hour, also two active connections is set as minimum.

prajinpraveen · Mar 20, 2022

tchart said:
I can add this to the library if it works. When I looked there was only a private method to get the count. This was shown in the test sources only so I didn’t add it to the library as it relied on changing the access from private to public.

thanks. there is a method "poolstats" that shows all the indicators

tchart · Mar 20, 2022

I have added the following methods.

B4X:

    Log(cp.ActiveConnections)
    Log(cp.IdleConnections)
    Log(cp.ThreadsAwaitingConnection)
    Log(cp.TotalConnections)

Code and binaries are on github (see original post)

HikariCP 5.x

This is a wrapper for HikariCP which is a database connection pool manager (https://github.com/brettwooldridge/HikariCP) From the github page; Fast, simple, reliable. HikariCP is a "zero-overhead" production ready JDBC connection pool. At roughly 130Kb, the library is very light. A user called...

www.b4x.com

prajinpraveen · Mar 21, 2022

Thank you @tchart

prajinpraveen · Mar 21, 2022

tchart said:
I have added the following methods.

B4X:

Log(cp.ActiveConnections) Log(cp.IdleConnections) Log(cp.ThreadsAwaitingConnection) Log(cp.TotalConnections)

Code and binaries are on github (see original post)

HikariCP 5.x

This is a wrapper for HikariCP which is a database connection pool manager (https://github.com/brettwooldridge/HikariCP) From the github page; Fast, simple, reliable. HikariCP is a "zero-overhead" production ready JDBC connection pool. At roughly 130Kb, the library is very light. A user called...

www.b4x.com

Please will you reupload HikariCP/HikariCP_5.01 (ope ltd).zip
Seems to be corrupt

MichalK73 · Mar 21, 2022

The file 'HikariCP.xml' in the package is corrupt.
Please correct it.

tchart · Mar 21, 2022

Possibly an issue with GitHub, Ive uploaded it to my website; https://ope.nz/public/HikariCP_5.01.zip

prajinpraveen · Mar 24, 2022

alwaysbusy said:
Yes. We've noticed problems with 5.x in our ABM apps this summer. We've downgraded to 4.0.3 last week and are keeping an eye on it if it is better.

Hello @alwaysbusy. Which B4J library are you using. ABHikari uses HCP 5.0.0 jar. How do i downgrade it to use 4.0.3 if 5.0.0 is a problem? Thanks

B4J Question [SOLVED] HikariCP active connections

Active Member

Expert

Expert

Active Member

Active Member

Expert

Active Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Active Member

Well-Known Member

Active Member

Active Member

Well-Known Member

Well-Known Member

Active Member

Similar Threads