Hi,
Are current message parsing application works perfectly when using Hypersonic as the datasource, but i am currently experiencing a lot of problems when trying to use PostgreSQL (8.1.4) as the datasource.
The currunt description/workflow of the application is as follows. A byte array of around 300 k is received and then an Object is created from it, this is then persisted (via javax.persistance.EntityManager.persist()) and then also flushed. The saved object is then queried and parsed further by the program. This is where the problem occurs because sometimes it cannot find the saved object even though you can view it via the db admin GUI. It is like it is trying to query the object before it is properly saved in the DB and thus returning null from the DB.
I am also getting lots of error/warning messages in the log file like the one below.
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Warning: 0, SQLState: 00000
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] StartTransactionCommand
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Warning: 0, SQLState: 00000
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] ProcessUtility
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Warning: 0, SQLState: 00000
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] CommitTransactionCommand
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Warning: 0, SQLState: 00000
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] CommitTransaction
2006-07-24 15:02:21,204 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Warning: 0, SQLState: 00000
Has anybody else experienced a similar issue to this when using Postgres as the datasource, and if so how should i go about fixing it?
Thanks,
Andy
