Esql error?!
what is wrong with my page? It worked before, and since I change the
version of cocoon (from 2.0 to 2.1) it doesn't work anymore (the page
make a timeout) :
...
} else {
/xsp:logic
form action=add-param-configdb_add method=post
table
thselect/th
thcolumn name/th
xsp:logic
while(mytester != null) {
/xsp:logic
tr
esql:execute-query
esql:query
SELECT COL_NAME(OBJECT_ID('xsp:exprmyDB/xsp:expr'),
xsp:exprmycolid/xsp:expr) as ColName
/esql:query
esql:results
esql:row-results
xsp:logic
mytester = esql:get-string column=ColName/;
if (mytester != null) {
tdinput type=radio name=radiobutxsp:attribute
name=valueesql:get-string
column=ColName//xsp:attribute/input/td
tdesql:get-string column=ColName//td
}
/xsp:logic
/esql:row-results
/esql:results
/esql:execute-query
/tr
xsp:logic
mycolid = mycolid + 1;
}
/xsp:logic
/table
...
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[SUMMARY] RE: Esql error?!
I don't know why it worked like this before, but I remarked that the
error is :
while(mytester != null) { -wrong
while(!mytester.equals()) { -right
Because when SQL returns a NULL value in XSP this value is not NULL, but
!
-Original Message-
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
.org]
Sent: Wednesday, June 25, 2003 2:25 PM
To: [EMAIL PROTECTED]
Subject: Esql error?!
what is wrong with my page? It worked before, and since I change the
version of cocoon (from 2.0 to 2.1) it doesn't work anymore (the page
make a timeout) :
...
} else {
/xsp:logic
form action=add-param-configdb_add method=post
table
thselect/th
thcolumn name/th
xsp:logic
while(mytester != null) {
/xsp:logic
tr
esql:execute-query
esql:query
SELECT COL_NAME(OBJECT_ID('xsp:exprmyDB/xsp:expr'),
xsp:exprmycolid/xsp:expr) as ColName
/esql:query
esql:results
esql:row-results
xsp:logic
mytester = esql:get-string column=ColName/;
if (mytester != null) {
tdinput type=radio name=radiobutxsp:attribute
name=valueesql:get-string
column=ColName//xsp:attribute/input/td
tdesql:get-string column=ColName//td
}
/xsp:logic
/esql:row-results
/esql:results
/esql:execute-query
/tr
xsp:logic
mycolid = mycolid + 1;
}
/xsp:logic
/table
...
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [newbie] ESQL Error Handling
Thank you! map:handle-errors works fine! Just one more question: Is it possible to use map:select-tag in map:handle-errors to prepare the thrown exception for html or wml whichever device the query came from? regards, Zein - Original Message - From: Vadim Gritsenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 2:26 PM Subject: Re: [newbie] ESQL Error Handling Zein Dowe wrote: Hi, i got some questions about the esql logicsheet from cocoon. I suppose the first one is easy to answer: 1. How can i count the number of rows from the result of my query? Not sure does ESQL has something for this or not, but in any case you can count using XSLT. The second one seems quit more difficult to me (but i am a newbie and know nothing ;-): 2. How can I handle the exception which is thrown if the database connection fails? If i get it right, this kind of exception is handled by cocoon itself and not by the esql-logicsheet. So how can i prevent that the ugly cocoon exception window pops up and, instead of that, show a message which says that the connection process has failed? Any exception can be handled as you want using map:handle-errors/ pipeline in the sitemap. This pipeline has pre-set generator, so you can write an XSLT to format (and process) the error any way you want it. Vadim If somebody knows the answers or has some suggestions, i would be very grateful if you share them with me. regards, Zein - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [newbie] ESQL Error Handling
Zein wrote: Thank you! map:handle-errors works fine! Just one more question: Is it possible to use map:select-tag in map:handle-errors to prepare the thrown exception for html or wml whichever device the query came from? Yes. map:select, map:match, map:action - all are allowed. Vadim regards, Zein - Original Message - From: Vadim Gritsenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 2:26 PM Subject: Re: [newbie] ESQL Error Handling Zein Dowe wrote: Hi, i got some questions about the esql logicsheet from cocoon. I suppose the first one is easy to answer: 1. How can i count the number of rows from the result of my query? Not sure does ESQL has something for this or not, but in any case you can count using XSLT. The second one seems quit more difficult to me (but i am a newbie and know nothing ;-): 2. How can I handle the exception which is thrown if the database connection fails? If i get it right, this kind of exception is handled by cocoon itself and not by the esql-logicsheet. So how can i prevent that the ugly cocoon exception window pops up and, instead of that, show a message which says that the connection process has failed? Any exception can be handled as you want using map:handle-errors/ pipeline in the sitemap. This pipeline has pre-set generator, so you can write an XSLT to format (and process) the error any way you want it. Vadim If somebody knows the answers or has some suggestions, i would be very grateful if you share them with me. regards, Zein - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [newbie] ESQL Error Handling
Thank you for your help! Now everything does what it has to do. Zein - Original Message - From: Vadim Gritsenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 10:23 PM Subject: Re: [newbie] ESQL Error Handling Zein wrote: Thank you! map:handle-errors works fine! Just one more question: Is it possible to use map:select-tag in map:handle-errors to prepare the thrown exception for html or wml whichever device the query came from? Yes. map:select, map:match, map:action - all are allowed. Vadim regards, Zein - Original Message - From: Vadim Gritsenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 2:26 PM Subject: Re: [newbie] ESQL Error Handling Zein Dowe wrote: Hi, i got some questions about the esql logicsheet from cocoon. I suppose the first one is easy to answer: 1. How can i count the number of rows from the result of my query? Not sure does ESQL has something for this or not, but in any case you can count using XSLT. The second one seems quit more difficult to me (but i am a newbie and know nothing ;-): 2. How can I handle the exception which is thrown if the database connection fails? If i get it right, this kind of exception is handled by cocoon itself and not by the esql-logicsheet. So how can i prevent that the ugly cocoon exception window pops up and, instead of that, show a message which says that the connection process has failed? Any exception can be handled as you want using map:handle-errors/ pipeline in the sitemap. This pipeline has pre-set generator, so you can write an XSLT to format (and process) the error any way you want it. Vadim If somebody knows the answers or has some suggestions, i would be very grateful if you share them with me. regards, Zein - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[newbie] ESQL Error Handling
Hi, i got some questions about the esql logicsheet from cocoon. I suppose the first one is easy to answer: 1. How can i count the number of rows from the result of my query? The second one seems quit more difficult to me (but i am a newbie and know nothing ;-): 2. How can I handle the exception which is thrown if the database connection fails? If i get it right, this kind of exception is handled by cocoon itself and not by the esql-logicsheet. So how can i prevent that the ugly cocoon exception window pops up and, instead of that, show a message which says that the connection process has failed? If somebody knows the answers or has some suggestions, i would be very grateful if you share them with me. regards, Zein -- Werden Sie mit uns zum OnlineStar 2002! Jetzt GMX wählen - und tolle Preise absahnen! http://www.onlinestar.de - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [newbie] ESQL Error Handling
On 26.Sep.2002 -- 09:37 AM, Zein Dowe wrote: Hi, i got some questions about the esql logicsheet from cocoon. I suppose the first one is easy to answer: 1. How can i count the number of rows from the result of my query? There's a row-count tag but it works only with some cases. You saftest bet is to count the rows as you retrieve them. If you need paging or something, esql provides a limit clause. See docs and search this list. The second one seems quit more difficult to me (but i am a newbie and know nothing ;-): 2. How can I handle the exception which is thrown if the database connection fails? You can override the error handler in your sitemap. Other errors can be handled in the esql:error-results/ block. Connection errors not, I'm afraid. Chris. Please follow up summarizing your problem and which suggested solution / information worked for you when you consider your problem solved. Add SUMMARY: to the subject line. This will make FAQ generation and searching the list easier. In addition, it makes helping you more fun. Thank you. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [newbie] ESQL Error Handling
Zein Dowe wrote: Hi, i got some questions about the esql logicsheet from cocoon. I suppose the first one is easy to answer: 1. How can i count the number of rows from the result of my query? Not sure does ESQL has something for this or not, but in any case you can count using XSLT. The second one seems quit more difficult to me (but i am a newbie and know nothing ;-): 2. How can I handle the exception which is thrown if the database connection fails? If i get it right, this kind of exception is handled by cocoon itself and not by the esql-logicsheet. So how can i prevent that the ugly cocoon exception window pops up and, instead of that, show a message which says that the connection process has failed? Any exception can be handled as you want using map:handle-errors/ pipeline in the sitemap. This pipeline has pre-set generator, so you can write an XSLT to format (and process) the error any way you want it. Vadim If somebody knows the answers or has some suggestions, i would be very grateful if you share them with me. regards, Zein - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
jdk1.4 esql error (EsqlConnectionCocoon2 is an abstract class...)
Hey all, I seem to have everything working according to the jdk1.4 howto posted recently, except for the esql xsp examples. I am getting these errors: = Language Exception More precisely: org.apache.cocoon.ProcessingException: Language Exception: org.apache.cocoon.components.language.LanguageException: Error compiling esql_xsp: Line 0, column 0: could not parse error message: Note: sun.tools.javac.Main has been deprecated. /usr/local/jakarta-tomcat-4.0.3-LE-jdk14/work/localhost/_/cocoon-files/org/apache/cocoon/www/docs/samples/xsp/esql_xsp.java:264: class org.apache.cocoon.components.language.markup.xsp.EsqlConnectionCocoon2 is an abstract class. It can't be instantiated. _esql_connection = new EsqlConnectionCocoon2(); ^ Line 0, column 0: 1 error, 1 warning == Did I do something wrong here? Suggestions on howto get esql working? I am using TC4.0.3-LE and CC2.0.1 and jdk1.4 TIA, -Tom - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: jdk1.4 esql error (EsqlConnectionCocoon2 is an abstract class...)
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Hey all, I seem to have everything working according to the jdk1.4 howto posted recently, except for the esql xsp examples. I am getting these errors: = Language Exception More precisely: org.apache.cocoon.ProcessingException: Language Exception: org.apache.cocoon.components.language.LanguageException: Error compiling esql_xsp: Line 0, column 0: could not parse error message: Note: sun.tools.javac.Main has been deprecated. /usr/local/jakarta-tomcat-4.0.3-LE-jdk14/work/localhost/_/cocoon- files/org/apache/cocoon/www/docs/samples/xsp/esql_xsp.java:264: class org.apache.cocoon.components.language.markup.xsp.EsqlConnectionCocoon2 is an abstract class. It can't be instantiated. _esql_connection = new EsqlConnectionCocoon2(); ^ Line 0, column 0: 1 error, 1 warning == Did I do something wrong here? Suggestions on howto get esql working? I am using TC4.0.3-LE and CC2.0.1 and jdk1.4 What's yours JAVA_HOME env variable? Vadim TIA, -Tom - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: jdk1.4 esql error (EsqlConnectionCocoon2 is an abstract class...)
On Sun, Mar 10, 2002, Vadim Gritsenko wrote: Did I do something wrong here? Suggestions on howto get esql working? I am using TC4.0.3-LE and CC2.0.1 and jdk1.4 What's yours JAVA_HOME env variable? /usr/java/j2sdk1.4.0/ - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: jdk1.4 esql error (EsqlConnectionCocoon2 is an abstract class...)
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Sun, Mar 10, 2002, Vadim Gritsenko wrote: Did I do something wrong here? Suggestions on howto get esql working? I am using TC4.0.3-LE and CC2.0.1 and jdk1.4 What's yours JAVA_HOME env variable? /usr/java/j2sdk1.4.0/ Forgot to ask... Did you compile Cocoon with JDK1.4? You have to do this... Vadim - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: jdk1.4 esql error (EsqlConnectionCocoon2 is an abstract class...)
On Sun, Mar 10, 2002, Vadim Gritsenko wrote: I am using TC4.0.3-LE and CC2.0.1 and jdk1.4 What's yours JAVA_HOME env variable? /usr/java/j2sdk1.4.0/ Forgot to ask... Did you compile Cocoon with JDK1.4? You have to do this... Ahhh. No, I did not. /me runs off to build cocoon Thanks, -Tom - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
esql - Error loading driver
i have install resin+cocoon (win32) and try to user InterClient in esql, but fail: java.lang.RuntimeException: Error loading driver: org.interbase.interclient.Driver source: esql:driverorg.interbase.interclient.Driver/esql:driver esql:dburljdbc:interbase://localhost/c:/ilya/db/base.gdb/esql:dburl esql:usernamesysdba/esql:username esql:password123456/esql:password esql:execute-query ... what i make wrong? cocoon (1.8.2) resin (1.2.3) InterClient (2.01) Ilya - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
