Re: esql !!!HELP!!!
you could try annother msssql jdbc driver. I'm using http://jtds.sourceforge.net also with stored procedures and it works. The driver from microsoft is known to have some bugs. hth, Frank - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: esql !!!HELP!!!
On 24.Jun.2003 -- 12:35 PM, Tim Bachta wrote: Does cocoon compile an xsp into a Java class file? If so where does it put it. The reason why I am asking is that my procedures that I am having trouble with in cocoon work fine in a java class file. Please post relevant parts of that file. It will help to solve your issues tremendously. Chris. -- 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: ESQL help
Hello Tim, first hint: http://wiki.cocoondev.org/Search.jsp?query=esql I think what you are looking for: http://wiki.cocoondev.org/Wiki.jsp?page=DatabaseConnectionOverview Hope that helps /Thorsten -Original Message- From: Tim Bachta [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 6:08 PM To: [EMAIL PROTECTED] Subject: ESQL help Does anyone know of a good place to get help with esql issues? I am having a very difficult time finding any information regarding how to correctly call a MS SQL stored procedure. I have looked at the official cocoon documentation and have the Cocoon developers handbook, neither have much useful information. I am in desperate need of help. Thank you Tim Bachta - 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]
esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
room_report_xsp:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Line 0, column 0:
4 errors
Please any help is greatly appreciated.
Tim Bachta
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: esql !!!HELP!!!
I wish I could make the stored procedure easier, but unfortunately this
is the procedure that I have been given.
Tim Bachta
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:07 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Hello Tim,
your code is quite complex.
I had heaps of problem with similar code.
Can you break it down to 1 or 2 parameter?
Your error:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Seeing the last error I reckon that MS SQL have a different type of data
then you expect.
-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 6:54 PM
To: [EMAIL PROTECTED]
Subject: esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
room_report_xsp:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Line 0, column 0:
4 errors
Please any help is greatly appreciated.
Tim Bachta
-
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]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: esql !!!HELP!!!
Does cocoon compile an xsp into a Java class file? If so where does it
put it. The reason why I am asking is that my procedures that I am
having trouble with in cocoon work fine in a java class file.
Tim Bachta
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:21 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
I wish I could make the stored procedure easier, but unfortunately this
is the procedure that I have been given.
Tim Bachta
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:07 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Hello Tim,
your code is quite complex.
I had heaps of problem with similar code.
Can you break it down to 1 or 2 parameter?
Your error:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Seeing the last error I reckon that MS SQL have a different type of data
then you expect.
-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 6:54 PM
To: [EMAIL PROTECTED]
Subject: esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
room_report_xsp:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Line 0, column 0:
4 errors
Please any help is greatly appreciated.
Tim Bachta
-
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]
-
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: esql !!!HELP!!!
Yes. The .java file is in your servlet container's work directory under
cocoon-files. There will be an org/apache/cocoon... structure the path and
name will mimic your xsp file's name and location after a certain point.
If you're using tomcat, the work dir is under %tomcat_home%\work
in jetty, it's in your window's temp dir (documents and settings\your.user\...
some where. the dir is called something like Jetty_)
HTH,
Geoff Howard
At 01:35 PM 6/24/2003, you wrote:
Does cocoon compile an xsp into a Java class file? If so where does it
put it. The reason why I am asking is that my procedures that I am
having trouble with in cocoon work fine in a java class file.
Tim Bachta
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:21 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
I wish I could make the stored procedure easier, but unfortunately this
is the procedure that I have been given.
Tim Bachta
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:07 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Hello Tim,
your code is quite complex.
I had heaps of problem with similar code.
Can you break it down to 1 or 2 parameter?
Your error:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Seeing the last error I reckon that MS SQL have a different type of data
then you expect.
-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 6:54 PM
To: [EMAIL PROTECTED]
Subject: esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
room_report_xsp:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Line 0, column 0:
4 errors
Please any help is greatly appreciated.
Tim Bachta
-
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]
-
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]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: esql !!!HELP!!!
Geoff,
Thanks for the help that was really helpful. Now I was able to get a
step further in my quest. I am running the following code:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and I am now getting this error message:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
executing statement: {? = rptLocationDeviations(?,?,?,?)} :
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Syntax
error at token t, line 0 offset 7.
Does anyone have any ideas? Maybee where I can find
ServerPagesGenerator or even what I am doing wrong here. Thanks
Tim Bachta
-Original Message-
From: Geoff Howard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:38 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Yes. The .java file is in your servlet container's work directory under
cocoon-files. There will be an org/apache/cocoon... structure the path
and
name will mimic your xsp file's name and location after a certain point.
If you're using tomcat, the work dir is under %tomcat_home%\work
in jetty, it's in your window's temp dir (documents and
settings\your.user\...
some where. the dir is called something like Jetty_)
HTH,
Geoff Howard
At 01:35 PM 6/24/2003, you wrote:
Does cocoon compile an xsp into a Java class file? If so where does it
put it. The reason why I am asking is that my procedures that I am
having trouble with in cocoon work fine in a java class file.
Tim Bachta
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:21 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
I wish I could make the stored procedure easier, but unfortunately this
is the procedure that I have been given.
Tim Bachta
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:07 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Hello Tim,
your code is quite complex.
I had heaps of problem with similar code.
Can you break it down to 1 or 2 parameter?
Your error:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Seeing the last error I reckon that MS SQL have a different type of
data
then you expect.
-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 6:54 PM
To: [EMAIL PROTECTED]
Subject: esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
p
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+S
u
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:paramete
r
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:par
a
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely
Re: esql !!!HELP!!!
Hi,
Every one that your driver supports. The error message your getting appears
to be from the SQLServer 2000 Driver for JDBC showing java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Syntax
error at token t, line 0 offset 7.
talking about a syntax error it exceptions on. Do simple queries work in
you Cocoon based project? Are stored procedures supported by the SQLServer
2000 Driver for JDBC? Can you test this driver directly?
If you need to explore Cocoon more, look in
cocoon-2.1\src\blocks\databases\java\org\apache\cocoon\components\language\m
arkup\xsp\java\esql.xsl at particularly
xspdoc:desc internal. set one parameter of a callable statement
/xspdoc:desc
xsl:template name=set-call-parameter
xsl:if test=@direction='out' or @direction='inout'
xsl:text_esql_query.getCallableStatement()./xsl:text
registerOutParameter(xsl:value-of select=position()/, xsl:call-template
name=get-Sql-Typexsl:with-param name=typexsl:value-of
select=@type//xsl:with-param/xsl:call-templatexsl:if
test=@typename, xsl:value-of select=@typename/ /xsl:if);
/xsl:if
xsl:if test=not(@direction) or @direction='inout' or @direction='in'
xsl:text_esql_query.getCallableStatement()./xsl:text
xsl:call-template name=set-query-parameter/
/xsl:if
/xsl:template
and what it calls and does. If you look at your generated *_xsp.java files
under tomacat (C:\Program
Files\jakarta-tomcat-5\dist\work\Catalina\localhost\wita\cocoon-files\
working mount) or other work directory of another server you will see that
they extend org.apache.cocoon.components.language.markup.xspXSPGenerator
but it looks like most of your parameters are direction='in' so you can look
more at the esql.xsl set-query-parameter template. Note you can put
System.out.println() inside this esql.xsl prove to yourself that the
stylesheet is working. You can write a lot of Java code in here to explore
the driver classes and the queries they manage. The output from
System.out.println()'s will show up in the launch window of your server.
-Roger
- Original Message -
From: Tim Bachta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 2:41 PM
Subject: RE: esql !!!HELP!!!
Does anyone know what the different types of parameters there are for
esql:parameter. I know String and Int.
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:56 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Geoff,
Thanks for the help that was really helpful. Now I was able to get a
step further in my quest. I am running the following code:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and I am now getting this error message:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
executing statement: {? = rptLocationDeviations(?,?,?,?)} :
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Syntax
error at token t, line 0 offset 7.
Does anyone have any ideas? Maybee where I can find
ServerPagesGenerator or even what I am doing wrong here. Thanks
Tim Bachta
-Original Message-
From: Geoff Howard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:38 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Yes. The .java file is in your servlet container's work directory under
cocoon-files. There will be an org/apache/cocoon... structure the path
and
name will mimic your xsp file's name and location after a certain point.
If you're using tomcat, the work dir is under %tomcat_home%\work
in jetty, it's in your window's temp dir (documents and
settings\your.user\...
some where. the dir is called something like Jetty_)
HTH,
Geoff Howard
At 01:35 PM 6/24/2003, you wrote:
Does cocoon compile an xsp into a Java class file? If so where does it
put it. The reason why I am asking is that my procedures that I am
having trouble with in cocoon work fine in a java class file.
Tim Bachta
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:21 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
I wish I could make the stored procedure easier, but unfortunately this
is the procedure that I have been given.
Tim Bachta
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:07 PM
To: [EMAIL
RE: esql !!!HELP!!!
Thanks, I have gotten past that problem, and on to the next. I was able
to view the actual java code that cocoon compiled my page into and
figured out a few errors on my end now I am stuck again. I am getting
an error of Invalid parameter binding(s). My code now looks like this:
esql:execute-query
esql:call{call rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
I have no Idea what invalid parameter binding(s) means. Any help is
greatly appreciated.
Tim Bachta
-Original Message-
From: Roger I Martin PhD [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 3:37 PM
To: [EMAIL PROTECTED]
Subject: Re: esql !!!HELP!!!
Hi,
Every one that your driver supports. The error message your getting
appears
to be from the SQLServer 2000 Driver for JDBC showing
java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Syntax
error at token t, line 0 offset 7.
talking about a syntax error it exceptions on. Do simple queries work
in
you Cocoon based project? Are stored procedures supported by the
SQLServer
2000 Driver for JDBC? Can you test this driver directly?
If you need to explore Cocoon more, look in
cocoon-2.1\src\blocks\databases\java\org\apache\cocoon\components\langua
ge\m
arkup\xsp\java\esql.xsl at particularly
xspdoc:desc internal. set one parameter of a callable statement
/xspdoc:desc
xsl:template name=set-call-parameter
xsl:if test=@direction='out' or @direction='inout'
xsl:text_esql_query.getCallableStatement()./xsl:text
registerOutParameter(xsl:value-of select=position()/,
xsl:call-template
name=get-Sql-Typexsl:with-param name=typexsl:value-of
select=@type//xsl:with-param/xsl:call-templatexsl:if
test=@typename, xsl:value-of select=@typename/ /xsl:if);
/xsl:if
xsl:if test=not(@direction) or @direction='inout' or @direction='in'
xsl:text_esql_query.getCallableStatement()./xsl:text
xsl:call-template name=set-query-parameter/
/xsl:if
/xsl:template
and what it calls and does. If you look at your generated *_xsp.java
files
under tomacat (C:\Program
Files\jakarta-tomcat-5\dist\work\Catalina\localhost\wita\cocoon-files\
working mount) or other work directory of another server you will see
that
they extend
org.apache.cocoon.components.language.markup.xspXSPGenerator
but it looks like most of your parameters are direction='in' so you can
look
more at the esql.xsl set-query-parameter template. Note you can put
System.out.println() inside this esql.xsl prove to yourself that the
stylesheet is working. You can write a lot of Java code in here to
explore
the driver classes and the queries they manage. The output from
System.out.println()'s will show up in the launch window of your server.
-Roger
- Original Message -
From: Tim Bachta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 2:41 PM
Subject: RE: esql !!!HELP!!!
Does anyone know what the different types of parameters there are for
esql:parameter. I know String and Int.
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:56 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Geoff,
Thanks for the help that was really helpful. Now I was able to get a
step further in my quest. I am running the following code:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and I am now getting this error message:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
executing statement: {? = rptLocationDeviations(?,?,?,?)} :
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Syntax
error at token t, line 0 offset 7.
Does anyone have any ideas? Maybee where I can find
ServerPagesGenerator or even what I am doing wrong here. Thanks
Tim Bachta
-Original Message-
From
Re: Cocoon/XSP/ESQL help
On Fri, Jan 10, 2003 at 07:52:33PM +, Brian Campbell wrote:
Hope this is the appropriate list for this question.
I have a simple XSP page. I want to use ESQL to call stored procedures in
a Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and I'm able to
execute a stored procedure that doesn't take any parameters. But most of
my stored prcedures take parameters. Can't seem to find any good examples
anywhere. My code is below. Anyone able to tell me what I'm doing wrong?
Thanks.
xsp:page language=java
xmlns:xsp=http://apache.org/xsp;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:log=http://apache.org/xsp/log/2.0;
root
esql:connection
esql:poolmpts-pool/esql:pool
esql:execute-query
esql:call
{ call sp_DayShift_Report_ListByName
((esql:parameter direction=in
type=Stringxsp-request:get-parameter name=sQuerry//esql:parameter)
}
/esql:call
esql:results
esql:row-results
data
esql:get-columns/
/data
/esql:row-results
/esql:results
/esql:execute-query
/esql:connection
/root
/xsp:page
I remember I had two problems with stored procedures in MS SQL:
1. if you use for example integer parameters you have to have an separated int variable
declared for parameter use
2. my stored procedure did not work without allow-multiple-results clause set
to yes - for example errors were not reported
ouzo
--
__
| / \ |Leszek Gawron// \\
\_\\ //_/ [EMAIL PROTECTED] _\\()//_
.'/()\'. Phone: +48(600)341118 / // \\ \
\\ // recursive: adj; see recursive | \__/ |
-
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]
Cocoon/XSP/ESQL help
Hope this is the appropriate list for this question.
I have a simple XSP page. I want to use ESQL to call stored procedures in a
Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and I'm able to
execute a stored procedure that doesn't take any parameters. But most of my
stored prcedures take parameters. Can't seem to find any good examples
anywhere. My code is below. Anyone able to tell me what I'm doing wrong?
Thanks.
xsp:page language=java
xmlns:xsp=http://apache.org/xsp;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:log=http://apache.org/xsp/log/2.0;
root
esql:connection
esql:poolmpts-pool/esql:pool
esql:execute-query
esql:call
{ call sp_DayShift_Report_ListByName ((esql:parameter direction=in
type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }
/esql:call
esql:results
esql:row-results
data
esql:get-columns/
/data
/esql:row-results
/esql:results
/esql:execute-query
/esql:connection
/root
/xsp:page
-Brian
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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: Cocoon/XSP/ESQL help
Here's some places you can go for examples:
ESQL Page in Docs
http://xml.apache.org/cocoon/userdocs/xsp/esql.html
Mailing List ARChives:
http://marc.theaimsgroup.com/?l=xml-cocoon-users
(just do a search on stored procedure)
J
-Original Message-
From: Brian Campbell [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 12:53 PM
To: [EMAIL PROTECTED]
Subject: Cocoon/XSP/ESQL help
Hope this is the appropriate list for this question.
I have a simple XSP page. I want to use ESQL to call stored procedures in a
Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and I'm able to
execute a stored procedure that doesn't take any parameters. But most of my
stored prcedures take parameters. Can't seem to find any good examples
anywhere. My code is below. Anyone able to tell me what I'm doing wrong?
Thanks.
xsp:page language=java
xmlns:xsp=http://apache.org/xsp;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:log=http://apache.org/xsp/log/2.0;
root
esql:connection
esql:poolmpts-pool/esql:pool
esql:execute-query
esql:call
{ call sp_DayShift_Report_ListByName
((esql:parameter direction=in
type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }
/esql:call
esql:results
esql:row-results
data
esql:get-columns/
/data
/esql:row-results
/esql:results
/esql:execute-query
/esql:connection
/root
/xsp:page
-Brian
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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: Cocoon/XSP/ESQL help
Thanks for the info. Unfortunately, I've already been to both places and
have been unable to determine whats wrong. My code appears (at least to me)
to be correct according to the taglib doc and info out at the archives. Its
probably something small snd stupid that I'm doing.
-Brian
Here's some places you can go for examples:
ESQL Page in Docs
http://xml.apache.org/cocoon/userdocs/xsp/esql.html
Mailing List ARChives:
http://marc.theaimsgroup.com/?l=xml-cocoon-users
(just do a search on stored procedure)
J
-Original Message-
From: Brian Campbell [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 12:53 PM
To: [EMAIL PROTECTED]
Subject: Cocoon/XSP/ESQL help
Hope this is the appropriate list for this question.
I have a simple XSP page. I want to use ESQL to call stored procedures in
a
Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and I'm able to
execute a stored procedure that doesn't take any parameters. But most of
my
stored prcedures take parameters. Can't seem to find any good examples
anywhere. My code is below. Anyone able to tell me what I'm doing wrong?
Thanks.
xsp:page language=java
xmlns:xsp=http://apache.org/xsp;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:log=http://apache.org/xsp/log/2.0;
root
esql:connection
esql:poolmpts-pool/esql:pool
esql:execute-query
esql:call
{ call sp_DayShift_Report_ListByName
((esql:parameter direction=in
type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }
/esql:call
esql:results
esql:row-results
data
esql:get-columns/
/data
/esql:row-results
/esql:results
/esql:execute-query
/esql:connection
/root
/xsp:page
-Brian
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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]
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-
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: Cocoon/XSP/ESQL help
I have a simple XSP page. I want to use ESQL to call stored procedures in
a Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and I'm able to
execute a stored procedure that doesn't take any parameters. But most of
my stored prcedures take parameters. Can't seem to find any good examples
anywhere. My code is below. Anyone able to tell me what I'm doing wrong?
Thanks.
esql:call{ call sp_DayShift_Report_ListByName((esql:parameter
direction=in type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }/esql:call
On second glance, it looks like you may have an extra open parenthesis.
J
-
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: Cocoon/XSP/ESQL help
Yeah, I caught that and fixed it already. It was a problem, but not the end
of my problems.
-Brian
From: Jacob Arnold [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: Cocoon/XSP/ESQL help
Date: Fri, 10 Jan 2003 14:39:49 -0700
I have a simple XSP page. I want to use ESQL to call stored procedures
in
a Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and I'm able to
execute a stored procedure that doesn't take any parameters. But most of
my stored prcedures take parameters. Can't seem to find any good
examples
anywhere. My code is below. Anyone able to tell me what I'm doing
wrong?
Thanks.
esql:call{ call sp_DayShift_Report_ListByName((esql:parameter
direction=in type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }/esql:call
On second glance, it looks like you may have an extra open parenthesis.
J
-
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]
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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: Cocoon/XSP/ESQL help
I put in code to dump the message and here is what I get:
[Microsoft][SQLServer 2000 Driver for JDBC]Syntax error at token {Call, line
0 offset 0.
It appears to be a syntax error with the SP call. Since I can run other
stored procedures that take no parameters, with no problems at all, I assume
its gotta be the parameter.But I just can't see what it is:
esql:call
{Call sp_DayShift_Report_ListByName (esql:parameter direction=in
type=String'----'/esql:parameter)}
/esql:call
-Brian
Yeah, I caught that and fixed it already. It was a problem, but not the
end of my problems.
-Brian
From: Jacob Arnold [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: Cocoon/XSP/ESQL help
Date: Fri, 10 Jan 2003 14:39:49 -0700
I have a simple XSP page. I want to use ESQL to call stored procedures
in
a Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and I'm able to
execute a stored procedure that doesn't take any parameters. But most
of
my stored prcedures take parameters. Can't seem to find any good
examples
anywhere. My code is below. Anyone able to tell me what I'm doing
wrong?
Thanks.
esql:call{ call sp_DayShift_Report_ListByName((esql:parameter
direction=in type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }/esql:call
On second glance, it looks like you may have an extra open parenthesis.
J
-
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]
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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]
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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: Cocoon/XSP/ESQL help
I put in code to dump the message and here is what I get:
[Microsoft][SQLServer 2000 Driver for JDBC]Syntax error at token
{Call, line
0 offset 0.
It appears to be a syntax error with the SP call. Since I can run other
stored procedures that take no parameters, with no problems at
all, I assume
its gotta be the parameter.But I just can't see what it is:
esql:call
{Call
sp_DayShift_Report_ListByName (esql:parameter direction=in
type=String'----'/esql:parameter)}
/esql:call
Have you looked at the generated java file under the work directory? That
usually clears up mysterious xsp problems for me.
Do you need the single quotes around the parameter value (thought esql would
put them in for you)
Geoff Howard
-Brian
Yeah, I caught that and fixed it already. It was a problem, but not the
end of my problems.
-Brian
From: Jacob Arnold [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: Cocoon/XSP/ESQL help
Date: Fri, 10 Jan 2003 14:39:49 -0700
I have a simple XSP page. I want to use ESQL to call stored
procedures
in
a Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and
I'm able to
execute a stored procedure that doesn't take any parameters.
But most
of
my stored prcedures take parameters. Can't seem to find any good
examples
anywhere. My code is below. Anyone able to tell me what I'm doing
wrong?
Thanks.
esql:call{ call sp_DayShift_Report_ListByName((esql:parameter
direction=in type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }/esql:call
On second glance, it looks like you may have an extra open parenthesis.
J
-
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]
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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]
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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: Cocoon/XSP/ESQL help
I have looked at the code. Don't see anything wrong off hand but I think
I'll yank it out of there and put it in a small test class. Maybe that will
tell me some more.
The quotes are extra and not needed. I've just been trying every variation
that I can think of.
-Brian
Have you looked at the generated java file under the work directory? That
usually clears up mysterious xsp problems for me.
Do you need the single quotes around the parameter value (thought esql
would
put them in for you)
Geoff Howard
-Brian
Yeah, I caught that and fixed it already. It was a problem, but not
the
end of my problems.
-Brian
From: Jacob Arnold [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: Cocoon/XSP/ESQL help
Date: Fri, 10 Jan 2003 14:39:49 -0700
I have a simple XSP page. I want to use ESQL to call stored
procedures
in
a Microsoft SQL Server database. I've got my connection pool set up
correctly. I'm able to execute simple select statements and
I'm able to
execute a stored procedure that doesn't take any parameters.
But most
of
my stored prcedures take parameters. Can't seem to find any good
examples
anywhere. My code is below. Anyone able to tell me what I'm doing
wrong?
Thanks.
esql:call{ call sp_DayShift_Report_ListByName((esql:parameter
direction=in type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }/esql:call
On second glance, it looks like you may have an extra open
parenthesis.
J
-
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]
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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]
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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]
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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: Cocoon/XSP/ESQL help - Finally
Finally got it figured out. Need to let out a big fat D'OH!. I did not
have my connection pool set up to point to the specific database where my
SP's reside. Not sure why if found some of them but not others. Must have
accidently added them to master or another DB.
But I'm wondering if this might have found minor a problem with Cocoon. The
error I was getting back (several emails below) was something about a weird
syntax error. I went into the generated class in the work directory, cut
the code and pasted it into a test class. Instead of using the EsqlQuery
class, I just used CallableStatement, etc. I immediately got a much more
accurate statement from the JDBC driver. It wouldn't surprise me if its a
problem/bug in the Microsoft driver but since I got different results by
using the basic java.sql.* classes, I'm wondering if its something else
Cocoon is doing.
Thanks to all, especially Geoff, who helped.
-Brian
I have looked at the code. Don't see anything wrong off hand but I think
I'll yank it out of there and put it in a small test class. Maybe that
will tell me some more.
The quotes are extra and not needed. I've just been trying every variation
that I can think of.
-Brian
Have you looked at the generated java file under the work directory? That
usually clears up mysterious xsp problems for me.
Do you need the single quotes around the parameter value (thought esql
would
put them in for you)
Geoff Howard
-Brian
Yeah, I caught that and fixed it already. It was a problem, but not
the
end of my problems.
-Brian
From: Jacob Arnold [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: Cocoon/XSP/ESQL help
Date: Fri, 10 Jan 2003 14:39:49 -0700
I have a simple XSP page. I want to use ESQL to call stored
procedures
in
a Microsoft SQL Server database. I've got my connection pool set
up
correctly. I'm able to execute simple select statements and
I'm able to
execute a stored procedure that doesn't take any parameters.
But most
of
my stored prcedures take parameters. Can't seem to find any good
examples
anywhere. My code is below. Anyone able to tell me what I'm doing
wrong?
Thanks.
esql:call{ call sp_DayShift_Report_ListByName((esql:parameter
direction=in type=Stringxsp-request:get-parameter
name=sQuerry//esql:parameter) }/esql:call
On second glance, it looks like you may have an extra open
parenthesis.
J
-
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]
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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]
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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]
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
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]
_
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
-
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
Re: SQL, Actions, ESQL Help Please!!!
On 03.Jun.2002 -- 11:53 PM, John Austin wrote:
On Monday 03 June 2002 01:50 pm, you wrote:
On 03.Jun.2002 -- 10:11 AM, daniel robinson wrote:
Hi,
I've been poking around but I'm clueless (yes, generally as well as
specifically).
I have some code that simply uses embedded Java in an XSP and a Java
temp file. This code processes a File that is submitted by the user's
Applet simulating a FORM with method=PUT. The user's FILE parameter is
an XML document produced by the applet. I have to insert the DTD stuff
because the Serializer I am generating this file from doesn't generate
the DTD statements.
After the file is pulled into a string and written to a File, I add it
to my PostgreSQL database as a BLOB.
?xml version=1.0 encoding=ISO-8859-1?
xsp:page
language=java
create-session=yes
xmlns:xsp=http://apache.org/xsp;
xmlns:session=http://apache.org/xsp/session/2.0;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:xsp-response=http://apache.org/xsp/response/2.0;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:log=http://apache.org/xsp/log/2.0;
xsp:structure
xsp:includejava.io.*/xsp:include
xsp:includejava.sql.*/xsp:include
/xsp:structure
page
content
xsp:logic
File output = null;
try {
String username = (String)
session:get-attribute name=username default=nobody /;
//System.err.println( username= + username );
String filename =
xsp-request:get-parameter name=FILENAME /;
//System.err.println( filename= + filename );
String config_data =
xsp-request:get-parameter name=FILE /;
//System.err.println( config_data= + config_data );
int position = config_data.indexOf( ![CDATA[product]] );
StringBuffer saveString = new StringBuffer( config_data.substring( 0,
position ) );
![CDATA[
saveString.append( !DOCTYPE product [\n +
!ELEMENT product (page+)\n +
!ELEMENT children (page+)\n +
!ELEMENT Company EMPTY\n +
!ELEMENT page (#PCDATA | Company | children)*\n +
!ATTLIST page level (1 | 2 | 3 | 4 | 5 | 8 ) #REQUIRED\n +
target CDATA #REQUIRED\n +
checkbox (true | false) #REQUIRED\n +
\n +
]\n );
]]
saveString.append( config_data.substring( position) );
output = File.createTempFile( phoenix_, .xml );
FileWriter fw = new FileWriter( output );
fw.write( saveString.toString() );
fw.close();
esql:connection
esql:driverorg.postgresql.Driver/esql:driver
esql:dburljdbc:postgresql://192.168.1.100:5432/test/esql:dburl
esql:usernamepostgres/esql:username
esql:password/esql:password
esql:execute-query
esql:queryUPDATE user_products SET
product_file=lo_import('xsp:exproutput.getAbsolutePath()/xsp:expr')
where name =
esql:parameterxsp:exprusername/xsp:expr
AND productname =
esql:parameterxsp:exprfilename/xsp:expr/esql:parameter;/esql:query
esql:update-results
xsp:logic
int rows = esql:get-update-count/
/xsp:logic
/esql:update-results
esql:error-results
xsp:logic
System.err.println( Caught: + esql:get-message/
);
xsp:logic
esql:get-stacktrace/
/esql:error-results
/esql:execute-query
/esql:connection
/xsp:logic
session:set-attribute name=TEMPFILENAME
xsp:logicxsp:exproutput.getAbsolutePath()/xsp:expr/xsp:logic
/session:set-attribute
para
TEMPFILENAME=session:get-attribute name=TEMPFILENAME /
/para
/content
/page
/xsp:page
The above *might* work. If it doesn't, try to remove the
esql:parameter tags (and leave only the xsp:expr tags).
Chris.
--
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/faqs.html
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQL, Actions, ESQL Help Please!!!
where do I set my map:sitemap and pipelines to be able to use my xml
documents
/Conny
- Original Message -
From: Christian Haul [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 9:47 AM
Subject: Re: SQL, Actions, ESQL Help Please!!!
On 03.Jun.2002 -- 11:53 PM, John Austin wrote:
On Monday 03 June 2002 01:50 pm, you wrote:
On 03.Jun.2002 -- 10:11 AM, daniel robinson wrote:
Hi,
I've been poking around but I'm clueless (yes, generally as well as
specifically).
I have some code that simply uses embedded Java in an XSP and a Java
temp file. This code processes a File that is submitted by the user's
Applet simulating a FORM with method=PUT. The user's FILE parameter is
an XML document produced by the applet. I have to insert the DTD stuff
because the Serializer I am generating this file from doesn't generate
the DTD statements.
After the file is pulled into a string and written to a File, I add it
to my PostgreSQL database as a BLOB.
?xml version=1.0 encoding=ISO-8859-1?
xsp:page
language=java
create-session=yes
xmlns:xsp=http://apache.org/xsp;
xmlns:session=http://apache.org/xsp/session/2.0;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:xsp-response=http://apache.org/xsp/response/2.0;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:log=http://apache.org/xsp/log/2.0;
xsp:structure
xsp:includejava.io.*/xsp:include
xsp:includejava.sql.*/xsp:include
/xsp:structure
page
content
xsp:logic
File output = null;
try {
String username = (String)
session:get-attribute name=username default=nobody /;
//System.err.println( username= + username );
String filename =
xsp-request:get-parameter name=FILENAME /;
//System.err.println( filename= + filename );
String config_data =
xsp-request:get-parameter name=FILE /;
//System.err.println( config_data= + config_data );
int position = config_data.indexOf( ![CDATA[product]] );
StringBuffer saveString = new StringBuffer( config_data.substring( 0,
position ) );
![CDATA[
saveString.append( !DOCTYPE product [\n +
!ELEMENT product (page+)\n +
!ELEMENT children (page+)\n +
!ELEMENT Company EMPTY\n +
!ELEMENT page (#PCDATA | Company | children)*\n +
!ATTLIST page level (1 | 2 | 3 | 4 | 5 | 8 ) #REQUIRED\n +
target CDATA #REQUIRED\n +
checkbox (true | false) #REQUIRED\n +
\n +
]\n );
]]
saveString.append( config_data.substring( position) );
output = File.createTempFile( phoenix_, .xml );
FileWriter fw = new FileWriter( output );
fw.write( saveString.toString() );
fw.close();
esql:connection
esql:driverorg.postgresql.Driver/esql:driver
esql:dburljdbc:postgresql://192.168.1.100:5432/test/esql:dburl
esql:usernamepostgres/esql:username
esql:password/esql:password
esql:execute-query
esql:queryUPDATE user_products SET
product_file=lo_import('xsp:exproutput.getAbsolutePath()/xsp:expr')
where name = esql:parameterxsp:exprusername/xsp:expr
AND productname =
esql:parameterxsp:exprfilename/xsp:expr/esql:parameter;/esql:query
esql:update-results
xsp:logic
int rows = esql:get-update-count/
/xsp:logic
/esql:update-results
esql:error-results
xsp:logic
System.err.println( Caught: + esql:get-message/
);
xsp:logic
esql:get-stacktrace/
/esql:error-results
/esql:execute-query
/esql:connection
/xsp:logic
session:set-attribute name=TEMPFILENAME
xsp:logicxsp:exproutput.getAbsolutePath()/xsp:expr/xsp:logic
/session:set-attribute
para
TEMPFILENAME=session:get-attribute name=TEMPFILENAME /
/para
/content
/page
/xsp:page
The above *might* work. If it doesn't, try to remove the
esql:parameter tags (and leave only the xsp:expr tags).
Chris.
--
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/faqs.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/faqs.html
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
SQL, Actions, ESQL Help Please!!!
Hi, I've been poking around but I'm clueless (yes, generally as well as specifically). What am I trying to do: 1) I have a PostgreSQL table with a field called StoryText defined as a Text (virtually unlmited size text data) 2) I wish to update this table with the contents of an XML element ( say StoryTexta lot of text with special characters like ' as well as html code a href=www.clueless.com/IAMwho is this noob?/a/StoryText 3) I've tried ESQL like this: esql:connection esql:poolVSolano/esql:pool esql:execute-query esql:query update Story set Title= 'xsp-request:get-parameter name=Title/', Description= 'xsp-request:get-parameter name=Description/', StoryText= 'xsp-request:get-parameter name=StoryText/' where ContentID = 'xsp-request:get-parameter name=ContentID/' /esql:query /esql:execute-query /esql:connection There have been many attempts :). I HAVE been able to update the table when I use literals and short values for the updates themselves (i.e. ...set Title='This is for noobs'). My questions: 1) should I be using ESQL or Actions? There has been some discussion on the listserve that seems to indicate that Actions are the way to go. 2) do the DatabaseActions work? there seems to have been a lot of confusion about this. 3) Does someone have examples - hopefully of exactly the sort of thing I'm trying to do - Store XML in the db - I'm sure I'm not the first. I am putting together documentation so that when this is all over I can SHARE IT, because no-one should have to live through this again. :) Thanks, Dan - 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: SQL, Actions, ESQL Help Please!!!
On 03.Jun.2002 -- 10:11 AM, daniel robinson wrote: Hi, I've been poking around but I'm clueless (yes, generally as well as specifically). What am I trying to do: 1) I have a PostgreSQL table with a field called StoryText defined as a Text (virtually unlmited size text data) Texts are a special case that is IMHO not handled. Texts (CLOBs and BLOBs) need to be read and written through a stream. Patches are welcome :-) 2) I wish to update this table with the contents of an XML element ( say StoryTexta lot of text with special characters like ' as well as html code a href=www.clueless.com/IAMwho is this noob?/a/StoryText esql:get-xml is your friend. But it requires well formed XML / XHTML. 3) I've tried ESQL like this: esql:connection esql:poolVSolano/esql:pool esql:execute-query esql:query update Story set Title= 'xsp-request:get-parameter name=Title/', Description= 'xsp-request:get-parameter name=Description/', StoryText= 'xsp-request:get-parameter name=StoryText/' where ContentID = 'xsp-request:get-parameter name=ContentID/' /esql:query /esql:execute-query /esql:connection There have been many attempts :). I HAVE been able to update the table when I use literals and short values for the updates themselves (i.e. ...set Title='This is for noobs'). See above. My questions: 1) should I be using ESQL or Actions? There has been some discussion on the listserve that seems to indicate that Actions are the way to go. In my opinion actions are great for inset / delete / update and esql is great for select. BTW the database actions do support CLOBs. 2) do the DatabaseActions work? there seems to have been a lot of confusion about this. They do work, although I advocate using the new ones form the actions.modular package (CVS-HEAD or CVS-2.0.3 scratchpad). Is there? If you can sumarize it I'd be happy to comment. 3) Does someone have examples - hopefully of exactly the sort of thing I'm trying to do - Store XML in the db - I'm sure I'm not the first. Sorry, not at hand. I am putting together documentation so that when this is all over I can SHARE IT, because no-one should have to live through this again. :) Speaking of documentation, there is some more on datbases and cocoon in CVS-2.0.3 or now live on site. See http://xml.apache.org/cocoon/userdocs/concepts/databases.html for a start. Plus, I'm currently (right now) writing a bit more on the esql logicsheet. Stay tuned. That shouldn't keep you from writing docs, though. We can't get enough of them! Chris. -- 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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQL, Actions, ESQL Help Please!!!
On Monday 03 June 2002 01:50 pm, you wrote:
On 03.Jun.2002 -- 10:11 AM, daniel robinson wrote:
Hi,
I've been poking around but I'm clueless (yes, generally as well as
specifically).
I have some code that simply uses embedded Java in an XSP and a Java
temp file. This code processes a File that is submitted by the user's
Applet simulating a FORM with method=PUT. The user's FILE parameter is
an XML document produced by the applet. I have to insert the DTD stuff
because the Serializer I am generating this file from doesn't generate
the DTD statements.
After the file is pulled into a string and written to a File, I add it
to my PostgreSQL database as a BLOB.
?xml version=1.0 encoding=ISO-8859-1?
xsp:page
language=java
create-session=yes
xmlns:xsp=http://apache.org/xsp;
xmlns:session=http://apache.org/xsp/session/2.0;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:xsp-response=http://apache.org/xsp/response/2.0;
xmlns:log=http://apache.org/xsp/log/2.0;
xsp:structure
xsp:includejava.io.*/xsp:include
xsp:includejava.sql.*/xsp:include
/xsp:structure
page
content
xsp:logic
File output = null;
try {
String username = (String)
session:get-attribute name=username default=nobody /;
//System.err.println( username= + username );
String filename =
xsp-request:get-parameter name=FILENAME /;
//System.err.println( filename= + filename );
String config_data =
xsp-request:get-parameter name=FILE /;
//System.err.println( config_data= + config_data );
int position = config_data.indexOf( ![CDATA[product]] );
StringBuffer saveString = new StringBuffer( config_data.substring( 0,
position ) );
![CDATA[
saveString.append( !DOCTYPE product [\n +
!ELEMENT product (page+)\n +
!ELEMENT children (page+)\n +
!ELEMENT Company EMPTY\n +
!ELEMENT page (#PCDATA | Company | children)*\n +
!ATTLIST page level (1 | 2 | 3 | 4 | 5 | 8 ) #REQUIRED\n +
target CDATA #REQUIRED\n +
checkbox (true | false) #REQUIRED\n +
\n +
]\n );
]]
saveString.append( config_data.substring( position) );
output = File.createTempFile( phoenix_, .xml );
FileWriter fw = new FileWriter( output );
fw.write( saveString.toString() );
fw.close();
try {
Class.forName( org.postgresql.Driver );
Connection conn =
DriverManager.getConnection(
jdbc:postgresql://192.168.1.100:5432/test, postgres, );
Statement stmt = conn.createStatement();
String update_statement = UPDATE user_products SET
product_file=lo_import( \' + output.getAbsolutePath() + \') +
where name = \' + username + \' +
AND productname = \' + filename + \';
//System.err.println( Update statement: + update_statement );
int rows = stmt.executeUpdate( update_statement );
//System.err.println( Rows updated: + rows );
stmt.close();
conn.close();
}
catch(ClassNotFoundException e ) {
System.err.println( Caught: + e );
e.printStackTrace();// @@@ ToDo exit properly
}
catch(SQLException sqle ) {
System.err.println( Caught: + sqle );
sqle.printStackTrace(); // @@@ ToDo exit properly
}
}
//output.delete();
catch( Exception e ) {
System.err.println( Caught: + e );
e.printStackTrace();
}
/xsp:logic
session:set-attribute name=TEMPFILENAME
xsp:logicxsp:exproutput.getAbsolutePath()/xsp:expr/xsp:logic
/session:set-attribute
para
TEMPFILENAME=session:get-attribute name=TEMPFILENAME /
/para
/content
/page
/xsp:page
-
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]
