That's approximately OFBIZ SVN r 5560
On Aug 25, 2006, at 1:31 AM, Zaoui Bruno wrote:
Hi
I'm using SequoiaERP 0.83
-----Message d'origine-----
De : David E Jones [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 25 août 2006 10:29
À : [email protected]
Objet : [Spam][Spam]Re: Postgres : Lost connexion with my Postgres
Database while an EntitySync
Which version/revision of OFBiz are you using?
-David
On Aug 24, 2006, at 2:25 AM, Zaoui Bruno wrote:
Hello,
When I synchronize lot of data by EntitySync, the remote server
after a
while, lost his connexion to the database (see logs at the end of the
mail).
I've tried to increase the pool-maxsize of the entityengine.xml
file but
I keep my problem.
Could you please explain me what could happen?
Should I change the postgres configuration?
My config :
Postgres 8.0.1 under Linux Debian
I use
org.ofbiz.service.rmi.socket.zip.CompressionClientSocketFactory and
org.ofbiz.service.rmi.socket.zip.CompressionServerSocketFactory
entityengine.xml :
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://xxx.xxx.xxx.xxx:5432/
TOTO"
jdbc-username="toto"
jdbc-password="toto"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="100"/>
1036559051[ ConnectionFactory.java:54 :ERROR] ******* ERROR: No
database connection found for helperName "localpostgres"
1036559052[ SequenceUtil.java:283:ERROR]
---- exception report
----------------------------------------------------------
General error in getting a sequenced ID
Exception: org.ofbiz.entity.GenericEntityException
Message: [SequenceUtil.SequenceBank.fillBank]: Unable to esablish a
connection with the database, connection was null...
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException:
[SequenceUtil.SequenceBank.fillBank]: Unable to esablish a connection
with the database, connection was null...
org.ofbiz.entity.util.SequenceUtil$SequenceBank.fillBank
(SequenceUtil.ja
va:187)
org.ofbiz.entity.util.SequenceUtil$SequenceBank.getNextSeqId
(SequenceUti
l.java:135)
org.ofbiz.entity.util.SequenceUtil.getNextSeqId(SequenceUtil.java:99)
org.ofbiz.entity.GenericDelegator.getNextSeqIdLong
(GenericDelegator.java
:2643)
org.ofbiz.entity.GenericDelegator.getNextSeqId
(GenericDelegator.java:257
9)
org.ofbiz.entity.GenericDelegator.getNextSeqId
(GenericDelegator.java:256
3)
org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo
(GenericDelega
tor.java:687)
org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:
841)
org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:
808)
org.ofbiz.entityext.synchronization.EntitySyncServices.storeEntitySyn
c
Da
ta(EntitySyncServices.java:359)
sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessor
Impl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker
(StandardJavaE
ngine.java:101)
org.ofbiz.service.engine.StandardJavaEngine.runSync
(StandardJavaEngine.j
ava:63)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
339)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
213)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
110)
org.ofbiz.service.rmi.RemoteDispatcherImpl.runSync
(RemoteDispatcherImpl.
java:62)
sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessor
Impl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
sun.rmi.transport.Transport$1.run(Transport.java:148)
java.security.AccessController.doPrivileged(Native Method)
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:
460)
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run
(TCPTransport.ja
va:701)
java.lang.Thread.run(Thread.java:534)
---------------------------------------------------------------------
-
--
--------
Thanks
Bruno
