here's an example oracle-ds.xml:

  | <?xml version="1.0" encoding="UTF-8"?>
  | 
  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>OracleDS</jndi-name>
  |     
<connection-url>jdbc:oracle:thin:@db_host:1521:database_name</connection-url>
  |     
  |     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  |     
  |     <user-name>my_name</user-name>
  |     <password>my_pass</password>
  |     
  |   
  |     
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  |        
  | 
  |       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml 
(optional) -->
  |       <metadata>
  |          <type-mapping>Oracle9i</type-mapping>
  |       </metadata>
  |   </local-tx-datasource>
  | 
  | </datasources>

and here's an example persistence.xml:

  | <persistence xmlns="http://java.sun.com/xml/ns/persistence";
  |    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
  |    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence 
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd";
  |    version="1.0">
  |    
  |     <persistence-unit name="jpa" transaction-type="JTA">
  |     
  |             <provider>org.hibernate.ejb.HibernatePersistence</provider>
  |             
  |             <jta-data-source>java:/OracleDS</jta-data-source>
  |     
  |             <class>onetoone.Parent</class>
  |             <class>onetoone.Child</class>
  |             <class>onetoone.Person</class>
  |             
  |             
  |             <properties>
  |                     <property name="hibernate.hbm2ddl.auto" value="update"/>
  |                     <property name="hibernate.cache.provider_class" 
value="org.hibernate.cache.NoCacheProvider"/>
  |                     
  |                     <!-- NEED THIS FOR hbm2ddl ANT TASK -->
  |                     <property name="hibernate.dialect" 
value="org.hibernate.dialect.Oracle9Dialect"/>
  |             
  |             </properties>
  |     
  |     </persistence-unit>
  |    
  | </persistence>
  | 

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4065794#4065794

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4065794
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to