Cannot read the response from the server - why ?

[pietia]

hello,
i have EAR application deloyed on Ger 2.1.0. EAR use <jta-data-source> and "second" connection as follows in my presistence.xml:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0"
        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">
        <persistence-unit name="CustomerEJB">
                <jta-data-source>przychodnia_dbpool</jta-data-source>
               
<!-- entities .... -->

                <properties>
                        <property name="openjpa.jdbc.DBDictionary" value="org.apache.openjpa.jdbc.sql.DerbyDictionary" />
                        <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)" />
                        <property name="openjpa.Log" value="SQL=TRACE" />
                       
                        <property name="openjpa.Connection2URL" value="jdbc:derby://localhost:1527/przychodnia;create=true;" />
                                        <property name="openjpa.Connection2DriverName" value="org.apache.derby.jdbc.ClientDriver" />
                                        <property name="openjpa.Connection2UserName" value="app" />
                                        <property name="openjpa.Connection2Password" value="app" />
                       
                </properties>

        </persistence-unit>
</persistence>


Adding some entities (by web app) to db works , but i dont understand why i gets in my remote application such errors (below) even if application adds correctly new record to database.
Getting only data ( myejb.findAllCustomers(); ) works without any exceptions.
what i do wrong ?

javax.ejb.EJBException: Unknown Container Exception: java.rmi.RemoteException: Cannot read the response from the server.  The class for an object being returned is not located in this system:; nested exception is:
        java.lang.ClassNotFoundException: org.apache.openjpa.util.java$util$HashSet$proxy
        at org.apache.openejb.client.EJBObjectHandler._invoke(EJBObjectHandler.java:179)
        at org.apache.openejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:116)
        at org.apache.openejb.client.proxy.Jdk13InvocationHandler.invoke(Jdk13InvocationHandler.java:52)
        at $Proxy0.saveCustomer(Unknown Source)
        at appclient.ApplicationClient.main(ApplicationClient.java:40)
Caused by: java.lang.ClassNotFoundException: org.apache.openjpa.util.java$util$HashSet$proxy
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:242)
        at org.apache.openejb.client.EjbObjectInputStream.resolveClass(EjbObjectInputStream.java:35)
        at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1544)
        at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1466)
        at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1699)
        at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305)
        at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1908)
        at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1832)
        at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1719)
        at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305)
        at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348)
        at org.apache.openejb.client.EJBResponse.readExternal(EJBResponse.java:93)
        at org.apache.openejb.client.Client.processRequest(Client.java:192)
        at org.apache.openejb.client.Client.request(Client.java:43)
        at org.apache.openejb.client.EJBInvocationHandler.request(EJBInvocationHandler.java:124)
        at org.apache.openejb.client.EJBObjectHandler.businessMethod(EJBObjectHandler.java:210)
        at org.apache.openejb.client.EJBObjectHandler._invoke(EJBObjectHandler.java:152)
        ... 4 more


Source code of app:



package appclient;

import java.util.List;
import java.util.Properties;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NameNotFoundException;

import com.ibm.wasce.customerLocator.ejb.interfaces.CustomerBeanRemote;
import com.ibm.wasce.customerLocator.entities.Company;
import com.ibm.wasce.customerLocator.entities.Customer;
import com.ibm.wasce.customerLocator.entities.enums.CustomerType;
import com.ibm.wasce.customerLocator.entities.enums.Industry;

public class ApplicationClient {
        public static void main(String[] args) {

                try {
                        Properties prop = new Properties();
                        prop.put(Context.INITIAL_CONTEXT_FACTORY,
                                                        "org.apache.openejb.client.RemoteInitialContextFactory");
                        prop.put("java.naming.provider.url", "ejbd://localhost:4201");

                        Context context = new InitialContext(prop);

                        try {
                                CustomerBeanRemote myejb = (CustomerBeanRemote) context
                                                .lookup("CustomerBeanRemote");

                                Company c = new Company();

                                c.setCustomerNumber("asdsd");
                                c.setCustomerType(CustomerType.PLATINUM);
                                c.setIndustry(Industry.EDUCATION);
                                c.setName("kaaaa");

                                Company customer = (Company)myejb.saveCustomer(c);
                               
                                System.out.println(customer.getId()+" "+customer.getName());
                               
                                //getting list of customers works without any problems
                                 List<Customer> klienci = myejb.findAllCustomers();
                               
                                 int i=0;
                                 for (Customer it : klienci) {
                                         System.out.println(it + " #" +i);
                                         i++;
                                 }
                               
                        } catch (Exception e) {
                                e.printStackTrace();
                        } finally {
                                context.close();
                        }
                } catch (NameNotFoundException e) {
                        e.printStackTrace();
                } catch (Exception e) {
                        e.printStackTrace();
                }
        }
}



session bean:



package com.ibm.wasce.customerLocator.ejb.impl;

import com.ibm.wasce.customerLocator.ejb.interfaces.*;
import com.ibm.wasce.customerLocator.entities.*;

import java.net.*;
import javax.ejb.*;
import javax.persistence.*;
import javax.xml.ws.*;
import java.util.*;

@Stateless(name="CustomerBean")
public class CustomerBeanImpl implements CustomerBeanLocal, CustomerBeanRemote {
        @PersistenceContext(unitName="CustomerEJB")
        private EntityManager em;
       
        @EJB(name="PersonBeanLocal")
        PersonBeanLocal personBean;
       
        @EJB(name="CompanyBeanLocal")
        CompanyBeanLocal companyBean;
       
        @EJB(name="AddressBeanLocal")
        private AddressBeanLocal addressBean;
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        protected Customer persist(Customer customer)
        {
                em.persist(customer);
                return customer;
        }
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        protected Customer update(Customer customer)
        {
                em.merge(customer);
                return customer;
        }
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        public Customer saveCustomer(Customer customer)
        {
               
                if(customer.getId() != null && customer.getId() > 0)
                        update(customer);
                else
                        persist(customer);
                return customer;
        }
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        public Customer saveCustomerWithAddress(Customer customer, Address address)
        {
                customer = saveCustomer(customer);
                addAddressToCustomer(customer, address);
                return customer;
        }
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        public Customer addAddressToCustomer(Customer customer, Address address)
        {
                address = addressBean.getOrCreateAddress(address);
                customer.addAddress(address);
                return update(customer);
        }
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        public Customer removeAddressFromCustomer(Customer customer, Address address)
        {
                customer.removeAddress(address);
                return update(customer);
        }
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        public void removeCustomer(Customer customer)
        {
                customer = em.merge(customer);
                em.remove(customer);
        }
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        public List<Customer> findAllCustomers()
        {
                List<Customer> customerList = new ArrayList<Customer>();
                customerList.addAll(personBean.findAllPersons());
                customerList.addAll(companyBean.findAllCompanies());
                return customerList;
        }
       
        @TransactionAttribute(TransactionAttributeType.REQUIRED)
        public List<Customer> findCustomersByName(String searchStr)
        {
                List<Customer> customerList = new ArrayList<Customer>();
                customerList.addAll(personBean.findPersonsByName(searchStr));
                customerList.addAll(companyBean.findCompaniesByName(searchStr));
                return customerList;
        }
}


some logs from server console:



02:33:38,968 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@ac1c43
02:33:38,968 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@ac1c43
02:33:38,984 WARN  [Transaction] Unexpected exception from beforeCompletion; transaction will roll back
<openjpa-1.0.1-r420667:592145 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2107)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1954)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1852)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1770)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:514)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:499)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:400)
        at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:257)
        at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
        at org.apache.openejb.core.transaction.TransactionPolicy.commitTransaction(TransactionPolicy.java:141)
        at org.apache.openejb.core.transaction.TxRequired.afterInvoke(TxRequired.java:75)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:233)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:188)
        at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:165)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:214)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:121)
        at org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:164)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
        at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
        at org.apache.openejb.server.ServiceLogger.service(ServiceLogger.java:76)
        at org.apache.openejb.server.ServiceAccessController.service(ServiceAccessController.java:55)
        at org.apache.openejb.server.ServiceDaemon$1.run(ServiceDaemon.java:118)
        at java.lang.Thread.run(Thread.java:619)
Caused by: <openjpa-1.0.1-r420667:592145 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080504005815981' defined on 'CUSTOMER'. {prepstmnt 25507923 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 211, (String) czaja, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=23505]
FailedObject: com.ibm.wasce.customerLocator.entities.Company@1853928
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3938)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:108)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:203)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
        ... 23 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080504005815981' defined on 'CUSTOMER'. {prepstmnt 25507923 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 211, (String) czaja, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=23505]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:97)
        ... 30 more
02:33:39,031 INFO  [Transaction] The transaction has been rolled back rather than commited: Unable to commit: transaction marked for rollback
02:33:39,062 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@1332b8b
02:33:39,078 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@1332b8b
02:40:19,937 INFO  [OpenEJB] invoking method create on CustomerLocatorEJB_lab4.jar/CustomerBean
02:40:19,937 INFO  [OpenEJB] finished invoking method create
02:40:20,078 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@1568b31
02:40:20,078 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@1568b31
02:40:20,093 WARN  [Transaction] Unexpected exception from beforeCompletion; transaction will roll back
<openjpa-1.0.1-r420667:592145 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2107)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1954)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1852)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1770)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:514)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:499)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:400)
        at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:257)
        at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
        at org.apache.openejb.core.transaction.TransactionPolicy.commitTransaction(TransactionPolicy.java:141)
        at org.apache.openejb.core.transaction.TxRequired.afterInvoke(TxRequired.java:75)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:233)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:188)
        at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:165)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:214)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:121)
        at org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:164)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
        at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
        at org.apache.openejb.server.ServiceLogger.service(ServiceLogger.java:76)
        at org.apache.openejb.server.ServiceAccessController.service(ServiceAccessController.java:55)
        at org.apache.openejb.server.ServiceDaemon$1.run(ServiceDaemon.java:118)
        at java.lang.Thread.run(Thread.java:619)
Caused by: <openjpa-1.0.1-r420667:592145 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080504005815981' defined on 'CUSTOMER'. {prepstmnt 6573606 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 212, (String) czaja, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=23505]
FailedObject: com.ibm.wasce.customerLocator.entities.Company@90b5ce
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3938)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:108)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:203)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
        ... 23 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080504005815981' defined on 'CUSTOMER'. {prepstmnt 6573606 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 212, (String) czaja, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=23505]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:97)
        ... 30 more
02:40:20,125 INFO  [Transaction] The transaction has been rolled back rather than commited: Unable to commit: transaction marked for rollback
02:40:20,156 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@a042dc
02:40:20,171 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@a042dc
02:40:27,781 INFO  [OpenEJB] invoking method create on CustomerLocatorEJB_lab4.jar/CustomerBean
02:40:27,781 INFO  [OpenEJB] finished invoking method create
02:40:27,937 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@1ad1d8
02:40:27,937 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@1ad1d8
02:40:27,984 WARN  [Transaction] Unexpected exception from beforeCompletion; transaction will roll back
<openjpa-1.0.1-r420667:592145 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2107)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1954)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1852)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1770)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:514)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:499)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:400)
        at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:257)
        at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
        at org.apache.openejb.core.transaction.TransactionPolicy.commitTransaction(TransactionPolicy.java:141)
        at org.apache.openejb.core.transaction.TxRequired.afterInvoke(TxRequired.java:75)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:233)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:188)
        at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:165)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:214)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:121)
        at org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:164)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
        at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
        at org.apache.openejb.server.ServiceLogger.service(ServiceLogger.java:76)
        at org.apache.openejb.server.ServiceAccessController.service(ServiceAccessController.java:55)
        at org.apache.openejb.server.ServiceDaemon$1.run(ServiceDaemon.java:118)
        at java.lang.Thread.run(Thread.java:619)
Caused by: <openjpa-1.0.1-r420667:592145 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: A truncation error was encountered trying to shrink VARCHAR 'czajka' to length 5. {prepstmnt 26512745 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 213, (String) czajka, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=22001]
FailedObject: com.ibm.wasce.customerLocator.entities.Company@1a08f61
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3938)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:108)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:203)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
        ... 23 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: A truncation error was encountered trying to shrink VARCHAR 'czajka' to length 5. {prepstmnt 26512745 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 213, (String) czajka, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=22001]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:97)
        ... 30 more
02:40:28,000 INFO  [Transaction] The transaction has been rolled back rather than commited: Unable to commit: transaction marked for rollback
02:40:28,046 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@1dcdd6e
02:40:28,062 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@1dcdd6e
02:40:36,062 INFO  [OpenEJB] invoking method create on CustomerLocatorEJB_lab4.jar/CustomerBean
02:40:36,062 INFO  [OpenEJB] finished invoking method create
02:40:36,187 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@5bb316
02:40:36,187 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@5bb316
02:41:05,062 INFO  [SupportedModesServiceImpl] Portlet mode 'edit' not found for portletId: '/system-database.DBViewer!1771035942|0'
02:41:05,171 INFO  [SupportedModesServiceImpl] Portlet mode 'edit' not found for portletId: '/system-database.RunSQL!1771035942|1'
02:42:01,343 INFO  [OpenEJB] invoking method create on CustomerLocatorEJB_lab4.jar/CustomerBean
02:42:01,343 INFO  [OpenEJB] finished invoking method create
02:42:01,484 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@c33e7a
02:42:01,484 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@c33e7a
02:42:01,484 WARN  [Transaction] Unexpected exception from beforeCompletion; transaction will roll back
<openjpa-1.0.1-r420667:592145 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2107)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1954)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1852)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1770)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:514)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:499)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:400)
        at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:257)
        at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
        at org.apache.openejb.core.transaction.TransactionPolicy.commitTransaction(TransactionPolicy.java:141)
        at org.apache.openejb.core.transaction.TxRequired.afterInvoke(TxRequired.java:75)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:233)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:188)
        at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:165)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:214)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:121)
        at org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:164)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
        at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
        at org.apache.openejb.server.ServiceLogger.service(ServiceLogger.java:76)
        at org.apache.openejb.server.ServiceAccessController.service(ServiceAccessController.java:55)
        at org.apache.openejb.server.ServiceDaemon$1.run(ServiceDaemon.java:118)
        at java.lang.Thread.run(Thread.java:619)
Caused by: <openjpa-1.0.1-r420667:592145 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080504005815981' defined on 'CUSTOMER'. {prepstmnt 33118740 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 215, (String) czaka, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=23505]
FailedObject: com.ibm.wasce.customerLocator.entities.Company@1b93353
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3938)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:108)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:203)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
        ... 23 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080504005815981' defined on 'CUSTOMER'. {prepstmnt 33118740 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 215, (String) czaka, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=23505]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:97)
        ... 30 more
02:42:01,531 INFO  [Transaction] The transaction has been rolled back rather than commited: Unable to commit: transaction marked for rollback
02:42:01,546 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@1c2b27a
02:42:01,562 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@1c2b27a
02:42:06,671 INFO  [OpenEJB] invoking method create on CustomerLocatorEJB_lab4.jar/CustomerBean
02:42:06,671 INFO  [OpenEJB] finished invoking method create
02:42:06,859 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@1fcf6ea
02:42:06,859 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@1fcf6ea
02:45:19,562 INFO  [OpenEJB] invoking method create on CustomerLocatorEJB_lab4.jar/CustomerBean
02:45:19,562 INFO  [OpenEJB] finished invoking method create
02:45:19,687 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@1a10521
02:45:19,687 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@1a10521
02:45:19,703 WARN  [Transaction] Unexpected exception from beforeCompletion; transaction will roll back
<openjpa-1.0.1-r420667:592145 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2107)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1954)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1852)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1770)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:514)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:499)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:400)
        at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:257)
        at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
        at org.apache.openejb.core.transaction.TransactionPolicy.commitTransaction(TransactionPolicy.java:141)
        at org.apache.openejb.core.transaction.TxRequired.afterInvoke(TxRequired.java:75)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:233)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:188)
        at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:165)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:214)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:121)
        at org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:164)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
        at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
        at org.apache.openejb.server.ServiceLogger.service(ServiceLogger.java:76)
        at org.apache.openejb.server.ServiceAccessController.service(ServiceAccessController.java:55)
        at org.apache.openejb.server.ServiceDaemon$1.run(ServiceDaemon.java:118)
        at java.lang.Thread.run(Thread.java:619)
Caused by: <openjpa-1.0.1-r420667:592145 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080504005815981' defined on 'CUSTOMER'. {prepstmnt 25201823 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 217, (String) ozaka, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=23505]
FailedObject: com.ibm.wasce.customerLocator.entities.Company@11f712f
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3938)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:108)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:203)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
        ... 23 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL080504005815981' defined on 'CUSTOMER'. {prepstmnt 25201823 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 217, (String) ozaka, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=23505]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:97)
        ... 30 more
02:45:19,734 INFO  [Transaction] The transaction has been rolled back rather than commited: Unable to commit: transaction marked for rollback
02:45:19,750 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@1a97e6d
02:45:19,765 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@1a97e6d
02:45:24,937 INFO  [OpenEJB] invoking method create on CustomerLocatorEJB_lab4.jar/CustomerBean
02:45:24,937 INFO  [OpenEJB] finished invoking method create
02:45:25,093 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@cf528
02:45:25,093 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@cf528
02:45:25,109 WARN  [Transaction] Unexpected exception from beforeCompletion; transaction will roll back
<openjpa-1.0.1-r420667:592145 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2107)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1954)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1852)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1770)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:514)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:499)
        at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:400)
        at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:257)
        at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245)
        at org.apache.openejb.core.transaction.TransactionPolicy.commitTransaction(TransactionPolicy.java:141)
        at org.apache.openejb.core.transaction.TxRequired.afterInvoke(TxRequired.java:75)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:233)
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:188)
        at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:165)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:214)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:121)
        at org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:164)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
        at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
        at org.apache.openejb.server.ServiceLogger.service(ServiceLogger.java:76)
        at org.apache.openejb.server.ServiceAccessController.service(ServiceAccessController.java:55)
        at org.apache.openejb.server.ServiceDaemon$1.run(ServiceDaemon.java:118)
        at java.lang.Thread.run(Thread.java:619)
Caused by: <openjpa-1.0.1-r420667:592145 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: A truncation error was encountered trying to shrink VARCHAR 'o6zaka' to length 5. {prepstmnt 23977402 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 218, (String) o6zaka, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=22001]
FailedObject: com.ibm.wasce.customerLocator.entities.Company@de6be1
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3938)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:108)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:203)
        at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
        ... 23 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: A truncation error was encountered trying to shrink VARCHAR 'o6zaka' to length 5. {prepstmnt 23977402 INSERT INTO Customer (id, customerNumber, customerType, industry) VALUES (?, ?, ?, ?) [params=(long) 218, (String) o6zaka, (String) PLATINUM, (String) EDUCATION]} [code=20000, state=22001]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:97)
        ... 30 more
02:45:25,140 INFO  [Transaction] The transaction has been rolled back rather than commited: Unable to commit: transaction marked for rollback
02:45:25,156 INFO  [Transaction] TX Required: Started transaction org.apache.geronimo.transaction.manager.TransactionImpl@2c72d6
02:45:25,171 INFO  [Transaction] TX Required: Committing transaction org.apache.geronimo.transaction.manager.TransactionImpl@2c72d6

[pietia]

hi,
I have tested my application on geronimo 2.1.1 without changing any line of source or config.
Works good now!

 But i have another issue - server starts really slow , logs :


10:49:02,625 ERROR [CommandDiscoveryListener] Failed to register command: CommandDescriptor{ source=<null>, id=geronimo-commands:undeploy-module, implementation=org.apache.geronimo.commands.UndeployModuleCommand, description=Undeploy a module, version=<null>, parameters=<null>, requirements=[CommandRequirement{ name=prompter, type=org.apache.geronimo.gshell.console.PromptReader, id=<null>, collection=<null> }], dependencies=<null> }
org.apache.geronimo.gshell.registry.DuplicateRegistrationException: geronimo-commands:undeploy-module
        at org.apache.geronimo.gshell.registry.DefaultCommandRegistry.register(DefaultCommandRegistry.java:51)
        at org.apache.geronimo.gshell.plugin.CommandDiscoveryListener.componentDiscovered(CommandDiscoveryListener.java:75)
        at org.codehaus.plexus.component.discovery.DefaultComponentDiscovererManager.fireComponentDiscoveryEvent(DefaultComponentDiscovererManager.java:76)
        at org.codehaus.plexus.component.discovery.AbstractComponentDiscoverer.findComponents(AbstractComponentDiscoverer.java:125)
        at org.codehaus.plexus.container.initialization.ComponentDiscoveryPhase.discoverComponents(ComponentDiscoveryPhase.java:83)
        at org.codehaus.plexus.container.initialization.ComponentDiscoveryPhase.execute(ComponentDiscoveryPhase.java:45)
        at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:882)
        at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:826)
        at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:416)
        at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:209)
        at org.apache.geronimo.gshell.GShell.<init>(GShell.java:82)
        at org.apache.geronimo.gshell.cli.Main.boot(Main.java:240)
        at org.apache.geronimo.gshell.cli.Main.main(Main.java:266)
        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.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
        at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
        at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
        at org.apache.geronimo.gshell.bootstrap.Launcher.main(Launcher.java:59)

// ^^^ this errors 6 times and then :

Launching Geronimo Server...
Booting Geronimo Kernel (in Java 1.6.0_05)...
Module  1/67 org.apache.geronimo.framework/j2ee-system/2.1.1/car                   started in   .000s
Module  2/67 org.apache.geronimo.framework/jee-specs/2.1.1/car                     started in   .000s
Module  3/67 org.apache.geronimo.framework/rmi-naming/2.1.1/car                    started in  1.984s
Module  4/67 org.apache.geronimo.framework/j2ee-security/2.1.1/car                 started in  6.438s
Module  5/67 org.apache.geronimo.framework/transformer-agent/2.1.1/car             started in   .000s
Module  6/67 org.apache.geronimo.framework/server-security-config/2.1.1/car        started in   .328s
Module  7/67 org.apache.geronimo.framework/xmlbeans/2.1.1/car                      started in   .000s
Module  8/67 org.apache.geronimo.framework/plugin/2.1.1/car                        started in   .516s
Module  9/67 org.apache.geronimo.configs/j2ee-server/2.1.1/car                     started in   .218s
Module 10/67 org.apache.geronimo.configs/myfaces/2.1.1/car                         started in   .062s
Module 11/67 org.apache.geronimo.framework/geronimo-gbean-deployer/2.1.1/car       started in  1.375s
Module 12/67 org.apache.geronimo.configs/j2ee-deployer/2.1.1/car                   started in  1.016s
Module 13/67 org.apache.geronimo.configs/myfaces-deployer/2.1.1/car                started in   .078s
Module 14/67 org.apache.geronimo.configs/derby/2.1.1/car                           started in   .000s
Module 15/67 org.apache.geronimo.configs/transaction/2.1.1/car                     started in  1.390s
Module 16/67 org.apache.geronimo.configs/system-database/2.1.1/car                 started in 15.234s
Module 17/67 org.apache.geronimo.configs/activemq-broker/2.1.1/car                 started in 10.812s
Module 18/67 org.apache.geronimo.configs/activemq-ra/2.1.1/car                     started in  1.671s
Module 19/67 org.apache.geronimo.configs/webservices-common/2.1.1/car              started in   .000s
Module 20/67 org.apache.geronimo.configs/openjpa/2.1.1/car                         started in   .016s
Module 21/67 org.apache.geronimo.configs/openejb/2.1.1/car                         started in  4.281s
Module 22/67 org.apache.geronimo.configs/axis/2.1.1/car                            started in   .578s
Module 23/67 org.apache.geronimo.configs/jasper/2.1.1/car                          started in   .047s
Module 24/67 org.apache.geronimo.configs/tomcat6/2.1.1/car                         started in 54.781s
Module 25/67 org.apache.geronimo.configs/uddi-tomcat/2.1.1/car                     started in  2.547s
Module 26/67 org.apache.geronimo.configs/connector-deployer/2.1.1/car              started in   .406s
Module 27/67 org.apache.geronimo.configs/axis2/2.1.1/car                           started in   .000s
Module 28/67 org.apache.geronimo.configs/jasper-deployer/2.1.1/car                 started in   .062s
Module 29/67 org.apache.geronimo.configs/remote-deploy-tomcat/2.1.1/car            started in  1.078s
Module 30/67 org.apache.geronimo.configs/jaxws-deployer/2.1.1/car                  started in   .000s
Module 31/67 org.apache.geronimo.configs/openejb-deployer/2.1.1/car                started in   .375s
Module 32/67 org.apache.geronimo.configs/jaxws-ejb-deployer/2.1.1/car              started in   .000s
Module 33/67 org.apache.geronimo.configs/axis2-deployer/2.1.1/car                  started in   .172s
Module 34/67 org.apache.geronimo.configs/axis2-ejb/2.1.1/car                       started in   .000s
Module 35/67 org.apache.geronimo.configs/axis2-ejb-deployer/2.1.1/car              started in   .282s
Module 36/67 org.apache.geronimo.configs/ca-helper-tomcat/2.1.1/car                started in   .344s
Module 37/67 org.apache.geronimo.plugins/agent-ds/2.1.1/car                        started in  2.859s
Module 38/67 org.apache.geronimo.configs/mejb/2.1.1/car                            started in   .985s
Module 39/67 org.apache.geronimo.plugins/agent/2.1.1/car                           started in   .578s
Module 40/67 org.apache.geronimo.configs/tomcat6-deployer/2.1.1/car                started in   .297s
Module 41/67 org.apache.geronimo.configs/clustering/2.1.1/car                      started in   .016s
Module 42/67 org.apache.geronimo.configs/tomcat6-clustering-builder-wadi/2.1.1/car started in   .187s
Module 43/67 org.apache.geronimo.configs/spring/2.1.1/car                          started in   .000s
Module 44/67 org.apache.geronimo.plugins/pluto-support/2.1.1/car                   started in   .047s
Module 45/67 org.apache.geronimo.plugins/console-tomcat/2.1.1/car                  started in  8.875s
Module 46/67 org.apache.geronimo.configs/dojo-legacy-tomcat/2.1.1/car              started in   .203s
Module 47/67 org.apache.geronimo.plugins/debugviews-console-tomcat/2.1.1/car       started in   .829s
Module 48/67 org.apache.geronimo.configs/persistence-jpa10-deployer/2.1.1/car      started in   .234s
Module 49/67 org.apache.geronimo.plugins/plugin-console-tomcat/2.1.1/car           started in  1.250s
Module 50/67 org.apache.geronimo.plugins/plancreator-console-tomcat/2.1.1/car      started in   .703s
Module 51/67 org.apache.geronimo.configs/axis-deployer/2.1.1/car                   started in   .282s
Module 52/67 org.apache.geronimo.configs/j2ee-corba-yoko/2.1.1/car                 started in  4.344s
Module 53/67 org.apache.geronimo.configs/hot-deployer/2.1.1/car                    started in  2.766s
Module 54/67 org.apache.geronimo.plugins/sysdb-console-tomcat/2.1.1/car            started in  2.157s
Module 55/67 org.apache.geronimo.configs/openejb-corba-deployer/2.1.1/car          started in   .641s
Module 56/67 org.apache.geronimo.plugins/activemq-console-tomcat/2.1.1/car         started in  1.984s
Module 57/67 org.apache.geronimo.configs/javamail/2.1.1/car                        started in   .125s
Module 58/67 org.apache.geronimo.configs/welcome-tomcat/2.1.1/car                  started in   .360s
Module 59/67 org.apache.geronimo.configs/cxf/2.1.1/car                             started in   .000s
Module 60/67 org.apache.geronimo.configs/sharedlib/2.1.1/car                       started in   .063s
Module 61/67 org.apache.geronimo.plugins/mconsole-ds/2.1.1/car                     started in   .515s
Module 62/67 org.apache.geronimo.plugins/mconsole-tomcat/2.1.1/car                 started in  2.875s
Module 63/67 org.apache.geronimo.configs/client-deployer/2.1.1/car                 started in   .281s
Module 64/67 org.apache.geronimo.configs/cxf-ejb/2.1.1/car                         started in   .000s
Module 65/67 org.apache.geronimo.configs/dojo-tomcat/2.1.1/car                     started in   .219s
Module 66/67 console.dbpool/przychodnia_dbpool/1.0/rar                             started in   .391s
Module 67/67 com.ibm.wasce/customerLocator/1.0/car                                 started in 23.625s
Startup completed in 3:03.875s seconds
  Listening on Ports:
       0 0.0.0.0   Derby Connector
    1050 127.0.0.1 CORBA Naming Service
    1099 0.0.0.0   RMI Naming
    2001 127.0.0.1 OpenEJB ORB Adapter
    4201 0.0.0.0   OpenEJB Daemon
    6882 127.0.0.1 OpenEJB ORB Adapter
    8009 0.0.0.0   Tomcat Connector AJP AJP
    8080 0.0.0.0   Tomcat Connector HTTP BIO HTTP
    8443 0.0.0.0   Tomcat Connector HTTPS BIO HTTPS
    9999 0.0.0.0   JMX Remoting Connector
   61613 0.0.0.0   ActiveMQ Transport Connector
   61616 0.0.0.0   ActiveMQ Transport Connector

  Started Application Modules:
    EAR: com.ibm.wasce/customerLocator/1.0/car
    EAR: org.apache.geronimo.configs/uddi-tomcat/2.1.1/car
    EAR: org.apache.geronimo.plugins/agent/2.1.1/car
    EAR: org.apache.geronimo.plugins/console-tomcat/2.1.1/car
    EAR: org.apache.geronimo.plugins/mconsole-tomcat/2.1.1/car
    JAR: org.apache.geronimo.configs/mejb/2.1.1/car
    RAR: console.dbpool/przychodnia_dbpool/1.0/rar
    RAR: org.apache.geronimo.configs/activemq-ra/2.1.1/car
    RAR: org.apache.geronimo.configs/system-database/2.1.1/car
    RAR: org.apache.geronimo.plugins/agent-ds/2.1.1/car
    RAR: org.apache.geronimo.plugins/mconsole-ds/2.1.1/car
    WAR: org.apache.geronimo.configs/ca-helper-tomcat/2.1.1/car
    WAR: org.apache.geronimo.configs/dojo-legacy-tomcat/2.1.1/car
    WAR: org.apache.geronimo.configs/dojo-tomcat/2.1.1/car
    WAR: org.apache.geronimo.configs/remote-deploy-tomcat/2.1.1/car
    WAR: org.apache.geronimo.configs/welcome-tomcat/2.1.1/car
    WAR: org.apache.geronimo.plugins/activemq-console-tomcat/2.1.1/car
    WAR: org.apache.geronimo.plugins/debugviews-console-tomcat/2.1.1/car
    WAR: org.apache.geronimo.plugins/plancreator-console-tomcat/2.1.1/car
    WAR: org.apache.geronimo.plugins/plugin-console-tomcat/2.1.1/car
    WAR: org.apache.geronimo.plugins/sysdb-console-tomcat/2.1.1/car

  Web Applications:
    /
    /CAHelper
    /CustomerLocator
    /activemq
    /console
    /console-base
    /debug-views
    /dojo
    /dojo/0.4
    /juddi
    /monitoring
    /plan-creator
    /plugin
    /remote-deploy
    /system-database

Geronimo Application Server started
Geronimo Server started in 0:03:24.375
10:52:59,671 ERROR [Connector] Error finding container javax.management.AttributeNotFoundException:  Cannot find attribute managedResource for StandardEngine[Geronimo]
10:52:59,671 ERROR [CoyoteAdapter] An exception or error occurred in the container during the request processing
java.lang.NullPointerException
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Shutting down...

[pietia]

hello again,

After few hours of sleep - i fixed it!  Just reintalled Geronimo 2.1.1.

thanks