Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 3843 invoked by uid 500); 6 Mar 2003 10:59:02 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 3815 invoked from network); 6 Mar 2003 10:58:57 -0000 Received: from axe.csir.co.za (146.64.81.22) by daedalus.apache.org with SMTP; 6 Mar 2003 10:58:57 -0000 Received: from CS-IMO.CSIR.CO.ZA (cs-imo.csir.co.za [146.64.10.94]) by axe.csir.co.za (8.11.6/8.11.6) with ESMTP id h26Ax3a06531 for ; Thu, 6 Mar 2003 12:59:03 +0200 Received: from GW-IMO-MTA by CS-IMO.CSIR.CO.ZA with Novell_GroupWise; Thu, 06 Mar 2003 12:59:03 +0200 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.0.2 Date: Thu, 06 Mar 2003 12:58:45 +0200 From: "Derek Hohls" To: Subject: Re: Error using DatabaseUpdateAction Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=_FFA0ABE7.E988FD91" X-MailScanner: Found to be clean X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-0.8, required 9, EMAIL_ATTRIBUTION, GAPPY_TEXT, SPAM_PHRASE_00_01) X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N --=_FFA0ABE7.E988FD91 Content-Type: multipart/alternative; boundary="=_FFA0ABE7.EA8BFE92" --=_FFA0ABE7.EA8BFE92 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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 >>> haul@dvs1.informatik.tu-darmstadt.de 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 haul@informatik.tu-darmstadt.de fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org For additional commands, e-mail: cocoon-users-help@xml.apache.org -- 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." --=_FFA0ABE7.EA8BFE92 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit

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

>>> haul@dvs1.informatik.tu-darmstadt.de 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
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org

--
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." --=_FFA0ABE7.EA8BFE92-- --=_FFA0ABE7.E988FD91 Content-Type: text/plain Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="dba-error.txt" 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) --=_FFA0ABE7.E988FD91 Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org For additional commands, e-mail: cocoon-users-help@xml.apache.org --=_FFA0ABE7.E988FD91--