ITPUB??ì3
ITPUB论坛 » Oracle Application Server套件 » connection pool被初始化为0

标题: [AS管理] connection pool被初始化为0
离线 jcooper123


精华贴数 0
个人空间 10
技术积分 24 (48328)
社区积分 0 (1737798)
注册日期 2008-3-30
论坛徽章:0
      
      

发表于 2008-4-7 13:18 
connection pool被初始化为0

当前的OAS10.1.2.0.2升级为10.1.2.2.
JDBC version : 10.1.0.5.0
JDK version : 1.4
JDBC driver : classes12.jar
target db version : 9.2.0.7

而且现在出现以下错误:

    null: Releasing connection com.evermind.sql.DriverManagerXAConnection@13489cb to pool (Pool size:
    17)
    null: Releasing connection com.evermind.sql.DriverManagerXAConnection@9ffe8b to pool (Pool size: 1)
    jdbc:oracle:thin:@10.10.10.14:1521:B2BDB1: Opened connection
    Created new physical connection: com.evermind.sql.DriverManagerXAConnection@189b8f7
    null: Connection com.evermind.sql.DriverManagerXAConnection@189b8f7 allocated (Pool size: 0)
    jdbc:oracle:thin:@10.10.10.14:1521:B2BDB1: Opened connection
    Created new physical connection: com.evermind.sql.DriverManagerXAConnection@1a137f
    null: Connection com.evermind.sql.DriverManagerXAConnection@1a137f allocated (Pool size: 0)
    jdbc:oracle:thin:@10.10.10.14:1521:B2BDB1: Opened connection


data-source.xml

     <data-source class="com.evermind.sql.DriverManagerDataSource" name="EBDDatasource"
    location="EBDDatasourceDS" xa-location="xa/EBDDatasource" ejb-location="EBDDatasource"
    connection-driver="oracle.jdbc.driver.OracleDriver" username="test"
    password="test" url="jdbc:oracle:thin:@xx.xx.xx.xx:1521:sid" min-connections="20"
    max-connections="100" inactivity-timeout="10" connection-retry-interval="1" />
      </data-sources>


__________________
SOApub技术论坛
www.soapub.com
只看该作者    顶部
离线 jcooper123


精华贴数 0
个人空间 10
技术积分 24 (48328)
社区积分 0 (1737798)
注册日期 2008-3-30
论坛徽章:0
      
      

发表于 2008-4-16 11:02 
Data source 类型

+ Emulated Data Sources

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name=ÓOracleDSÓ
    location="jdbc/OracleCoreDS"
    xa-location="OracleDS"
    ejb-location="jdbc/OracleDS"
    connection-driver="oracle.jdbc.driver.OracleDriver"
    username="scott"
    password="tiger"
    url="jdbc:oracle:thin:@//localhost:5521/oracle.regress.rdbms.dev.us.oracle.com"
    inactivity-timeout=Ó30Ó
/>


Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("jdbc/OracleDS");
// This lookup could also be done as
// DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/OracleDS");
Connection con = ds.getConnection();



+ Non-Emulated Data Source


<data-source
  class="com.evermind.sql.OrionCMTDataSource"
  location="jdbc/OracleDS"
  connection-driver="oracle.jdbc.driver.OracleDriver"
  username="scott"
  password="tiger"
  url="jdbc:oracle:thin:@//localhost:5521/oracle.regress.rdbms.dev.us.oracle.com"
</data-source>


+Native Data source

<data-source
    class="com.my.DataSourceImplementationClass"
    name=ÓNativeDSÓ
    location="jdbc/NativeDS"
    username="user"
    password="pswd"
    url="jdbc:myDataSourceURL"
</data-source>


__________________
SOApub技术论坛
www.soapub.com
只看该作者    顶部
 
    

相关内容


CopyRight 1999-2006 itpub.net All Right Reserved.
北京皓辰广域网络信息技术有限公司. 版权所有
E-mail:Webmaster@itpub.net
京ICP证:010037号 联系我们 法律顾问