File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Web Component Certification (SCWCD/OCPJWCD) and the fly likes Connection Pooling in SQL Server 2000!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Certification » Web Component Certification (SCWCD/OCPJWCD)
Bookmark "Connection Pooling in SQL Server 2000!!!" Watch "Connection Pooling in SQL Server 2000!!!" New topic

Connection Pooling in SQL Server 2000!!!

Sonal Sharma
Ranch Hand

Joined: May 13, 2006
Posts: 62
Is the sequence of steps to make a connection pool in SQL Server 2000 same as we do it in Oracle i.e.
1)Create Object pool.
2)Create Connection Factory.
3)Create Poolable Connection Factory.
4)Create Datasource.
Christophe Verré

Joined: Nov 24, 2005
Posts: 14688

If you're using JDBC, the steps are the same for any db server.

Sonal , please be careful when you're asking question, to choose the correct forum. This forum is dedicated to Sun's certification, so your question is not relevant here. Thank you

[My Blog]
All roads lead to JavaRanch
I agree. Here's the link:
subject: Connection Pooling in SQL Server 2000!!!
It's not a secret anymore!