problem with database persistent timers

[lafr]

I tried to use persisted timers with database as store.

On startup WildFly tries to create the table JBOSS_EJB_TIMER and fails, because some datatypes are not known on my IBM Informix Database.

I found the definition of the statements used in file modules/system/layers/base/org/jboss/as/ejb3/main/timers/timer-sql.properties.

Problem datatypes are namely TIMESTAMP that has to be DATETIME YEAR TO FRACTION and LONG has to be INT8 for this system.

I see that there is a create-table.hsql. Is this really used for hsql databases instead of create-table ?

If yes, how to name the statements for IBM Informix database then?

I created the table manually to continue.

But then I get a problem from the "load-timer" SQL.

The statements are defined like shown in this fraction: WHERE TIMED_OBJECT_ID=$1 AND PARTITION=$2.

But parameters have to be simply ? instead of $[1-9]*: WHERE TIMED_OBJECT_ID=? AND PARTITION=?.

That should be compatible for all databases or not?

[ctomc]

I think this whole persistence stuff needs another look.

also looking to the code idea was to have multiple database properties files

all you would need to do is specify database name in configuration of subsystem.