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="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:para
meter direction="in"
type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}</esql:call
>
<esql:call-results>
<esql:use-results>
<esql:result><xsp: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-Type"><xsl:with-param name="type"><xsl:value-of
select="@type"/></xsl:with-param></xsl:call-template><xsl: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="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:para
meter direction="in"
type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}
</esql:call>
<esql:call-results>
<esql:use-results>
<esql:result><xsp: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_8888)
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="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
>direction="in"
>type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:paramete
r
>direction="in"
>type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:par
a
>meter direction="in"
>type="String"><xsp:expr>endTime</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]
---------------------------------------------------------------------
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]
