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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JBoss 4.0.0 using PostgreSQL 8.0.0 as default data source
 
Similar Threads
CMP Roster example
JBOSS sample portlet
hibernate
Exception thrown org.jboss.util.NestedSQLException
[AbstractKernelController] Error installing to Instantiated: name=TransactionManager