FYI, I have just attached a patch to http://jira.codehaus.org/browse/CASTOR-1231 that seems to fix this problem. Could all interested parties please test the patched code against their respective test cases ?
Regards Werner On Sat, 08 Oct 2005 15:25:12 +0200, Ralf Joachim wrote: >Charles, > >may it be possible that you have been hit by the problem reported at >http://jira.codehaus.org/browse/CASTOR-1231 some days ago? > >Regards >Ralf > > >Charles Read schrieb: > >>I will list three things: src package, >>exception summary, full backtrace: >> >>1. The package is: http://freshmeat.net/projects/ajaqs >>The method invoked which leads to the exception is >>found in com/beardediris/ajaqs/oql/QueryDB.java in >>the method getRole(String roleName). >> >>2. The text of the exception, as emitted by log4j: >>INFO [com.beardediris.ajaqs.oql.QueryDB] - pe: >>org.exolab.castor.jdo.PersistenceException: Nested >>error: java.sql.SQLException: Syntax error or access >>violation message from server: "You have an error in >>your SQL syntax; check the manual that corresponds to >>your MySQL server version for the right syntax to use >>near 'WHERE (role.role_name = 'ajaqs-user')' at line >>1" while executing SELECT 1 FROM WHERE >>(role.role_name = ?1): Syntax error or access >>violation message from server: "You have an error in >>your SQL syntax; check the manual that corresponds to >>your MySQL server version for the right syntax to use >>near 'WHERE (role.role_name = 'ajaqs-user')' at line >>1" >> >>3. The full backtrace: >>javax.servlet.ServletException: Could not add roles to >>new FaqUser >> >>com.beardediris.ajaqs.util.Register.createFaqUser(Unknown >>Source) >>com.beardediris.ajaqs.util.Register.doPost(Unknown >>Source) >>javax.servlet.http.HttpServlet.service(HttpServlet.java:709) >>javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) >>com.cj.gzipflt.GzipFilter.doFilter(Unknown Source) >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) >>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) >>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407) >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) >>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) >>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) >>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731) >>org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) >>org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) >>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) >>java.lang.Thread.run(Thread.java:595) >> >>--- Ralf Joachim <[EMAIL PROTECTED]> wrote: >> >> >> >>>Hi Charles, >>> >>>from 0.9.7 to 0.9.9 nothing changed at the OQL >>>syntax but we had to >>>change the generation of the SQL statements >>>according to the >>>introduction of polymorphism. Especially the >>>generated SQL for classes >>>that take part in an extend declaration of the >>>mapping have changed >>>significantly. Even if this should be hidden from >>>castor users it will >>>hit you when you use CALL SQL ... AS ... statements. >>> >>>Having said that it may be possible that you >>>recognized a bug where we >>>generate wrong SQL in a usecase not covered by or >>>test framework at the >>>moment. I am quite interested to get more >>>information about that >>>problem, like full stacktrace, mapping, failing sql >>>statement. Much >>>better then only informations would be a testcase to >>>reproduce the >>>problem ourself ;-) >>> >>>Regards >>>Ralf >>> >>> >>>Charles Read schrieb: >>> >>> >>>>I substituted castor-0.9.9.jar for >>>> >>>> >>>castor-0.9.7.jar, >>> >>> >>>>rebuilt my webapp and then redeployed it. >>>> >>>>Mostly, everything worked ok. However, at some >>>>point I got a PersistenceException (that in turn >>>> >>>> >>>was >>> >>> >>>>triggered by an SQLException). The exception >>>> >>>> >>>message >>> >>> >>>>says that "You have an error in your SQL syntax; >>>> >>>> >>>..." >>> >>> >>>> >>>>I am using MySQL 4.1. The webapp works fine >>>>with castor-0.9.7.jar. >>>> >>>>Question: has OQL changed in castor-0.9.9.jar? >>>> >>>>NOTE: I looked at the docs for OQL on castor.org, >>>>but found no reference to OQL changes for 0.9.9. >>>> >>>>Thanks. >>>> >>>> >>>> >>>> >>------------------------------------------------------------------------ >> >> >>>>Yahoo! for Good >>>>Click here to donate >>>> >>>> >>><http://store.yahoo.com/redcross-donate3/> to the >>> >>> >>>>Hurricane Katrina relief effort. >>>> >>>> >>>-- >>> >>>Syscon Ingenieurbüro für >>>Meß- und Datentechnik GmbH >>>Ralf Joachim >>>Raiffeisenstraße 11 >>>D-72127 Kusterdingen >>>Germany >>> >>>Tel. +49 7071 3690 52 >>>Mobil: +49 173 9630135 >>>Fax +49 7071 3690 98 >>> >>>Email: [EMAIL PROTECTED] >>>Web: www.syscon-world.de >>> >>>------------------------------------------------- >>>If you wish to unsubscribe from this list, please >>>send an empty message to the following address: >>> >>>[EMAIL PROTECTED] >>>------------------------------------------------- >>> >>> >>> >>> >> >> >> >> >>__________________________________ >>Yahoo! Music Unlimited >>Access over 1 million songs. Try it free. >>http://music.yahoo.com/unlimited/ >> >>------------------------------------------------- >>If you wish to unsubscribe from this list, please >>send an empty message to the following address: >> >>[EMAIL PROTECTED] >>------------------------------------------------- >> >> >> > > >------------------------------------------------- >If you wish to unsubscribe from this list, please >send an empty message to the following address: > >[EMAIL PROTECTED] >------------------------------------------------- > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
