0 Replies Latest reply on Jul 24, 2006 11:30 AM by Andrew Dale

    Problems with postgresql and bytea columns

    Andrew Dale Newbie

      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