What is you entityengine.xml setting? (attachments don't get through here) Jacques
Le 09/03/2014 17:04, qj a écrit : > Hi , > I'm a programer and studying ofbiz now. I have set up ofbize12.04 and run > it, but some errors occurred. I think there are more than one error in here , > please help me to fix them.Thanks very much. I attached the log info in > bellow: > > > 2014-03-09 21:08:13,500 (OFBiz-config-1) [ DatabaseUtil.java:159:ERROR] > Unable to establish a connection with the database for helperName > [localmysqlolap]... Error was: java.sql.SQLException: Unable to acquire a new > connection from the pool > 2014-03-09 21:08:13,500 (OFBiz-config-1) [ DatabaseUtil.java:986:ERROR] > Unable to establish a connection with the database, no additional information > available. > 2014-03-09 21:08:13,500 (OFBiz-config-1) [ DatabaseUtil.java:197:ERROR] > Could not get table name information from the database, aborting. > 2014-03-09 21:08:25,118 (OFBiz-config-1) [ DatabaseUtil.java:159:ERROR] > Unable to establish a connection with the database for helperName > [localmysqltenant]... Error was: java.sql.SQLException: Unable to acquire a > new connection from the pool > **************** I'm sure the ofbize can connect my local database > succssfully and database is ok **************** > > 2014-03-09 21:13:59,789 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:16:33,684 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:19:03,093 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:21:21,094 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:23:41,203 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:25:49,780 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:27:57,056 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:30:10,021 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:32:23,945 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:34:40,001 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:36:51,391 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > > 2014-03-09 21:39:02,440 (org.ofbiz.service.job.JobPoller@d78ab8) [ > JobManager.java:200:ERROR] > ---- exception report > ---------------------------------------------------------- > Transaction error trying to commit when polling and updating the JobSandbox: > org.ofbiz.entity.transaction.GenericTransactionException: Roll back error > (with no rollbackOnly cause found), could not commit transaction, was rolled > back instead: javax.transaction.RollbackException: Transaction timeout > (Transaction timeout) > Exception: org.ofbiz.entity.transaction.GenericTransactionException > Message: Roll back error (with no rollbackOnly cause found), could not commit > transaction, was rolled back instead: javax.transaction.RollbackException: > Transaction timeout (Transaction timeout) > ---- cause > --------------------------------------------------------------------- > Exception: javax.transaction.RollbackException > Message: Transaction timeout > ---- stack trace > --------------------------------------------------------------- > javax.transaction.RollbackException: Transaction timeout > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:267) > org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253) > org.ofbiz.service.job.JobManager.poll(JobManager.java:196) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:724) > -------------------------------------------------------------------------------- > **************** I don't know why and when occured these > errors**************** > > > > >
