Return-Path: Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 32888 invoked from network); 16 Oct 2000 10:54:13 -0000 Received: from t5o69p100.telia.com (HELO firelord.billskill.com) (213.64.110.100) by locus.apache.org with SMTP; 16 Oct 2000 10:54:13 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by firelord.billskill.com (Postfix) with ESMTP id 492EA27EF for ; Mon, 16 Oct 2000 12:58:17 +0200 (CEST) Date: Mon, 16 Oct 2000 12:58:17 +0200 (CEST) From: magnus.egnerfors@home.se X-Sender: me@firelord.billskill.com To: "cocoon-users@xml.apache.org" Subject: Problem with esql-taglib In-Reply-To: <39EAC575.E9A13ADB@club-internet.fr> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N Hello, I have a problem that I have been working on for a few days now so any help solving this would be great. I'm running with cocoon-1.8.1-dev (updated this morning/ unfortunately there is a problem with turbine-pool.jar that I've posted to cocoon-dev list). The problem occurs when using the esql and session taglib together. Here is my XML document (the document is a test page normally there should be some xslt processing to add the html headers). The msisdn variable is set in the session on the previous page and is fetched correctly. -----XML document ----------

select * from msisdn2contract where msisdn=''

oracle.jdbc.driver.OracleDriver sysadm sysadm processor.xsp.pool.database.default.url=jdbc:oracle:thin:@localhost:1521:ERWIN select customerid from msisdn2contract where msisdn=''

no results were found here either

----------end xml doc ----------------------- This generates a page that looks like this: ----------- output --------------

628882101

select * from msisdn2contract where msisdn='628882101'

no results were found here either -----------end output -------------- When checking the java source for this page it looks alright the interesting section here: ------------- java code --------------- _esql_session.query = String.valueOf("" + "select customerid from msisdn2contract where msisdn='" + session.getAttribute( String.valueOf("msisdn") ) + "'"); _esql_session.statement = _esql_session.connection.createStatement(); _esql_session.resultset = _esql_session.statement.executeQuery(_esql_session.query); --------------------------------------- Replacing the last get-attribute with a fixed value works perfectly fine and the query returns the correct information. Does the esql-block create its own session somehow and we lose the session information??? TIA Magnus Egnerfors -- Magnus Egnerfors Email: magnus.egnerfors@home.se