[jboss-jira] [JBoss JIRA] Reopened: (JBAS-1193) EJB Timer DatabasePersistencePlugin issue

EJB Timer DatabasePersistencePlugin issue ----------------------------------------- Key: JBAS-1193 URL: http://jira.jboss.com/jira/browse/JBAS-1193 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: pyuill . In 4.0.1 RC1 the GeneralPurposeDatabasePersistencePlugin was changed to use constants from the DatabasePersistencePlugin interface for column names of the Timer table instead of settable properties. One of the columns (INTERVAL) is a reserved word in MySQL 4.1 I can see three possible routes for the GPDPP: 1) Reinstate the column name properties (perhaps defaulting to the standard values). 2) Respect the reserved word list in standardjbosscmp- jdbc.xml (which can be easily expanded for particular a DBMS). 3) Change the INTERVAL column name. Regards, Peter Yuill