aspose file tools*
The moose likes Oracle/OAS and the fly likes Creating connection pool and data source dynamically Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Creating connection pool and data source dynamically" Watch "Creating connection pool and data source dynamically" New topic
Author

Creating connection pool and data source dynamically

Manoj Menon
Greenhorn

Joined: Apr 18, 2006
Posts: 5
Hi

How I can dynamically create a connection pool and Data source in Oracle 10g Application server. In our J2EE application the user will be login with db user name, password and database name. I want to create connection pool and data source on the fly while login the user with database name. I our application we have access approximate 80 Databases. so my approach is given bellow
1) Planning to create 80 connection pools and 80 Data sources so when user logs in while selecting the db name i will call the appropriate data source and create the DB connection. Is there any limitation to create number of data sources in oracle app server?
2) Create DB connection with out using connection pool and data source. But i am not prefer this approach coz we need to handle some transaction in our application.

Kindly throw some light on managing connection pool programmatically or in application run time.

Thanks in advance.
Manoj Menon
Greenhorn

Joined: Apr 18, 2006
Posts: 5
Kindly help me to resolve this problem.

thanks
Manoj
Manoj Menon
Greenhorn

Joined: Apr 18, 2006
Posts: 5
Kindly let me know is there any drawbacks to create 80 Data Sources to connect 80 database in Oracle 10G App server and each data sources should have one connection pool. so i need to create 80 connection pool. Please let me know is this right approach or any work around to create Data source on fly for each request for corresponding database.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Creating connection pool and data source dynamically
 
Similar Threads
suggestion for DB pool
WAS 3.5.4 and Oracle 9i (901)
Connection Hangs in the Production System
Implementing scanner into a simple login page
New Article: JDBC Connection Pooling