[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Changing DB from mySql - oracle having persistance problems
Hey.
We had our tests with EJB3 in an mysql db and it worked fine, but we have to change db to
Oracle now, and that caused alot of problems.
I hope someone can give me some pointers to what i am doing wrong, and what i am doing
right, i have tried with transaktions, but without any effect.
The error i get is:
anonymous wrote : 10:53:10,147 ERROR [STDERR] javax.ejb.EJBException:
javax.persistence.PersistenceException: org.hibernate.HibernateException: this instance
does not yet exist as a row in the database
| 10:53:10,147 ERROR [STDERR] at
org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:69)
| 10:53:10,147 ERROR [STDERR] at
org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)
| 10:53:10,147 ERROR [STDERR] at
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
| 10:53:10,147 ERROR [STDERR] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
At this point of my code after the Sysout 4:
anonymous wrote :
| public CustomerBean addNewCustomerBean(ServiceProviderBean serviceProviderBean,
CustomerBean customerBean) throws Exception {
| System.out.println("1");
| serviceProviderBean = em.find(ServiceProviderBean.class,
serviceProviderBean.getId());
| System.out.println("2");
| serviceProviderBean.getCustomerBeans().add(customerBean);
| System.out.println("3");
| em.persist(customerBean);
| System.out.println("4");
| em.refresh(customerBean);
| System.out.println("5");
| em.merge(serviceProviderBean);
| System.out.println("6");
| return customerBean;
| }
Here is the DS file:
anonymous wrote : <xa-datasource>
| <jndi-name>OracleDS</jndi-name>
| <track-connection-by-tx/>
| <isSameRM-override-value>false</isSameRM-override-value>
|
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
| <xa-datasource-property name="URL">jdbc:oracle:thin:@url ending
(this is correct at my end)UK</xa-datasource-property>
| <xa-datasource-property
name="User">***Username***</xa-datasource-property>
| <xa-datasource-property
name="Password">***password***</xa-datasource-property>
| <!-- 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>
| <!-- Oracles XA datasource cannot reuse a connection outside a transaction once
enlisted in a global
| transaction and vice-versa -->
| <no-tx-separate-pools/>
|
| <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
|
| <type-mapping>Oracle9i</type-mapping>
|
| <min-pool-size>1</min-pool-size>
| <max-pool-size>10</max-pool-size>
| <blocking-timeout-millis>5000</blocking-timeout-millis>
| <idle-timeout-minutes>2</idle-timeout-minutes>
| </xa-datasource>
And here is the Persistance file:
anonymous wrote : <?xml version="1.0" encoding="UTF-8"?>
| <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="forums" transaction-type="JTA">
| <jta-data-source>java:/OracleDS</jta-data-source>
|
|
|
|
| </persistence-unit>
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4097373#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...