Return-Path: <semprini_davide@hotmail.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 30408 invoked from network); 21 Dec 2000 15:54:19 -0000
Received: from f246.law11.hotmail.com (HELO hotmail.com) (64.4.17.246)
  by locus.apache.org with SMTP; 21 Dec 2000 15:54:19 -0000
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	 Thu, 21 Dec 2000 07:53:52 -0800
Received: from 130.186.6.108 by lw11fd.law11.hotmail.msn.com with HTTP;
	Thu, 21 Dec 2000 15:53:52 GMT
X-Originating-IP: [130.186.6.108]
From: "davide semprini" <semprini_davide@hotmail.com>
To: cocoon-users@xml.apache.org
Subject: HELP ESQL!!!! PLEASE
Date: Thu, 21 Dec 2000 16:53:52 +0100
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F246EjQxzmWecm9t0CI000051da@hotmail.com>
X-OriginalArrivalTime: 21 Dec 2000 15:53:52.0679 (UTC)
 FILETIME=[37684370:01C06B66]
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

Hi community please help me I'm so down!!!!,
I have a problem with esql connection tag (about 1 month),
when I try to call my xml files dadde.xml:




<esql:connection>
<esql:dburl>jdbc:oracle:thin:@10.0.0.1:1521:***</esql:dburl>
<esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
<esql:username>********</esql:username>
<esql:password>********</esql:password>

<esql:execute-query>
<esql:query>select nome,cognome from dati2</esql:query>

<esql:results>
<esql:row-results>
<nome><esql:get-string column="nome"/></nome>
</esql:row-results>

<esql:no-results>
<error>no results were found</error>
</esql:no-results>

</esql:results>

<esql:error-results>
<prova>errore conn db</prova>
<message><esql:get-message/></message>
<stacktrace><esql:get-stacktrace/></stacktrace>
</esql:error-results>

</esql:execute-query>


</esql:connection>

cocoon reply me:

jdbc:oracle:thin:@100.0.0.1:1521:*** oracle.jdbc.driver.OracleDriver
******* ******* errore conn dbjava.util.EmptyStackException at
java.lang.Throwable.fillInStackTrace(Native Method) at
java.lang.Throwable.fillInStackTrace(Compiled Code) at
java.lang.Throwable.<init>(Compiled Code) at java.lang.Exception.<init>
(Compiled Code) at java.lang.RuntimeException.<init>(Compiled Code) at
java.util.EmptyStackException.<init>(Compiled Code) at
java.util.Stack.peek(Compiled Code) at
_eidos._home._muvi002._httpd._cocoon_1_8._visit._dadde._esql_execute_que
ry_N13407ec(Compiled Code) at
_eidos._home._muvi002._httpd._cocoon_1_8._visit._dadde.populateDocument
(_dadde.java:351) at org.apache.cocoon.processor.xsp.XSPPage.getDocument
(XSPPage.java:96) at
org.apache.cocoon.processor.xsp.XSPProcessor.process(Compiled Code) at
org.apache.cocoon.Engine.handle(Compiled Code) at
org.apache.cocoon.Cocoon.service(Cocoon.java:167) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at
org.apache.jserv.JServConnection.processRequest
(JServConnection.java:317) at org.apache.jserv.JServConnection.run
(Compiled Code) at java.lang.Thread.run(Compiled Code)

I think that there is an error during connection dbase oracle!!!!
I have propertly installed my thin driver!!
It's strange, because with:
sql processor
taglib turbine
esql:execute-query taglib
I can access my dbase!!!
but not when I use the previous code, I need use
esql:connection because I have to do 1 and more query
in xml files!!!

I have to resetting some properties files?
I have cocoon 1.8, apache 1.3.2 oracle dbase!!

tanks a lot!!!

semprini davide



_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.