You might want to try reposting your issue with a different subject line...
I think many of the JDO folks will miss your question. --Keith Adam Saltiel wrote: > > To follow up on my last posting, I think the solution to this is that I must > build a test class with a main method which controls the query differently. > Doesn't the "?" in the SQL indicate an unbounded variable, which, > eventually, the database can't return a result to? > > ******************************************* > The document is now valid. > Next step. > Retry from shell. > > This seems to work. > I only get this error at the end of a long output, now:- > > [test] SQL for loading myapp.Category: SELECT category.name FROM category > WHERE > category.id=? > [test] Begin transaction > [test] SELECT prod.id,prod.name,prod.price,prod.group_id,prod_detail.id FROM > pro > d LEFT OUTER JOIN prod_detail ON prod.id=prod_detail.prod_id WHERE (prod.id > = ?) > > [test] org.exolab.castor.jdo.PersistenceException: Nested error: > org.gjt.mm.mysq > l.jdbc2.NotImplemented > [test] org.gjt.mm.mysql.jdbc2.NotImplemented > [test] at > org.gjt.mm.mysql.jdbc2.ResultSet.getBigDecimal(ResultSet.java:198) > [test] at > org.exolab.castor.jdo.engine.SQLTypes.getObject(SQLTypes.java:319) > [test] at > org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadSingleField(SQLEn > gine.java:1708) > [test] at > org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadRow(SQLEngine.jav > a:1774) > [test] at > org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.fetchRaw(SQLEngine.ja > va:1847) > [test] at > org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.nextIdentity(SQLEngin > e.java:1655) > [test] at > org.exolab.castor.persist.QueryResults.nextIdentity(QueryResults.java > :173) > [test] at > org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQ > ueryImpl.java:571) > [test] at > org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQ > ueryImpl.java:557) > [test] at jdo.Test.run(Test.java:100) > [test] at jdo.Test.main(Test.java:54) > E:\Castor\castor-0.9.3.9\examples> > > Back to searching for needles, searching my memory, searching ...? > > Adam Saltiel > > Phone: +44 (0207) 281 9375 > Mobile: +44 (07813) 709 755 > mailto:[EMAIL PROTECTED] > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
