Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

connection from the connection pool???

843853Jun 18 2001 — edited Jun 19 2001
I want to create connection pool and want to get the connection from that pool

I am using weblogic5 as application server and oracle8i as database. I have made the following entries in the weblogic.properties file.

I suppose it will load the driver when the server wil start, with initially 3 connections open.

weblogic.jdbc.connectionPool.udit=\
url=jdbc:oracle:thin:@IPAddress:port:SID,\
driver=oracle.jdbc.driver.OracleDriver,\
loginDelaySecs=1,\
initialCapacity=3,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=udit;password=pass

Problem is how the get the connection from this pool.
If I write in my client the code for gettting the connection like DriverManager.getConnection(url,user,pwd) will it get the connection from the pool or it will create the new connection everytime this statement gets executed.
If this will create a new connection everytime what I need to do to get the connection from the pool.

Please tell me the solution.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2001
Added on Jun 18 2001
2 comments
94 views