[jboss-user] [EJB 3.0] - Re: Problem in deployment of ejb 3 in JBoss Server using Ora

[waynebaylor]

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