You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Daniel Pfuhl <pf...@yahoo.de> on 2001/06/18 10:27:52 UTC
C2: ESQL and caching
Hi
I'm currently got an esql page running with Cocoon2.
But changes in this pages are only recognized after
restarting Tomcat. Is ist possible for developing
xsp-sites to turn off caching?
The Code in the xsp-file looks like this:
<esql:connection>
<esql:driver>com.informix.jdbc.IfxDriver</esql:driver>
<esql:dburl>jdbc:informix-sqli://paprika:1526/media360:INFORMIXSERVER=ol_paprika</esql:dburl>
<esql:username>user</esql:username>
<esql:password>password</esql:password>
<esql:execute-query>
<esql:query>select * from
mc_assetmaster</esql:query>
<esql:results>
<esql:row-results>
<metadata>
<id><esql:get-string
column="assetid"/></id>
<name><esql:get-string
column="name"/></name>
<create><esql:get-string
column="datecreated"/></create>
<upd><esql:get-string
column="lastupdated"/></upd>
<descr><esql:get-string
column="freetext"/></descr>
</metadata>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
If I add or remove something in this site the changes
want take effect until restarting tomcat.
It would be very kind of you pointing me in the right
direction....
daniel
=====
--------------------------------------------------------
Daniel Pfuhl
mailto:daniel@dphome.de
__________________________________________________________________
Do You Yahoo!?
Gesendet von Yahoo! Mail - http://mail.yahoo.de
---------------------------------------------------------------------
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: sql sample throws blank page...newbie
Posted by Aurelien DEHAY <au...@sncf.fr>.
java guru <ja...@yahoo.co.in> writes:
> The log file didnt show any error..or may be i am
> missing it...
>
> Anyway, I was using following code(note the
> esql:error-results) for catching database exceptions..
>
> <esql:execute-query>
> <esql:query>select * from
> department_table1</esql:query>
> <esql:results>
> <esql:row-results>
> <para><esql:get-string
> column="name"/></para>
> <esql:get-columns/>
> </esql:row-results>
> </esql:results>
> <esql:error-results>
> <para> this is error </para>
> </esql:error-results>
>
> </esql:execute-query>
>
I'm not sure that * is a good thing. Try putting a column name.
--
Aurélien
---------------------------------------------------------------------
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: sql sample throws blank page...newbie
Posted by java guru <ja...@yahoo.co.in>.
The log file didnt show any error..or may be i am
missing it...
Anyway, I was using following code(note the
esql:error-results) for catching database exceptions..
<esql:execute-query>
<esql:query>select * from
department_table1</esql:query>
<esql:results>
<esql:row-results>
<para><esql:get-string
column="name"/></para>
<esql:get-columns/>
</esql:row-results>
</esql:results>
<esql:error-results>
<para> this is error </para>
</esql:error-results>
</esql:execute-query>
*****************************************
--- Mariano Kamp <mk...@codamax.com> wrote: > Hi,
>
> have you checked the logfile (by default it is
> cocoon/WEB-INF/logs/cocoon.log)?
>
> I am also wondering how I can extract the
> exception from an esql query?!?!
>
> Mariano
>
> > I am trying to get the sample sql link from
> welcome
> > page work..the esql link works fine ... but the
> sql
> > link throws blank page ( i mean the static content
> is
> > coming up ) but not the database content..
>
>
---------------------------------------------------------------------
> 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>
>
____________________________________________________________
Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com
---------------------------------------------------------------------
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: sql sample throws blank page...newbie
Posted by Mariano Kamp <mk...@codamax.com>.
Hi,
have you checked the logfile (by default it is
cocoon/WEB-INF/logs/cocoon.log)?
I am also wondering how I can extract the exception from an esql query?!?!
Mariano
> I am trying to get the sample sql link from welcome
> page work..the esql link works fine ... but the sql
> link throws blank page ( i mean the static content is
> coming up ) but not the database content..
---------------------------------------------------------------------
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>
sql sample throws blank page...newbie
Posted by java guru <ja...@yahoo.co.in>.
HI.,
I am trying to get the sample sql link from welcome
page work..the esql link works fine ... but the sql
link throws blank page ( i mean the static content is
coming up ) but not the database content..
Any help appreciated....
thanks
____________________________________________________________
Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com
---------------------------------------------------------------------
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>
regarding jsp generation
Posted by java guru <ja...@yahoo.co.in>.
Hi.,
I am getting following error on trying the sample
jsp generator link on welcome page...
org.apache.jasper.servlet.JspServlet
Server: tomcat 4.0 with cocoon2
Any input appreciated..
Thanks
____________________________________________________________
Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com
---------------------------------------------------------------------
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>