Hi,
We are using Sybase Evaluation Database along with JDO. While inserting data, sometimes we face following errors.
The exception that we get :::
*******************************
NestedException: com.sybase.jdbc.SybSQLException: ASA Error -131: Syntax error near ' '
FailedObjectArray: [com.eq.smile.models.Exercise@1050be] at
com.sun.forte4j.persistence.internal.runtime.core.SqlStore.executeSql (SqlStore.java:741) at
com.sun.forte4j.persistence.internal.runtime.core.SqlStore.update(SqlStore.java:2085)at com.sun.forte4j.persistence.internal.runtime.core.SqlStore.execute(SqlStore.java:424) at com.sun.forte4j.persistence.internal.runtime.core.SqlStateManager.updatePersistent SqlStateManager.java:885) at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerImpl.beforeCompletion PersistenceManagerImpl.java:805) at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerImpl.internalFlush (PersistenceManagerImpl.java:1209) at com.sun.forte4j.persistence.internal.query.QueryImpl.flush(QueryImpl.java:459) at com.sun.forte4j.persistence.internal.query.QueryImpl.execute(QueryImpl.java:336)
*******************************
From the Help Documentation of Sybase, the error no. 131(error no. stated in the exception ), states that these type of error occurs only when the field name is a keyword, but we don't use any keywords as field names in the table.
Hoping to get a solution as soon as possible.
Thanks in advance.
With Regards,
Priyaa.