Which version of weblogic are you using?
Which version of oracle are you using?
Mitesh
Satish wrote:
> We get the following error while trying to create a connection pool using Type
> 2 driver. The properties file is also attached.
>
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: capacityIncrement
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: driver
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: refreshMinutes
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: url
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: loginDelaySecs
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: maxCapacity
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: props
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: testTable
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: shrinkPeriodMins
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: initialCapacity
> Wed Oct 24 14:34:33 IST 2001:<W> <WebLogicServer> Found undeclared property: allowShrinking
> -----
> ------
> Wed Oct 24 14:34:34 IST 2001:<I> <JDBC Pool> Creating connection pool mypool with:
> {aclName=weblogic.jdbc.connectionPool.mypool, poolName=mypool}
> Wed Oct 24 14:34:34 IST 2001:<E> <JDBC Pool> Failed to create connection pool
> "mypool"
> java.lang.Exception: Missing startup value "url" in JDBC Connection Pool mypool
> at weblogic.jdbc.common.internal.ConnectionPool.getPoolValue(ConnectionPool.java:359)
> at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:246)
> at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java:117)
> at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
> at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
> at java.lang.reflect.Method.invoke(Native Method)
> at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
> at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java:109)
> at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
>
> ------------------------------------------------------------------------
> Name: weblogic.properties
> weblogic.properties Type: Plain Text (text/plain)
> Encoding: base64
Make sure you do not have any whitespaces anywhere. I would recomend you redefine your connection
pool settings.
Mitesh Patel wrote:
--
Developer Relations Engineer
BEA Support
weblogic.jdbc.connectionPool.mypool=\
url=jdbc:weblogic:oracle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=SCOTT;password=tiger;server=ntserver
> ----------------------------------------------------------------------------------------------------