For short I'm using OJB within a webapplication to manage my data in an existing MySQL Database. It works fine, except one thing: After inserting a new item/row to the table, i get following exception:
[org.apache.ojb.broker.core.PersistenceBrokerImpl] ERROR: SQLException during SequenceManager.afterStore (for a jsfweboffice.model.Worktime): java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'LIMIT 1' at line 1" java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'LIMIT 1' at line 1" org.apache.ojb.broker.util.sequence.SequenceManagerException: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'LIMIT 1' at line 1" at org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.getLastInsert( Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl.afterStore(Unk nown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at jsfweboffice.WorktimeBean.actionSave(WorktimeBean.java:289) The insert itself has worked. I'm using: - db-ojb-1.0.rc5 - mysql-connector-java-3.0.11-stable - MySQL 3.23.24 (could it be a version problem?, since I'm not sure if this error occured when connecting to a quite young 4.XX mysql too, but I can't access this db and check that right now!) Thanks for a hints and best regards Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
