[jboss-user] [JCA/JBoss] - Problems with postgresql and bytea columns

[andydale]

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.

anonymous wrote : 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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3960436#3960436

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3960436