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#4097373
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4097373
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
