不好意思啊 因为这个问题,搞的头都大了 所以帖的时候没注意错误: <A JDBC pool connection leak was detected. A connection leak occurs when a connection obtained from the pool was not closed explicitly by calling close() and then was disposed by the garbage collector and returned to the connection pool. The following stack trace at create shows where the leaked connection was created. [Null exception passed, creating stack trace for offending caller] at weblogic.utils.StackTraceUtils.throwable2StackTrace(StackTraceUtils.java:28) at weblogic.jdbc.wrapper.PoolConnection.finalize(PoolConnection.java:77) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) at java.lang.ref.Finalizer.access$100(Finalizer.java:14) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) 在调试的时候,通过System.out.println("Error:" + ex.getMessage());打印出来的错误是,conn=null连接池是没问题的,是用weblogic的
你的连接数据库的驱动的那部份代码呢。没写?
<A JDBC pool connection leak was detected. A connection leak occurs when a connection obtained from the pool was not closed explicitly by calling close() and then was disposed by the garbage collector and returned to the connection pool. The following stack trace at create shows where the leaked connection was created. [Null exception passed, creating stack trace for offending caller]
at weblogic.utils.StackTraceUtils.throwable2StackTrace(StackTraceUtils.java:28)
at weblogic.jdbc.wrapper.PoolConnection.finalize(PoolConnection.java:77)
at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
在调试的时候,通过System.out.println("Error:" + ex.getMessage());打印出来的错误是,conn=null连接池是没问题的,是用weblogic的
URL : jdbc:weblogic:oracle Driver Classes : weblogic.jdbc.oci.Driver Properties (key=value): user=xixi
password=haha
server=your_tnsname
需要安装oracle的客户端 your_tnsname是你在Oracle客户端中配置的指向oracle服务器的本地服务名 startWeblogic.cmd中 Path变量加入.\bin\oci817_8 2 oracle JDBC的thin方式
属性 值
URL : jdbc:oracle:thin:@193.0.0.5:1521:ora8 Driver Classes : oracle.jdbc.driver.OracleDriver Properties (key=value): user=xixi
password=haha
dll=ocijdbc8
protocol=thin
不需要安装oracle的客户端 , ora8为你要连接的数据库的SID startWeblogic.cmd中 Path变量加入.\bin\oci817_8, CLASSPATH中加入$ORACLE_HOME\jdbc\lib\classes12.zip或classes111.zip,使之能找到oracle的JDBC类。
2 Oracle JDBC的OCI8方式 属性 值
URL : jdbc:oracle:oci8:@your_tns Driver Classes : oracle.jdbc.driver.OracleDriver Properties (key=value): user=xixi
password=haha
dll=ocijdbc8
protocol=oci8
your_tns为你在Oracle中配置的指向oracle服务器的本地服务名(即 TNS NAME)
{取消path中的./bin/oci817_8/ (LINUX下$WL_HOME/lib/linux/ora8.1.6_oci8) LD_LIBRARY_PATH 加入 $ORACLE_HOME/lib } startWeblogic.cmd中 Path变量加入$ORACLE_HOME/bin, CLASSPATH中加入指向$ORACLE_HOME\jdbc\lib\classes12.zip或classes111.zip 需要安装oracle的客户端 ,注意 oracle客户端配置好 oracle的环境变量 NLS_LANG和ORACLE_HOME
二 在console中注意 在targets页下选中你欲使用的server,即指定在哪些server中可以使用这个connection pool。 三 建立一个数据源,使用这个连接池 检查连接池是否配置成功 重新启动后,在该连接池的monitor页下,查看该连接池的实例是否启动了。