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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...