The follow configuration works with all our Oracle drivers.
http://localhost:7001/console/index.jsp
.Name: OraclePool URL: jdbc:inetora:<HOST>:1521:<SID> Driver classname: com.inet.ora.OraDriver Properties: user=scott<enter> password=tiger
Open the connections tab and verify that the min pool size is 2, the max pool size at least 10 and the increment is 2.
Name: OracleDS JNDI Name: jdbc/Oracle Pool Name: OraclePool
(for example wlserver6/config/examples/startExamplesServer.cmd – wlserver6 is located in the root of your weblogic installation directory).
<resource-description> <res-ref-name>jdbc/DefaultDS</res-ref-name> <jndi-name>jdbc/Oracle</jndi-name> </resource-description>
then your application can use this data source by calling:
dbName = "java:comp/env/jdbc/DefaultDS"; if(ic == null) ic = new javax.naming.InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource) ic.lookup(dbName);