Openfire.script ignores DELETE and UPDATE sql commands

Hello all,

Maybe someone can shed some light or insight for an issue I have.

I have a script that will look on the LDAP for users of a particular group and then:

  1. Stops the Openfire service

  2. Writes SQL statements on the openfire.script file

DELETE FROM OFPROPERTY WHERE NAME='admin.authorizedJIDs';
INSERT INTO OFPROPERTY VALUES('admin.authorizedJIDs','admin@example-com,new@example.com');
COMMIT;
  1. Starts the Openfire service.

Upon start, info.log says “Unique constraint violation” on line INSERT… it seems it’s not deleting from the table as expected. Can anyone shed some light on this? What can be happening here?

If I open the openfire.script with the hsqldb.jar it says the same thing.

Edit: Also, UPDATE commands are not taken in consideration. I have no idea why this is happening. I will have to sed the file with my script and change the settings in place…

I am running Openfire 3.9.3 on Solaris 10.

Thanks,

bmelo

Message was edited by: bmelo
Update command is also not taken in consideration