File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Android Security Essentials Live Lessons this week in the Android 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
 
Consider Paul's rocket mass heater.
 
subject: JBoss 4.0.0 using PostgreSQL 8.0.0 as default data source
 
Similar Threads
JBOSS sample portlet
CMP Roster example
hibernate
[AbstractKernelController] Error installing to Instantiated: name=TransactionManager
Exception thrown org.jboss.util.NestedSQLException