无事务处理配置:创建oracle-ds.xml放到deploy下面。
内容:
<?xml version="1.0" encoding="UTF-8"?><!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== --><!-- $Id: oracle-ds.xml,v 1.1.2.1 2003/09/05 16:38:24 patriot1burke Exp $ --> <!-- ======================================================================-->
<!-- New ConnectionManager setup for Oracle - OraHome90 driver -->
<!-- You may download the latest Oracle JDBC driver from *Oracle* -->
<!-- ===================================================================== --><datasources>
<local-tx-datasource>
<jndi-name>STATDS</jndi-name>
<connection-url>jdbc:oracle:thin:@192.168.0.1:1521:SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>××××</user-name>
<password>×××××</password>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
--> <!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
<min-pool-size>50</min-pool-size>
<max-pool-size>200</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
</local-tx-datasource></datasources>
内容:
<?xml version="1.0" encoding="UTF-8"?><!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== --><!-- $Id: oracle-ds.xml,v 1.1.2.1 2003/09/05 16:38:24 patriot1burke Exp $ --> <!-- ======================================================================-->
<!-- New ConnectionManager setup for Oracle - OraHome90 driver -->
<!-- You may download the latest Oracle JDBC driver from *Oracle* -->
<!-- ===================================================================== --><datasources>
<local-tx-datasource>
<jndi-name>STATDS</jndi-name>
<connection-url>jdbc:oracle:thin:@192.168.0.1:1521:SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>××××</user-name>
<password>×××××</password>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
--> <!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
<min-pool-size>50</min-pool-size>
<max-pool-size>200</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
</local-tx-datasource></datasources>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货