Re: esql !!!HELP!!!

[Christian Haul]

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

[Frank Taffelt]

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

[Tim Bachta]

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:


{call rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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

 internal. set one parameter of a callable statement



_esql_query.getCallableStatement().
registerOutParameter(,
,  );


_esql_query.getCallableStatement().




 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:


{? = rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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: 

Re: esql !!!HELP!!!

[Roger I Martin PhD]

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

 internal. set one parameter of a callable statement



_esql_query.getCallableStatement().
registerOutParameter(, ,  );


_esql_query.getCallableStatement().




 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:


{? = rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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+Procedur

RE: esql !!!HELP!!!

[Tim Bachta]

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:


{? = rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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:
>
>
>
> 
>
> {? = rptLocationDeviations(type="Int">number,direction="in"
>type="String">room,direction="in"
>type="String">beginTime,meter direction="in"
>type="String">endTime)}
>
> 
>
> 
>
> 
>
> 
>
> 
>
> column="1" from-call="true"/>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
>
>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.c

RE: esql !!!HELP!!!

[Tim Bachta]

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:


{? = rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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:
>
>
>
> 
>
> {? = rptLocationDeviations(type="Int">number,direction="in"
>type="String">room,direction="in"
>type="String">beginTime,meter direction="in"
>type="String">endTime)}
>
> 
>
> 
>
> 
>
> 
>
> 
>
> column="1" from-call="true"/>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
>
>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 

RE: esql !!!HELP!!!

[Geoff Howard]

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:




{? = rptLocationDeviations(number,room,beginTime,endTime)}





































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

[Tim Bachta]

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:





{? = rptLocationDeviations(number,room,beginTime,endTime)}























 














 

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

[Tim Bachta]

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:





{? = rptLocationDeviations(number,room,beginTime,endTime)}























 














 

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

[Scherler, Thorsten]

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:





{? = rptLocationDeviations(number,room,beginTime,endTime)}























 














 

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]

esql !!!HELP!!!

[Tim Bachta]

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





{? = rptLocationDeviations(number,room,beginTime,endTime)}























 














 

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

[Scherler, Thorsten]

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


-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

[Tim Bachta]

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]

Re: Cocoon/XSP/ESQL help

[Leszek Gawron]

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.
> 
> 
> 
>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";>
>   
>   
>   mpts-pool
> 
>   
>   
>   { call sp_DayShift_Report_ListByName 
>   ((   
>type="String">) 
> }
>   
> 
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
> 
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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

RE: Cocoon/XSP/ESQL help - Finally

[Brian Campbell]

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.
> >>
> >>{ call sp_DayShift_Report_ListByName((
> >>direction="in" type="String">
> >>name="sQuerry"/>) }
> >>
> >>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

[Brian Campbell]

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.
> >>
> >>{ call sp_DayShift_Report_ListByName((
> >>direction="in" type="String">
> >>name="sQuerry"/>) }
> >>
> >>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

[Geoff Howard]

>
> 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:
>
>   
>   {Call
> sp_DayShift_Report_ListByName (
>
> type="String">'----')}
>   

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.
> >>
> >>{ call sp_DayShift_Report_ListByName(( >>direction="in" type="String"> >>name="sQuerry"/>) }
> >>
> >>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

[Brian Campbell]

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:


	{Call sp_DayShift_Report_ListByName (
 
		type="String">'----')}



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

{ call sp_DayShift_Report_ListByName((
direction="in" type="String">
name="sQuerry"/>) }

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

[Brian Campbell]

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.

{ call sp_DayShift_Report_ListByName((
direction="in" type="String">
name="sQuerry"/>) }

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

[Jacob Arnold]

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

{ call sp_DayShift_Report_ListByName(() }

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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

RE: Cocoon/XSP/ESQL help

[Brian Campbell]

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.




		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";>
	
		
			mpts-pool

			

	{ call sp_DayShift_Report_ListByName
((

type="String">
name="sQuerry"/>) }



	
		
			
		
	

			
		
	





-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

[Jacob Arnold]

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.



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";>


mpts-pool



{ call sp_DayShift_Report_ListByName
(() }

















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

Cocoon/XSP/ESQL help

[Brian Campbell]

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.




		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";>
	
		
			mpts-pool

			

	{ call sp_DayShift_Report_ListByName ((
 			type="String">) }



	
		
			
		
	

			
		
	





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

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: SQL, Actions, ESQL Help Please!!!

[Conny Pemfors]

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.
> >
> >
> > 
> >
> >  > 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";>
> >
> >   
> > java.io.*
> > java.sql.*
> >   
> > 
> >   
> >   
> >   File output = null;
> > try {
> >
> > String username = (String)
> > ;
> > //System.err.println( "username=" + username );
> >
> > String filename =
> > ;
> > //System.err.println( "filename=" + filename );
> >
> > String config_data =
> > ;
> > //System.err.println( "config_data=" + config_data );
> >
> > int position = config_data.indexOf(  );
> >
> > StringBuffer saveString = new StringBuffer( config_data.substring( 0,
> > position ) );
> > 
> > saveString.append( config_data.substring( position) );
> >
> > output = File.createTempFile( "phoenix_", ".xml" );
> >
> > FileWriter fw   = new FileWriter( output );
> >
> > fw.write( saveString.toString() );
> >
> > fw.close();
> >
> 
> org.postgresql.Driver
> jdbc:postgresql://192.168.1.100:5432/test
> postgres
> 
> 
>UPDATE user_products SET
product_file=lo_import('"output.getAbsolutePath()"')
>where name = username
>  AND productname =
filename;
>
>   
>int rows =  
>   
>
>
>   
>  System.err.println( "Caught: " + 
> );
>   
>   
>
> 
>  
>
> > 
> > 
> > output.getAbsolutePath()
> > 
> > 
> > TEMPFILENAME=
> > 
> > 
> > 
> > 
>
> 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]>

Re: SQL, Actions, ESQL Help Please!!!

[Christian Haul]

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.
> 
> 
> 
> 
>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";>
> 
>   
> java.io.*
> java.sql.*
>   
> 
>   
> 
> File output = null;
> try {
>   
>   String username = (String)
>   ;
>   //System.err.println( "username=" + username );
> 
>   String filename = 
>   ;
>   //System.err.println( "filename=" + filename );
> 
>   String config_data = 
>   ;
>   //System.err.println( "config_data=" + config_data );
> 
>   int position = config_data.indexOf(  );
> 
>   StringBuffer saveString = new StringBuffer( config_data.substring( 0, 
> position ) );
>   
>   saveString.append( config_data.substring( position) );
> 
>   output = File.createTempFile( "phoenix_", ".xml" );
> 
>   FileWriter fw   = new FileWriter( output );
> 
>   fw.write( saveString.toString() );
>   
>   fw.close();
> 

org.postgresql.Driver
jdbc:postgresql://192.168.1.100:5432/test
postgres


   UPDATE user_products SET 
product_file=lo_import('"output.getAbsolutePath()"')
   where name = 
username
 AND productname = 
filename;
   
  
 int rows =  
   
   
   
  
 System.err.println( "Caught: " + 
 );
  
  
   

 

> 
>   
>   output.getAbsolutePath()
>   
>   
>   TEMPFILENAME=
>   
> 
> 
> 

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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Re: SQL, Actions, ESQL Help Please!!!

[John Austin]

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.




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";>

  
java.io.*
java.sql.*
  

  
  
  File output = null;
try {

String username = (String)
;
//System.err.println( "username=" + username );

String filename = 
;
//System.err.println( "filename=" + filename );

String config_data = 
;
//System.err.println( "config_data=" + config_data );

int position = config_data.indexOf(  );

StringBuffer saveString = new StringBuffer( config_data.substring( 0, 
position ) );

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();
}


output.getAbsolutePath()


TEMPFILENAME=







-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Re: SQL, Actions, ESQL Help Please!!!

[Christian Haul]

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
> 
> a lot of text with special characters like ' as well as
> html code who is this
> noob?

esql:get-xml is your friend. But it requires well formed XML / XHTML.

> 3) I've tried ESQL like this:
> 
> 
>  VSolano
>  
>
> 
> 
> update "Story" set "Title"= ' name="Title"/>',
>   "Description"= ' name="Description"/>',
>   StoryText"= ' name="StoryText"/>'
> where "ContentID" = ' name="ContentID"/>'
> 
>
>  
>
> 
> 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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

SQL, Actions, ESQL Help Please!!!

[daniel robinson]

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

a lot of text with special characters like ' as well as
html code who is this
noob?

3) I've tried ESQL like this:


 VSolano
 
   


update "Story" set "Title"= '',
  "Description"= '',
  StoryText"= ''
where "ContentID" = ''

   
 
   

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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>