Hello,I was testing a Sequoia setup with one Controller and two Database Backends. All configured with an Oracle 10g Database, also the Recovery Instanz. During my tests if have used the DbVisualizer Version 5.1.1 (License Version) to manipulate the Virtual Database. When i was using the Sql-Window to send update, delete, insert commands everyting works fine. But when i have tried to work with the mouse to select what i want, the following update on Sequoia failed at the Recovery Table. What i have done was to choose inside the Object Menue all Tables. Then i have choosen one Table with "script select all" from this Table. I new sql windows was opened to select everything from the Table [select * from Andreas]. Inside the window the results were shown and on this result i have changed a String Parameter and commited the value. The update on all Databases were done, but with the Recovery i have got the following error message:
java.sql.SQLException: ORA-00911: invalid character.The command is stored inside the Recovery Table but it seems that a following update fails? I have switched to Debug Level so see more whats happening, but i didn't saw the sql statements. The only thing i knew is that a perpared statement was send.
Well the result is, that sequoia says that the Recovery is corrupted.
Is there a possibility to avoid this error ?If not is it possible to find out what sql statements were send to the Recovery Table ?
Am i doing something wrong ? Best Regards Andreas Staab
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
