B4J Question Database Connection Pool question

K

keirS

Well-Known Member
Licensed User
Longtime User
Is it possible to use a c3po-config.xml file to configure the connection pooling? I assume it would go in the files folder if it's possible.
 
Sort by date Sort by votes
Erel

Erel

B4X founder
Staff member
Licensed User
Longtime User
Currently no.

The default settings are:
B4X: 
     pool.setMaxStatements(150);
     pool.setMaxIdleTime(1800);
     pool.setIdleConnectionTestPeriod(600);
     pool.setCheckoutTimeout(20000);
     pool.setTestConnectionOnCheckout(true);

You can use JavaObject to call these or other methods: http://www.mchange.com/projects/c3p0/apidocs/com/mchange/v2/c3p0/ComboPooledDataSource.html

B4X: 
Dim jo As JavaObject = pool
jo.RunMethod("setMaxIdleTime", Array As Object(3600))

Which settings do you need to change?
 
Upvote 0
K

keirS

Well-Known Member
Licensed User
Longtime User
I want to be able set the maxpoolsize as there is a connection limit per user on the DB server I am looking at ;and I don't want to adversely affect the other users in terms of performance.
 
Upvote 0

vfafou

Well-Known Member
Licensed User
Longtime User
keirS said:
I want to be able set the maxpoolsize as there is a connection limit per user on the DB server I am looking at ;and I don't want to adversely affect the other users in terms of performance.
Click to expand...

Hello keirS.
I would like to ask you if it is correct to close the pool after every transaction!
And then, will the connection be done automatically with BeginTransaction?
Or I have to manually connect it again?

Thank you in advance!
 
Upvote 0
K

keirS

Well-Known Member
Licensed User
Longtime User
vfafou said:
Hello keirS.
I would like to ask you if it is correct to close the pool after every transaction!
And then, will the connection be done automatically with BeginTransaction?
Or I have to manually connect it again?

Thank you in advance!
Click to expand...

No. That would defeat the whole point of pooling.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
B4J Question Database Connections Pooling and Threading
Replies
4
Views
2K
Jmu5667
M
  • Article
B4J Library HikariCP - High Performance Connection Pool
2
Replies
27
Views
13K
alwaysbusy
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
156K
Erel
  • Article
B4J Tutorial [WebApp] Concurrent access to SQLite databases
Replies
7
Views
27K
Erel
  • Locked
  • Article
B4J Tutorial [Server] Building web servers with B4J
2 3 4
Replies
75
Views
100K
Erel