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]
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
