Hi, I am using postgreSQL 8 and Jboss 4.0.0 and struggled with the problem you mentioned. The problem stems from the file /deploy/ejb-deployer.xml:
| <attribute name="CreateTableDDL"> | create table TIMERS ( | TIMERID varchar(50) not null, | TARGETID varchar(50) not null, | INITIALDATE timestamp not null, | INTERVAL bigint, | INSTANCEPK other, | INFO other, | constraint timers_pk primary key (TIMERID) | ) | </attribute> | The column type other is not supported in postgreSQL and needs to be replaced by the column type oid. As for the error message telling you that the table timers already exits (workround): 1. Use pgsql to determine the existence of the timers table. If it exists do nothing! 2. If pgsql is not your cup of tea, run Jboss once so that the times table is created, go into ejb-deployer.xml and comment out the create table code , so that the error is not generated if you should need to re-start Jboss. Hope this helps regards Andrew View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3855586#3855586 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3855586 ------------------------------------------------------- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
