Hi Andreas,
It looks like the error you get is either a problem with a column name
(could you post your recovery log config?) or some encoding of the
PreparedStatement that needs to be logged into the recovery log.
Could you post the PreparedStatement that you are trying to execute? If
you set
log4j.logger.org.continuent.sequoia.controller.virtualdatabase.request
to DEBUG in log4j.properties, that should log the encoded
PreparedStatement that are sent to the recovery log.
Thanks for your interest in Sequoia,
Emmanuel
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
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [email protected]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
