Reusing JDBC Database Connection Variable 1

[Michael42]

Hello,

If I create a database object variable (oConn) on one (Main App) page how can I use this same connection variable on other pages this page may spawn?

I want to do this rather than opening numerous database connections to the database (Oracle 9i) or having to open and close the connection on every page.

Thanks,

Michael42

 

[Diancecht]

A good place to start:

http://java.sun.com/developer/onlineTraining/Programming/JDCBook/conpool.html

But I think someone in this forun knows a bit about this

Cheers,
Dian

 

[Michael42]

Diancecht,

Thanks for posting. That is a very useful link.

Thanks,

Michael42

 

[sedj]

Use connection pooling. Not mentioning any names.

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

http://www.primrose.org.uk