[jboss-jira] [JBoss JIRA] Reopened: (JBAS-1081) CreateTableDDL for EJBTimerService

CreateTableDDL for EJBTimerService ---------------------------------- Key: JBAS-1081 URL: http://jira.jboss.com/jira/browse/JBAS-1081 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: Scheduling/Timers Affects Versions: JBossAS-4.0.0 Final Reporter: SourceForge User Assigned To: Thomas Diesler Fix For: Closed issues from sourceforge SourceForge Submitter: juanmartinez . Hi. I don't if should report this as a bug, so feel free to delete this report. I'm using Branch_4_0 with the PostgreSQL as the only datasource (requirement). The EJBTimerService has the CreateTableDDL element defined as <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> which is a problem for PostgreSQL since the datatype "other" isn't defined (INSTANCEPK and INFO). I'm hoping that another (standard) datatype could be used or samples for the different database mappings could be provided. Let me know if I can provide more information. Juan