help w/starting release 4.0
Locked
 
|
Hi,
Lessons in how to totally screw up a perfectly running ofbiz application... It appears I've incorrectly gone about the task as listed below :-} . Any help would be greatly appreciated. I had the lastest trunk version of ofbiz running on my dev server (RHEL4, PostgreSQL8.2.4). I believe it was 585993. I wanted to switch it out mirror the production server which meant checking out the release4.0 version. I'm rather new to svn and did try to just svn co the release version but I received not an error but a comment indicating I could not download it. I apoligize as I did not save the message. At any rate, at that point, here are the steps I took: - killed the ofbiz and java processes - deleted the ofbiz directory - svn co'd the Release 4.0 version 589691 - change datasource to localpostgres - edit localpostgres w/ correct username and password - copied correct jdbc driver to .../jdbc directory - started ofbiz: ./startofbiz.sh& Upon browsing to https://127.0.0.1:8443/webtools/control/main I'm getting an "Exception Error". Please see message below. In addition, the rolling console.log in my terminal is indicating errors and I've included those messages as well type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception java.lang.IllegalArgumentException: Could not get next sequenced ID for sequence name: ServerHitBin org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2442) org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2428) org.ofbiz.webapp.stats.ServerHitBin.advanceBin(ServerHitBin.java:552) org.ofbiz.webapp.stats.ServerHitBin.addHit(ServerHitBin.java:506) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:206) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs. org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) Case Torres [hidden email] |
|
|
Case
I am betting you got the database connection info wrong or the server is not running Skip -----Original Message----- From: Case Torres [mailto:[hidden email]] Sent: Monday, October 29, 2007 10:25 AM To: [hidden email] Subject: help w/starting release 4.0 Hi, Lessons in how to totally screw up a perfectly running ofbiz application... It appears I've incorrectly gone about the task as listed below :-} . Any help would be greatly appreciated. I had the lastest trunk version of ofbiz running on my dev server (RHEL4, PostgreSQL8.2.4). I believe it was 585993. I wanted to switch it out mirror the production server which meant checking out the release4.0 version. I'm rather new to svn and did try to just svn co the release version but I received not an error but a comment indicating I could not download it. I apoligize as I did not save the message. At any rate, at that point, here are the steps I took: - killed the ofbiz and java processes - deleted the ofbiz directory - svn co'd the Release 4.0 version 589691 - change datasource to localpostgres - edit localpostgres w/ correct username and password - copied correct jdbc driver to .../jdbc directory - started ofbiz: ./startofbiz.sh& Upon browsing to https://127.0.0.1:8443/webtools/control/main I'm getting an "Exception Error". Please see message below. In addition, the rolling console.log in my terminal is indicating errors and I've included those messages as well type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception java.lang.IllegalArgumentException: Could not get next sequenced ID for sequence name: ServerHitBin org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2442) org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2428) org.ofbiz.webapp.stats.ServerHitBin.advanceBin(ServerHitBin.java:552) org.ofbiz.webapp.stats.ServerHitBin.addHit(ServerHitBin.java:506) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:206) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs. org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) Case Torres [hidden email] |
|
|
Just checked it again and the username and password are correct.
Here's some further info from the ofbiz.log: 2007-10-29 11:05:52,068 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:200:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: null ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(Ge ronimoTransactionManager.java:82) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:179 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:05:52,069 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:186:ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:201 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,083 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 29 more 2007-10-29 11:06:12,085 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:12,284 (org.ofbiz.service.job.JobPoller@3c2378) [GeronimoTransactionFactory.java:97 :ERROR] ---- runtime exception report -------------------------------------------------- Geronimo is the configured transaction manager but there was an error getting a database Connection through Geronimo for the localpostgres datasource. Please check your configuration, class path, etc. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,286 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 30 more 2007-10-29 11:06:12,288 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:12,298 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:85 :ERROR] ---- runtime exception report -------------------------------------------------- There was an error getting a Minerva datasource. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,299 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:74 :ERROR] ******* ERROR: No database connection found for helperName "localpostgres" 2007-10-29 11:06:12,300 (org.ofbiz.service.job.JobPoller@3c2378) [ GenericDelegator.java:949:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,317 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:291:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil .java:291) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:2 38) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:952 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,338 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:154:ERROR] ---- exception report ---------------------------------------------------------- Cannot load jobs from datasource. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,339 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:200:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: null ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(Ge ronimoTransactionManager.java:82) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:179 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,353 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:186:ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:201 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,622 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 29 more 2007-10-29 11:06:32,624 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:32,630 (org.ofbiz.service.job.JobPoller@3c2378) [GeronimoTransactionFactory.java:97 :ERROR] ---- runtime exception report -------------------------------------------------- Geronimo is the configured transaction manager but there was an error getting a database Connection through Geronimo for the localpostgres datasource. Please check your configuration, class path, etc. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,642 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 30 more 2007-10-29 11:06:32,656 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:32,690 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:85 :ERROR] ---- runtime exception report -------------------------------------------------- There was an error getting a Minerva datasource. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,691 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:74 :ERROR] ******* ERROR: No database connection found for helperName "localpostgres" 2007-10-29 11:06:32,692 (org.ofbiz.service.job.JobPoller@3c2378) [ GenericDelegator.java:949:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,707 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:291:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil .java:291) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:2 38) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:952 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,720 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:154:ERROR] ---- exception report ---------------------------------------------------------- Cannot load jobs from datasource. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,721 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:200:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: null ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(Ge ronimoTransactionManager.java:82) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:179 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,740 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:186:ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:201 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:52,760 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 29 more 2007-10-29 11:06:53,052 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:53,248 (org.ofbiz.service.job.JobPoller@3c2378) [GeronimoTransactionFactory.java:97 :ERROR] ---- runtime exception report -------------------------------------------------- Geronimo is the configured transaction manager but there was an error getting a database Connection through Geronimo for the localpostgres datasource. Please check your configuration, class path, etc. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:53,544 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 30 more 2007-10-29 11:06:53,859 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:54,057 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:85 :ERROR] ---- runtime exception report -------------------------------------------------- There was an error getting a Minerva datasource. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,257 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:74 :ERROR] ******* ERROR: No database connection found for helperName "localpostgres" 2007-10-29 11:06:54,347 (org.ofbiz.service.job.JobPoller@3c2378) [ GenericDelegator.java:949:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,444 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:291:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil .java:291) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:2 38) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:952 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,541 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:154:ERROR] ---- exception report ---------------------------------------------------------- Cannot load jobs from datasource. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,623 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:200:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: null ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(Ge ronimoTransactionManager.java:82) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:179 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,630 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:186:ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:201 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) -----Original Message----- From: skip@theDevers [mailto:[hidden email]] Sent: Monday, October 29, 2007 10:39 AM To: [hidden email]; [hidden email] Subject: RE: help w/starting release 4.0 Case I am betting you got the database connection info wrong or the server is not running Skip -----Original Message----- From: Case Torres [mailto:[hidden email]] Sent: Monday, October 29, 2007 10:25 AM To: [hidden email] Subject: help w/starting release 4.0 Hi, Lessons in how to totally screw up a perfectly running ofbiz application... It appears I've incorrectly gone about the task as listed below :-} . Any help would be greatly appreciated. I had the lastest trunk version of ofbiz running on my dev server (RHEL4, PostgreSQL8.2.4). I believe it was 585993. I wanted to switch it out mirror the production server which meant checking out the release4.0 version. I'm rather new to svn and did try to just svn co the release version but I received not an error but a comment indicating I could not download it. I apoligize as I did not save the message. At any rate, at that point, here are the steps I took: - killed the ofbiz and java processes - deleted the ofbiz directory - svn co'd the Release 4.0 version 589691 - change datasource to localpostgres - edit localpostgres w/ correct username and password - copied correct jdbc driver to .../jdbc directory - started ofbiz: ./startofbiz.sh& Upon browsing to https://127.0.0.1:8443/webtools/control/main I'm getting an "Exception Error". Please see message below. In addition, the rolling console.log in my terminal is indicating errors and I've included those messages as well type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception java.lang.IllegalArgumentException: Could not get next sequenced ID for sequence name: ServerHitBin org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2442) org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2428) org.ofbiz.webapp.stats.ServerHitBin.advanceBin(ServerHitBin.java:552) org.ofbiz.webapp.stats.ServerHitBin.addHit(ServerHitBin.java:506) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:206) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs. org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) Case Torres [hidden email] |
|
|
Postgres isn't running any longer!!
I didn't kill it so I didn't check it. Yikes! -----Original Message----- From: Case Torres [mailto:[hidden email]] Sent: Monday, October 29, 2007 10:44 AM To: [hidden email] Subject: RE: help w/starting release 4.0 Just checked it again and the username and password are correct. Here's some further info from the ofbiz.log: 2007-10-29 11:05:52,068 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:200:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: null ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(Ge ronimoTransactionManager.java:82) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:179 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:05:52,069 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:186:ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:201 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,083 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 29 more 2007-10-29 11:06:12,085 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:12,284 (org.ofbiz.service.job.JobPoller@3c2378) [GeronimoTransactionFactory.java:97 :ERROR] ---- runtime exception report -------------------------------------------------- Geronimo is the configured transaction manager but there was an error getting a database Connection through Geronimo for the localpostgres datasource. Please check your configuration, class path, etc. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,286 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 30 more 2007-10-29 11:06:12,288 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:12,298 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:85 :ERROR] ---- runtime exception report -------------------------------------------------- There was an error getting a Minerva datasource. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,299 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:74 :ERROR] ******* ERROR: No database connection found for helperName "localpostgres" 2007-10-29 11:06:12,300 (org.ofbiz.service.job.JobPoller@3c2378) [ GenericDelegator.java:949:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,317 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:291:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil .java:291) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:2 38) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:952 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,338 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:154:ERROR] ---- exception report ---------------------------------------------------------- Cannot load jobs from datasource. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,339 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:200:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: null ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(Ge ronimoTransactionManager.java:82) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:179 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:12,353 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:186:ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:201 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,622 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 29 more 2007-10-29 11:06:32,624 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:32,630 (org.ofbiz.service.job.JobPoller@3c2378) [GeronimoTransactionFactory.java:97 :ERROR] ---- runtime exception report -------------------------------------------------- Geronimo is the configured transaction manager but there was an error getting a database Connection through Geronimo for the localpostgres datasource. Please check your configuration, class path, etc. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,642 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 30 more 2007-10-29 11:06:32,656 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:32,690 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:85 :ERROR] ---- runtime exception report -------------------------------------------------- There was an error getting a Minerva datasource. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,691 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:74 :ERROR] ******* ERROR: No database connection found for helperName "localpostgres" 2007-10-29 11:06:32,692 (org.ofbiz.service.job.JobPoller@3c2378) [ GenericDelegator.java:949:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,707 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:291:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil .java:291) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:2 38) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:952 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,720 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:154:ERROR] ---- exception report ---------------------------------------------------------- Cannot load jobs from datasource. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,721 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:200:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: null ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(Ge ronimoTransactionManager.java:82) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:179 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:32,740 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:186:ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:201 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:52,760 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 29 more 2007-10-29 11:06:53,052 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:53,248 (org.ofbiz.service.job.JobPoller@3c2378) [GeronimoTransactionFactory.java:97 :ERROR] ---- runtime exception report -------------------------------------------------- Geronimo is the configured transaction manager but there was an error getting a database Connection through Geronimo for the localpostgres datasource. Please check your configuration, class path, etc. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:94) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:53,544 (org.ofbiz.service.job.JobPoller@3c2378) [XAConnectionFactory.java:371:ERROR] Can't get an XAConnection org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:122) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java: 66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection. java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection. java:30) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection. java:18) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADa taSourceImpl.java:223) at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnection Factory.java:365) at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:180) at org.postgresql.core.PGStream.<init>(PGStream.java:59) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa ctoryImpl.java:77) ... 30 more 2007-10-29 11:06:53,859 (org.ofbiz.service.job.JobPoller@3c2378) [ ObjectPool.java:632:ERROR] Exception in creating new object for pool java.lang.RuntimeException: Could not create connection at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) at org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) at org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) at org.ofbiz.service.job.JobManager.poll(JobManager.java:148) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) at java.lang.Thread.run(Thread.java:619) 2007-10-29 11:06:54,057 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:85 :ERROR] ---- runtime exception report -------------------------------------------------- There was an error getting a Minerva datasource. Exception: java.lang.RuntimeException Message: Could not create connection ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: Could not create connection org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944) org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSour ce.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaC onnectionFactory.java:46) org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(Connecti onFactory.java:82) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransact ionFactory.java:100) org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFac tory.java:95) org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java :72) org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,257 (org.ofbiz.service.job.JobPoller@3c2378) [ ConnectionFactory.java:74 :ERROR] ******* ERROR: No database connection found for helperName "localpostgres" 2007-10-29 11:06:54,347 (org.ofbiz.service.job.JobPoller@3c2378) [ GenericDelegator.java:949:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,444 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:291:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil .java:291) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:2 38) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:952 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,541 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:154:ERROR] ---- exception report ---------------------------------------------------------- Cannot load jobs from datasource. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,623 (org.ofbiz.service.job.JobPoller@3c2378) [ TransactionUtil.java:200:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: null ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(Ge ronimoTransactionManager.java:82) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:179 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) ---------------------------------------------------------------------------- ---- 2007-10-29 11:06:54,630 (org.ofbiz.service.job.JobPoller@3c2378) [ JobManager.java:186:ERROR] ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) (Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!)) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:201 ) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:165 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:184) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) -----Original Message----- From: skip@theDevers [mailto:[hidden email]] Sent: Monday, October 29, 2007 10:39 AM To: [hidden email]; [hidden email] Subject: RE: help w/starting release 4.0 Case I am betting you got the database connection info wrong or the server is not running Skip -----Original Message----- From: Case Torres [mailto:[hidden email]] Sent: Monday, October 29, 2007 10:25 AM To: [hidden email] Subject: help w/starting release 4.0 Hi, Lessons in how to totally screw up a perfectly running ofbiz application... It appears I've incorrectly gone about the task as listed below :-} . Any help would be greatly appreciated. I had the lastest trunk version of ofbiz running on my dev server (RHEL4, PostgreSQL8.2.4). I believe it was 585993. I wanted to switch it out mirror the production server which meant checking out the release4.0 version. I'm rather new to svn and did try to just svn co the release version but I received not an error but a comment indicating I could not download it. I apoligize as I did not save the message. At any rate, at that point, here are the steps I took: - killed the ofbiz and java processes - deleted the ofbiz directory - svn co'd the Release 4.0 version 589691 - change datasource to localpostgres - edit localpostgres w/ correct username and password - copied correct jdbc driver to .../jdbc directory - started ofbiz: ./startofbiz.sh& Upon browsing to https://127.0.0.1:8443/webtools/control/main I'm getting an "Exception Error". Please see message below. In addition, the rolling console.log in my terminal is indicating errors and I've included those messages as well type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception java.lang.IllegalArgumentException: Could not get next sequenced ID for sequence name: ServerHitBin org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2442) org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2428) org.ofbiz.webapp.stats.ServerHitBin.advanceBin(ServerHitBin.java:552) org.ofbiz.webapp.stats.ServerHitBin.addHit(ServerHitBin.java:506) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:206) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs. org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) Case Torres [hidden email] |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |