Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

using connection pooling for a standlone java application

 
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Is it possible to use connection pooling for DB2ConnectionPoolDataSource outside of a server?
I am trying to use DB2ConnectionPoolDataSource in IBM universal driver(type 4) through a standalone application.
I am not sure whether i can use it in an a standalone app or i need to have an application server to manage pooling.

Regards,
Giriraj.
 
Bartender
Posts: 2658
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use it standalone.
 
Giriraj Bhojak
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot Jan,

In the meantime I also looked at Jakarta Common's DBCP.
I wonder whether it would be better to use the pooling mechanism of DBCP or to use DB2ConnectionPoolDataSource.
Any thoughts on this?

Regards,
Giriraj.

 
Jan Cumps
Bartender
Posts: 2658
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have no real preference. I use the commons implementation, because it works with drivers that do not support pooling.

What I would not do, is rely on DB2 (or Oracle, or ...) implementation. I would not worry to use it's built in pooling capabilities, but would take care that my code does not know (or know as little as possible) about it.
 
Giriraj Bhojak
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
that's what i thought too...
it would be better to opt for a stable tool like dbcp to handle it for my application.
Thanks a lot for replying.

Regards,
Giriraj.
 
Something must be done about this. Let's start by reading this tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic