JBoss如何连接数据库？

[caozhiqiang2007]

JBoss连接数据库有几种方法？

[mistfire]

1.直接在program 寫connection
2.lookup datasource，然後通過conenction pool

[Cleexiang]

配置数据库连接池比较好

[zouser]

在deploy下面配置ds.xml文件，然后通过jndi读取。配置内容如下：
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:orcl</connection-url>
<!--

Here are a couple of the possible OCI configurations.
For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm

<connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
or
<connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>

Clearly, its better to have TNS set up properly.
-->
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>qddba</user-name>
<password>zwjhba</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<max-pool-size>5</max-pool-size>
<min-pool-size>1</min-pool-size>
</local-tx-datasource>

</datasources>