It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes JDO Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDO" Watch "JDO" New topic


Thiru Narayanan

Joined: Apr 30, 2001
Posts: 23
There is an exception when using Sybase with the JDO engine availabe with Forte4J. Can anybody suggest some solution to this please?
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.
What happened to the initial hype of JDO? I thought some 6 months back JavaRanch Saloon would have seperate JDO section.
Still many of the products are in beta and no supports of even the available products!
Anybody has some inside info?
Matt Horton
Ranch Hand

Joined: Feb 06, 2002
Posts: 107
Thiru, I believe I received the same error a few weeks ago, while writing an empty string to a field. When I changed any empty strings to null values, jdo persisted the objects fine.
I hope this helps...
I agree. Here's the link:
subject: JDO
It's not a secret anymore!