You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Semprini Davide <da...@tin.it> on 2000/12/18 15:18:04 UTC
esql problem
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
Re: esql problem
Posted by Matthew Cordes <mc...@maine.edu>.
I'm pretty sure the <esql:connection, dburl, etc needs to be within
the <esql:execute-query> tag.
Also, perhaps try the connection pool thingey. It is much nicer than
hard coding a password/user in each page. You can find more about
it in cocoon.properties
-matt
On Mon, Dec 18, 2000 at 03:18:04PM +0100, Semprini Davide wrote:
> 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
>
>
>