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] -------------------------------------------------
