Chris
Thanks for the reponse. In anwer to your questions;
1. I am not sure what SQL _is_ generated - I assume the
DatabaseUpdateAction is supposed to create this but I do
not where and how to find what it has done. (the error log
segment is attached)
2. Which other database actions are you referring to?
Derek
>>> [EMAIL PROTECTED] 06/03/2003 12:01:31 >>>
On 06.Mar.2003 -- 11:43 AM, Derek Hohls wrote:
> I need help resolving the following error, which I get
> when trying to use the DatabaseUpdateAction to update
> the database. Note that I have successfully used the
> DatabaseAddAction from the same form to post records,
> so I assume it cannot be my descriptor file that is in error.
>
> The message is:
>
> org.apache.cocoon.ProcessingException:
> Could not update record :position = 5:
> java.sql.SQLException: Syntax error or access violation:
> You have an error in your SQL syntax near '' at line 1
Without knowing the SQL that is created, it is difficult to guess the
error. Please enclose more of the log and the descriptor lines that
relate to this query.
You might want to try the other set of database actions - the
descriptor syntax is similar although not identical.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 06/03/2003 12:01:31 >>>
On 06.Mar.2003 -- 11:43 AM, Derek Hohls wrote:
> I need help resolving the following error, which I get
> when trying to use the DatabaseUpdateAction to update
> the database. Note that I have successfully used the
> DatabaseAddAction from the same form to post records,
> so I assume it cannot be my descriptor file that is in error.
>
> The message is:
>
> org.apache.cocoon.ProcessingException:
> Could not update record :position = 5:
> java.sql.SQLException: Syntax error or access violation:
> You have an error in your SQL syntax near '' at line 1
Without knowing the SQL that is created, it is difficult to guess the
error. Please enclose more of the log and the descriptor lines that
relate to this query.
You might want to try the other set of database actions - the
descriptor syntax is similar although not identical.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
"The CSIR exercises no editorial control over E-mail messages and/or
attachments thereto/links referred to therein originating in the
organisation and the views in this message/attachments thereto are
therefore not necessarily those of the CSIR and/or its employees.
The sender of this e-mail is, moreover, in terms of the CSIR's Conditions
of Service, subject to compliance with the CSIR's internal E-mail and
Internet Policy."
java.sql.SQLException: Syntax error or access violation: You have an error in your SQL
syntax near '' at line 1
at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown Source)
at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown Source)
at
org.apache.cocoon.acting.DatabaseUpdateAction.act(DatabaseUpdateAction.java:124)
at
org.apache.cocoon.www.biotox.sitemap_xmap.matchN10318(C:\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/biotox\sitemap_xmap.java:3223)
at
org.apache.cocoon.www.biotox.sitemap_xmap.process(C:\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/biotox\sitemap_xmap.java:1549)
at
org.apache.cocoon.www.biotox.sitemap_xmap.process(C:\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/biotox\sitemap_xmap.java:1413)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:224)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179)
at
org.apache.cocoon.www.sitemap_xmap.matchN103CB(C:\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www\sitemap_xmap.java:4713)
at
org.apache.cocoon.www.sitemap_xmap.process(C:\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www\sitemap_xmap.java:3435)
at
org.apache.cocoon.www.sitemap_xmap.process(C:\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www\sitemap_xmap.java:3214)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:224)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154)
at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:999)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:484)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
