Database Connection Pooling in J2SE 1.4.2

[microserf]

Hi all

If I am using J2SE 1.4.2, a mysql DB (connecting using com.mysql.jdbc.Driver) and if I get a DB connection using DriverManager.getConnection(), are my DB connections pooled? (I.e. if I call close() on a connection object, is the connection actually closed, or just returned to a pool of open connections?)

If connections are not automatically pooled, what is the best way to obtain connection pooling such that when I call close() on a Connection, the connection is returned to the pool?

Thanks.

 

[sedj]

If I am using J2SE 1.4.2, a mysql DB (connecting using com.mysql.jdbc.Driver) and if I get a DB connection using DriverManager.getConnection(), are my DB connections pooled? (I.e. if I call close() on a connection object, is the connection actually closed, or just returned to a pool of open connections?)

No, the connections are not pooled. When you close the connection, it is physically closed against the database.

If connections are not automatically pooled, what is the best way to obtain connection pooling such that when I call close() on a Connection, the connection is returned to the pool?

You will need to use some 3rd party connection pooling system. There is a list of open source pools here :

http://java-source.net/open-source/connection-pools

Some are better than others

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[Diancecht]

I think I've heard about primrose in some place ...

Cheers,
Dian

 

[microserf]

Thanks sedj,

Do you have any recommendations as to which connection pooling library I should choose? My requirements are that I should have to make minimal changes to my code (I don't need the very best performance, I just need to reuse connections).

Thanks

 

[sedj]

lol, well my recommendation might be a little bit biased considering I wrote Primrose


--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[microserf]

... ah, I wondered what Dian was going on about...