[jboss-dev-forums] [Design of JBoss Portal] - Re: Portal 2.7 with Postgres

[sdomsta]

I have also received this error (using PostgreSQL 8.1):
JBoss Portal Release: jboss-portal-2.7.0.CR1
Using JDBC3 library: postgresql-8.1-404.jdbc3.jar

13:18:17,744 INFO  [RepositoryImpl] Starting repository...
  | 13:18:18,488 INFO  [NodeTypeRegistry] no custom node type definitions found
  | 13:18:18,625 INFO  [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache in the background (started).......
  | 13:18:18,633 INFO  [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/wsp_prop (finished).......
  | 13:18:18,634 INFO  [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/version_prop (finished).......
  | 13:18:18,643 INFO  [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/version_node (finished).......
  | 13:18:18,643 INFO  [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/wsp_ref (finished).......
  | 13:18:18,644 INFO  [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/wsp_node (finished).......
  | 13:18:18,657 INFO  [JBossCachePersistenceManager] Pre-loading the PersistenceManager Cache for/version_ref (finished).......
  | 13:18:20,636 INFO  [JBossCachePersistenceManager] -------------------------------------------------
  | 13:18:20,636 INFO  [JBossCachePersistenceManager] JBossCachePersistenceManager is fully loaded.....
  | 13:18:20,636 INFO  [JBossCachePersistenceManager] -------------------------------------------------
  | 13:18:20,746 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
  | 13:18:20,746 ERROR [JDBCExceptionReporter] Batch entry 0 insert into jbp_cms_version_node (NODE_ID, NODE_DATA, PK) values (deadbeef-face-babe-cafe-babecafebabe, <stream of 109 bytes>, 30) was aborted.  Call getNextException to see the cause.
  | 13:18:20,746 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 42804
  | 13:18:20,746 ERROR [JDBCExceptionReporter] ERROR: column "node_data" is of type oid but expression is of type bytea
  | 13:18:20,747 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
  | org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
  | 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
  | 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  | 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
  | 	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
  | 	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
  | 	at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
  | ...
  | 

I haven't found a solution to this yet.

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

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