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