Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using connection pooling for a standlone java application

 
Giriraj Bhojak
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.
 
Jan Cumps
Bartender
Posts: 2608
14
C++ Linux Netbeans IDE
  • 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: 2608
14
C++ Linux Netbeans IDE
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic