Hi, I use the default one: mysql-connector-java-3.0.17-ga-bin.jar
But everything works fine during something like 1 or 2 week, and after a while I get this error. And then I need to restart ofbiz .... Regards. -----Message d'origine----- De : Chris Howe [mailto:[EMAIL PROTECTED] Envoyé : jeudi 19 avril 2007 18:58 À : [email protected] Objet : Re: TR: ofbiz down ******* ERROR: No database connection found for helperName "localmysql" Have you copied the correct mysql jdbc driver to ofbiz.home/framework/entity/lib/jdbc ??? --- Passalacqua Nicolas <[EMAIL PROTECTED]> wrote: > > -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] De la part de Ashish > Vijaywargiya > Envoyé : jeudi 19 avril 2007 15:19 > À : [email protected] > Objet : Re: ofbiz down > > > Hi Nick, > > It might be much better if you will provide some more details. > > 1) Log Error. > Please find them below.... > > 2) Which revision of Ofbiz are you using ?? > I currently use opentaps 0.9.2 > > 3) Have you kept the postgres connector in framework/entity/lib/jdbc > ?? > I kept it. Actually the application run but after a few day I get > this error. > > > > > --- runtime exception report > -------------------------------------------------- > There was an error getting a Minerva datasource. > Exception: java.lang.RuntimeException > Message: Unable to setTransactionIsolation: Communication link > failure: java.io.EOFException, underlying cause: null > > ** BEGIN NESTED EXCEPTION ** > > java.io.EOFException > > STACKTRACE: > > java.io.EOFException > at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1395) > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1539) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225) > at com.mysql.jdbc.Connection.execSQL(Connection.java:2278) > at com.mysql.jdbc.Connection.execSQL(Connection.java:2237) > at com.mysql.jdbc.Connection.execSQL(Connection.java:2218) > at > com.mysql.jdbc.Connection.setTransactionIsolation(Connection.java:913) > at > org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAConnectionImpl.setTransactionIsolation(XAConnectionImpl.java:117) > at > org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:412) > at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:645) > at > org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:355) > at > org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:56) > at > org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:92) > at > org.ofbiz.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:158) > at > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:104) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:82) > at > org.ofbiz.entity.util.SequenceUtil$SequenceBank.fillBank(SequenceUtil.java:177) > at > org.ofbiz.entity.util.SequenceUtil$SequenceBank.<init>(SequenceUtil.java:120) > at > org.ofbiz.entity.util.SequenceUtil.getNextSeqId(SequenceUtil.java:94) > at > org.ofbiz.entity.GenericDelegator.getNextSeqIdLong(GenericDelegator.java:2514) > at > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2450) > at > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2434) > at > org.ofbiz.order.order.OrderServices.setItemStatus(OrderServices.java:1717) > 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:324) > at > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > at > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > at > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:342) > at > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > at > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > at > org.ofbiz.order.order.OrderServices.cancelFlaggedSalesOrders(OrderServices.java:2493) > 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:324) > at > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > at > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > at > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:342) > at > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > at > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > at > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > at org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > at java.lang.Thread.run(Thread.java:534) > > > ** END NESTED EXCEPTION ** > > > ---- stack trace > --------------------------------------------------------------- > java.lang.RuntimeException: Unable to setTransactionIsolation: > Communication link failure: java.io.EOFException, underlying cause: > null > ** BEGIN NESTED EXCEPTION ** > java.io.EOFException > STACKTRACE: > java.io.EOFException > com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1395) > com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1539) > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930) > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) > com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) > com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225) > com.mysql.jdbc.Connection.execSQL(Connection.java:2278) > com.mysql.jdbc.Connection.execSQL(Connection.java:2237) > com.mysql.jdbc.Connection.execSQL(Connection.java:2218) > com.mysql.jdbc.Connection.setTransactionIsolation(Connection.java:913) > org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAConnectionImpl.setTransactionIsolation(XAConnectionImpl.java:117) > org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:412) > org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:645) > org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:355) > org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:56) > org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:92) > org.ofbiz.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:158) > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:104) > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:82) > org.ofbiz.entity.util.SequenceUtil$SequenceBank.fillBank(SequenceUtil.java:177) > org.ofbiz.entity.util.SequenceUtil$SequenceBank.<init>(SequenceUtil.java:120) > org.ofbiz.entity.util.SequenceUtil.getNextSeqId(SequenceUtil.java:94) > org.ofbiz.entity.GenericDelegator.getNextSeqIdLong(GenericDelegator.java:2514) > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2450) > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2434) > org.ofbiz.order.order.OrderServices.setItemStatus(OrderServices.java:1717) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:342) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.order.order.OrderServices.cancelFlaggedSalesOrders(OrderServices.java:2493) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:342) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > ** END NESTED EXCEPTION ** > org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:414) > org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:645) > org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:355) > org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:56) > org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:92) > org.ofbiz.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:158) > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:104) > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:82) > org.ofbiz.entity.util.SequenceUtil$SequenceBank.fillBank(SequenceUtil.java:177) > org.ofbiz.entity.util.SequenceUtil$SequenceBank.<init>(SequenceUtil.java:120) > org.ofbiz.entity.util.SequenceUtil.getNextSeqId(SequenceUtil.java:94) > org.ofbiz.entity.GenericDelegator.getNextSeqIdLong(GenericDelegator.java:2514) > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2450) > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2434) > org.ofbiz.order.order.OrderServices.setItemStatus(OrderServices.java:1717) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > === message truncated ===
