This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JBoss/WildFly and the fly likes JBoss 4.0.0 using PostgreSQL 8.0.0 as default data source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "JBoss 4.0.0 using PostgreSQL 8.0.0 as default data source" Watch "JBoss 4.0.0 using PostgreSQL 8.0.0 as default data source" New topic
Author

JBoss 4.0.0 using PostgreSQL 8.0.0 as default data source

Jeff Pierce
Greenhorn

Joined: Jan 04, 2002
Posts: 13
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JBoss 4.0.0 using PostgreSQL 8.0.0 as default data source