createDDL for timers does not take care of pk-contraint-template ---------------------------------------------------------------- Key: JBAS-2273 URL: http://jira.jboss.com/jira/browse/JBAS-2273 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: Scheduling/Timers Affects Versions: JBossAS-4.0.3 Final Environment: JBoss 4.0.3RC3, JDK 1.5.0_05, Solaris/SPARC 9 Reporter: Frank Langelage Assigned To: Dimitris Andreadis Priority: Minor Fix For: JBossAS-5.0.0.Beta1, JBossAS-4.0.4RC1 Attachments: diff.txt, GeneralPurposeDatabasePersistencePlugin.java I recently switched the persistence of timers and messages to an Informix datasource instead of hypersonic. The creation of table timers did not succeed, because the order of the constraint name for the PK and the PK's columns has to be just the other way round for informix. For CMP EJB's the is a pk-contraint-template in standardjbosscmp-jdbc.xml. I extended GeneralPurposeDatabasePersistencePlugin.java to use this. The modified file and the cvs diff will be attached shortly. A second issue was the datatype mapping for java.lang.Object. sql-type blob with informix means, you'll have to create an additional dbspace for blob data if you don't have one. The column's data will be stored there. As an alternative you can use datatype byte. The data will be stored inline with the table data in the same dbspace. This is, in my opinion, the better way. So I modified the informix type mapping for this type to jdbc-type LONGVARBINARY and sql-type BYTE. The cvs diff is also attached.