connection from the connection pool???
843853Jun 18 2001 — edited Jun 19 2001I 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.