jobss，hibernate 设置数据源问题

[zzy_0471]

原来的项目是用TOMCAT做服务器的，我想改用JBOSS4.2.2。
hibernate 配置文件有一句： <property name="hibernate.connection.datasource">java:comp/env/jdbc/street</property>

tomcat 的server.xml中是这样写的
<Resource name="jdbc/street" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="street" password="123123"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.63.169:1521:ffgh"/>

如果用Jboss,该如何配置数据源呢，谢谢

[JBossWeek]

1、先到jboss安装路径下的docs\examples\jca子路下将oracle-ds.xml拷贝到default\deploy目录下
2、按照连接信息修改oracle-ds.xml配置文件
3、将hibernate配置改为java:/street

[mir2ming]

oracle-ds.xml的配置如下：
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/Oracle</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:oracle:thin:@3.242.165.219:1521:GEDEMO</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>ming</user-name>
<password>ming</password>
<!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
<!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
<!-- Checks the Oracle error codes and messages for fatal errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- 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 - the OracleValidConnectionChecker is prefered
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>

</datasources>

------------------------------------------------------------------
我的JNDI是：java:/jdbc/Oracle(你的是java:/street) try...

[hcy1985]

欢迎JAVA人士加入53633581群