jboss中如何设置连接池信息，我的数据库是用的oracle，急！！！！！！！！

Question

<jndi-name>jdbc/ptmanager</jndi-name>
    <jndi-name>OracleDS</jndi-name>
    <connection-url>jdbc:oracle:thin:@210.29.175.252:1521:account</connection-url>
    <user-name>erp</user-name>
    <password>zhaolei</password>
    <min-pool-size>50</min-pool-size>
    <max-pool-size>100</max-pool-size>
    <idle-timeout-minutes>0</idle-timeout-minutes>

Answer 1

<?xml version="1.0" encoding="UTF-8"?><!-- ===================================================================== -->
<!--                                                                       -->
<!--  JBoss Server Configuration                                           -->
<!--                                                                       -->
<!-- ===================================================================== --><!-- $Id: oracle-ds.xml,v 1.1.2.4 2003/09/17 03:46:01 ejort Exp $ -->
<!-- ==================================================================== -->
<!--  Datasource config for Oracle originally from Steven Coy             -->
<!-- ==================================================================== -->
<datasources>
  <local-tx-datasource>  
  <jndi-name>OracleDS</jndi-name>
    <connection-url>jdbc:oracle:thin:@210.29.175.252:1521:account</connection-url>
    <user-name>erp</user-name>
    <password>zhaolei</password>
    <min-pool-size>50</min-pool-size>
    <max-pool-size>100</max-pool-size>
    <idle-timeout-minutes>0</idle-timeout-minutes>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  </local-tx-datasource></datasources>

Answer 2

<?xml version="1.0" encoding="UTF-8"?>
<datasources> 
<local-tx-datasource> 
    <jndi-name>OracleDS</jndi-name>
    <connection-url>jdbc:oracle:thin:@210.29.175.252:1521:account</connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>erp</user-name>
    <password>zhaolei</password>
    <min-pool-size>5</min-pool-size>
    <max-pool-size>20</max-pool-size>
    <idle-timeout-minutes>0</idle-timeout-minutes>
</local-tx-datasource> 
</datasources>

Answer 3

我现在正在做的项目连接oracle9i就用的这个