esql insert statement

[rgi <gi...@gmx.ch>]

Hello cocoon-users,

  I want to insert a new record in a oracle table. I use esql and
  connection pooling from cocoon2.
  I have cofigured all needed things in web.xml and cocoon.conf files.
  No error ocure when I start cocoon. But when I want to insert the
  data, nothing happen. Only some strings come back to the browser...!
  Can someone help?

  
My OK.xsp file:

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page
   language="java"
   xmlns:xsp="http://apache.org/xsp"
   xmlns:xsp-formval="http://apache.org/xsp/form-validator/2.0"
   xmlns:xsp-request="http://apache.org/xsp/request/2.0"
>

  <xsp:structure>
    <xsp:include>ch.netcetera.cocoon.DbUtil</xsp:include>
  </xsp:structure>

  <xsp:logic>
    String username = null;
    String lastname = null;
    String firstname = null;
    String address = null;
    String zip = null;
    String city = null;
    String email = null;
    String stamp = null; 
  </xsp:logic>

  <page>
    <xsp:logic>
      username  = <xsp-request:get-parameter name="username"/>;
      lastname  = <xsp-request:get-parameter name="lastname"/>;
      firstname = <xsp-request:get-parameter name="firstname"/>;
      address   = <xsp-request:get-parameter name="address"/>;
      zip       = <xsp-request:get-parameter name="zip"/>;
      city      = <xsp-request:get-parameter name="city"/>;
      email     = <xsp-request:get-parameter name="email"/>;
      stamp     = DbUtil.createStamp(username);
    </xsp:logic>
    <title><xsp:expr>stamp</xsp:expr> User added.</title>
    <content>
      <esql:connection>
        <esql:pool>myconn</esql:pool>
        <esql:execute-query>
          <esql:query>
            insert into users (id,name,firstname,address,zip,city,email,stamp) values (
              <esql:parameter><xsp:expr>username</xsp:expr></esql:parameter>,
              <esql:parameter><xsp:expr>lastname</xsp:expr></esql:parameter>,
              <esql:parameter><xsp:expr>firstname</xsp:expr></esql:parameter>,
              <esql:parameter><xsp:expr>address</xsp:expr></esql:parameter>,
              <esql:parameter><xsp:expr>zip</xsp:expr></esql:parameter>,
              <esql:parameter><xsp:expr>city</xsp:expr></esql:parameter>,
              <esql:parameter><xsp:expr>email</xsp:expr></esql:parameter>,                            
              <esql:parameter><xsp:expr>stamp</xsp:expr></esql:parameter>
            )
          </esql:query>
        </esql:execute-query>
      </esql:connection>
      <para>added</para>
      <a href="../welcome">Back to the welcome page</a>
    </content>
  </page>
</xsp:page>


My sitemap.xmap file:

...
   <map:match pattern="adduser">
     <map:act type="form-validator">
        <map:parameter name="descriptor" value="context:///docs/adduser/desc_adduser.xml"/>
        <map:parameter name="validate-set" value="adduser"/>
        <map:generate type="serverpages" src="docs/adduser/OK.xsp"/>
        <map:transform src="stylesheets//dynamic-page2html.xsl"/>
        <map:serialize/>
     </map:act>
     <map:generate type="serverpages" src="docs/adduser/adduser.xsp"/>
     <map:transform src="stylesheets/dynamic-page2html.xsl"/>
     <map:serialize/>
   </map:match>
..

My Output...new entry is in the DB:

test2-1008062291 User added.

myconn insert into users (id,name,firstname,address,zip,city,email,stamp) values ( test2, test, test,
test, test, test, test@test.com, test2-1008062291 ) 

added





-- 
Best regards,
 rgi                          mailto:giger@gmx.ch


---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>

Re: esql insert statement

[Hubert NEOtyk Iwaniuk <hu...@office.ferienwelt.com.pl>]

On Tue, Dec 11, 2001 at 10:18:40AM +0100, rgi wrote:
> Hello cocoon-users,
> 
>   I want to insert a new record in a oracle table. I use esql and
>   connection pooling from cocoon2.
>   I have cofigured all needed things in web.xml and cocoon.conf files.
>   No error ocure when I start cocoon. But when I want to insert the
>   data, nothing happen. Only some strings come back to the browser...!
>   Can someone help?
> 
>   
> My OK.xsp file:
> 
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <xsp:page
>    language="java"
>    xmlns:xsp="http://apache.org/xsp"
>    xmlns:xsp-formval="http://apache.org/xsp/form-validator/2.0"
>    xmlns:xsp-request="http://apache.org/xsp/request/2.0"
I think you are missing esql namespace, in order to use any esql:...
esql namespace have to be declared.

HTH,
	hubert

---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>