Hi Eric,
I currently have a dual controller sequoia cluster with co-located
MySQL Databases. I am getting the following error when my JDBC
connected Java program issues an insert. "Backend <XXX> does not
support auto generated keys". Does Sequoia not support auto
incrementers at all?
Sequoia supports the JDBC3 call Statement.executeUpdate(sql,
Statement.RETURN_GENERATED_KEYS) which is the standard way of using
auto-generated keys in JDBC.
The message that you see saying "Backend <XXX> does not support auto
generated keys" means that your database driver does not implement this
call (or returns an error when it is invoked).
If you want to retrieve inserted keys using database specific extensions
like 'select last_insert_id', you will have to use persistent
connections but this is not recommended.
Hope this helps,
Emmanuel
--
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
