[jboss-user] [JCA/JBoss] - database failover for ejb application (persistance.xml probl

[grdzeli_kaci]

hi all,
i tried to use database failover by ha-xa-datasource.
my database configuration file looks like :
1.oracle-ha-xa-ds.xml

  | <datasources>
  |   <ha-xa-datasource>
  |           <jndi-name>XAOracleDS</jndi-name>
  |           <track-connection-by-tx/>
  |           <isSameRM-override-value>false</isSameRM-override-value>
  |           <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
  |           <!-- list of connection URLs -->
  |           <xa-datasource-property name="URL">jdbc:oracle:thin:@192.168.9.135:1521:DEVSTR|jdbc:oracle:thin:@192.9.200.222:1521:DEVSTR</xa-da
  |           <xa-datasource-property name="User">USER_MANAGER</xa-datasource-property>
  |           <xa-datasource-property name="Password">USER_MANAGER</xa-datasource-property>
  |           <url-property>URL</url-property>
  |           <url-delimeter>|</url-delimeter>
  |           <valid-connection-checker-class-name>tempPackage.OracleValidConnectionChecker</valid-connection-checker-class-name>
  |           <exception-sorter-class-name>tempPackage.OracleExceptionSorter</exception-sorter-class-name>
  |   </ha-xa-datasource>
  | </datasources>
  | 

bu ti can't use this configuration into my ejb application,
is there any doc or example how to config my persistance.xml in this case ????
my persistance.xml looks like :
2.persistance.xml

  | <?xml version="1.0" encoding="ISO-8859-1" ?>
  | <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="Test">		
  | 		<provider>org.hibernate.ejb.HibernatePersistence</provider>
  | 		<non-jta-data-source>java:/XAOracleDS</non-jta-data-source>				
  | 		<properties>
  | 			<property name="hibernate.hbm2ddl.auto" value="validate"/>
  |             <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/>
  |             <property name="hibernate.default_schema" value="USER_MANAGER"/>
  | 		</properties>
  | 	</persistence-unit>	
  | </persistence>
  | 
i tried to use jta-data-source instead of non-jta-data-source but i got the errors :
1.non-jta-datasource:


  | java.lang.RuntimeException: You have not defined a jta-data-source for a JTA enabled persistence context named: Test
  |         at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:220)
  |         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  |         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |         at java.lang.reflect.Method.invoke(Method.java:597)
  |         at org.jboss.ejb3.ServiceDelegateWrapper.startService(ServiceDelegateWrapper.java:103)
  |         at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
  |         at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
  |         at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
  |         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 
2. jta-datasource:

  | 09:20:28,571 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
  | org.jboss.resource.JBossResourceException: Missing configuration for HA XA datasource. No url-delimiter.
  |         at org.jboss.resource.adapter.jdbc.xa.HAXAManagedConnectionFactory.createManagedConnection(HAXAManagedConnectionFactory.java:97)
  |         at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)
  |         at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262)
  | 
  | 


i fount documentations how to write database failover configuration file but i can't find anything about persistance.xml :( how i can use it into my ejb application ?

any idea will be appreciated.


Thanks In Advance.
_________________
Paata,




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

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4081940