File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in using JDO with Sybase - URGENT!!!" Watch "Problem in using JDO with Sybase - URGENT!!!" New topic
Author

Problem in using JDO with Sybase - URGENT!!!

pauliVicky
Greenhorn

Joined: Jan 12, 2002
Posts: 1
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.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"pauliVicky",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp .
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.
Thanks.
Dave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem in using JDO with Sybase - URGENT!!!
 
Similar Threads
HELP..!! Problem with SybPreparedStatement.addBatch
JDO
Problem with openJpa
Problem with openJPA
Max length of string returned by Resultset