You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Case Torres <Ca...@casetorrestech.com> on 2007/10/29 18:59:01 UTC
Hangon! - RE: help w/starting release 4.0
Postgres isn't running any longer!!
I didn't kill it so I didn't check it. Yikes!
-----Original Message-----
From: Case Torres [mailto:Case@casetorrestech.com]
Sent: Monday, October 29, 2007 10:44 AM
To: user@ofbiz.apache.org
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:skip@thedevers.org]
Sent: Monday, October 29, 2007 10:39 AM
To: user@ofbiz.apache.org; CaseT@casetorrestech.com
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:Case@casetorrestech.com]
Sent: Monday, October 29, 2007 10:25 AM
To: user@ofbiz.apache.org
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
case@casetorrestech.com