Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JBoss 4.0.0 using PostgreSQL 8.0.0 as default data source

 
Jeff Pierce
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have setup JBoss to use PostgreSQL 8.0.0-beta4 on Windows as the default data source. EBJs and JMS seem to be working fine. However, on subsequent JBoss startups, the EJBTimerService throws an exception as shown below. I am using JBoss 4.0.0. For now I can get by using the noop persitence policy. I found this bug report CreateTableDDL but I don't know how or if DatabasePersistencePolicy.createTableIfNotExists is a config option.

Is there more config I need to change?

Thanks.

Exception:

ObjectName: jboss.ejb ersistencePolicy=database,service=EJBTimerService
state: FAILED
I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

Depends On Me: java.sql.SQLException: ERROR: relation "timers" already exists

MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.ejb ersistencePolicy=database,service=EJBTimerService
state: FAILED
I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

Depends On Me: java.sql.SQLException: ERROR: relation "timers" already exists
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic