hi , i have downloaded the cocoon 2 zip file can somebody tell me how to cofiigure it. Unlike cocoon 1.8 it does not create all the directory from where it can cut and pasted in to tomcat 3.2.4 directory's.
I have gone through the installation help files but i am still unable too understand the entire procedure regards sumit ----- Original Message ----- From: Uwe Stelzer <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 26, 2001 10:12 PM Subject: Cocoon2 & mySQL database update query with success/failure differentiation > Hello everybody, > > I have the following problem and for me it is hard to tell where the reasons are: > > I am trying to send an insert query to mySQL from an XSP-Page processed by > Cocoon 2. > > If successful the resultpage shall yield some hopebringing comment, for > example which values have been inserted. > > If the update fails (because of a SQLException) I need to tell it to the user. > > Therefore I have tried to use the <esql:results> and <esql:no-results> tags > from the esql-taglib (this once worked fine with Cocoon 1 and Oracle 8). But > with mySQL and Cocoon 2 it just won't work. Either I get always only success > messages even if the query fails, or no text at all. > > Has anybody experiences with this or knows an answer that could help? > > Thanks, > Uwe Stelzer > > > Here is the source of my XSP page: > > -------------------------------------------------------------------------- ------------ > > <?xml version="1.0" encoding="UTF-8"?> > > <xsp:page > language="java" > xmlns:xsp="http://apache.org/xsp"; > xmlns:esql="http://apache.org/cocoon/SQL/v2"; > xmlns:request="http://www.apache.org/1999/XSP/Request"; > xmlns:util="http://www.apache.org/1999/XSP/Util"; > > > > <xsp:structure> > <xsp:include>java.lang.*</xsp:include> > </xsp:structure> > > <page> > > <xsp:logic> > String something = request.getParameterValues("something")[0]; > //... maybe some more variables > </xsp:logic> > > <esql:connection> > <esql:driver>org.gjt.mm.mysql.Driver</esql:driver> > <esql:dburl>jdbc:mysql://localhost:3306/myDatabase?user=myUser</esql:dburl> > > <esql:execute-query> > <esql:query> > insert into StudentTable (something) > VALUES ('<xsp:expr>something</xsp:expr>') > </esql:query> > > <esql:results> > <esql:update-results> > <success> > <something> > <xsp:expr>something</xsp:expr> > </something> > </success> > </esql:update-results> > </esql:results> > > <esql:no-results> > <fail> > <something> > Oooops, database update query failed! > </something> > </fail> > </esql:no-results> > > </esql:execute-query> > > </esql:connection> > > </page> > </xsp:page> > > -------------------------------------------------------------------------- ------------ > > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
