File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problem in using JDO with Sybase - URGENT!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem in using JDO with Sybase - URGENT!!!" Watch "Problem in using JDO with Sybase - URGENT!!!" New topic

Problem in using JDO with Sybase - URGENT!!!


Joined: Jan 12, 2002
Posts: 1
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: [] at
com.sun.forte4j.persistence.internal.runtime.core.SqlStore.executeSql ( at
com.sun.forte4j.persistence.internal.runtime.core.SqlStore.update( com.sun.forte4j.persistence.internal.runtime.core.SqlStore.execute( at com.sun.forte4j.persistence.internal.runtime.core.SqlStateManager.updatePersistent at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerImpl.beforeCompletion at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerImpl.internalFlush ( at com.sun.forte4j.persistence.internal.query.QueryImpl.flush( at com.sun.forte4j.persistence.internal.query.QueryImpl.execute(
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,
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please re-register and select a new name which meets the requirements.
I agree. Here's the link:
subject: Problem in using JDO with Sybase - URGENT!!!
It's not a secret anymore!