You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by JL Ardoin <jl...@noos.fr> on 2002/05/29 14:49:02 UTC
Sybase database acces with Cocoon
Hi all !
Discovering Cocoon , I try to use it with Sybase ASE 11.9 .
Dynamic SQL seems to work perfectly, but I can't make SQL stored procs
running,
for example - sp_who - even after reading the documentation !!
- Is it working ?
- and if your answer is affirmative, is Cocoon running
with multi-recordsets SQL stored procedures ?
with
Cocoon 2.0.2
Tomcat 4.03b
Windows 2000 Pro
Any example ?
TIA
JL
Trouver sa place dans le Cosmos...
RE: Sybase database acces with Cocoon
Posted by JL Ardoin <jl...@noos.fr>.
Thanks a lot for your answer,
I've tried an XSP with ESQL which seems to be easier
for discovering C2. I use Jconnect5.5 from Sybase as a jdbc driver.
I try to evaluate a Cocoon solution for building a Web application
with existing SP (many parameters and resultsets ) against
a JSP solution. And the first pb could be the interface with Sybase.
Which version could be the better to test it ?
TIA
JL
-----Original Message-----
From: Christian Haul [mailto:haul@dvs1.informatik.tu-darmstadt.de]
Sent: mercredi 29 mai 2002 15:32
To: cocoon-users@xml.apache.org
Subject: Re: Sybase database acces with Cocoon
On 29.May.2002 -- 02:49 PM, JL Ardoin wrote:
> Hi all !
>
> Discovering Cocoon , I try to use it with Sybase ASE 11.9 .
> Dynamic SQL seems to work perfectly, but I can't make SQL stored procs
> running,
> for example - sp_who - even after reading the documentation !!
What means do you use to formulate your SQL? SQLTransformer, ESQL
Logicsheet, DatabaseActions, ... ?
SP support is there for SQLTransformer and ESQL. Sybase should be
supported as long as it conforms to JDBC specs.
> - and if your answer is affirmative, is Cocoon running
> with multi-recordsets SQL stored procedures ?
Yes, there have been some modifications in this area in 2.1-dev for
ESQL that haven't been propagated to 2.0.3 yet. Since there haven't
been complaints so far they will show up in 2.0.3 later on. Anyway,
multiple results are already supported but update counts may only be
last.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Sybase database acces with Cocoon
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 29.May.2002 -- 02:49 PM, JL Ardoin wrote:
> Hi all !
>
> Discovering Cocoon , I try to use it with Sybase ASE 11.9 .
> Dynamic SQL seems to work perfectly, but I can't make SQL stored procs
> running,
> for example - sp_who - even after reading the documentation !!
What means do you use to formulate your SQL? SQLTransformer, ESQL
Logicsheet, DatabaseActions, ... ?
SP support is there for SQLTransformer and ESQL. Sybase should be
supported as long as it conforms to JDBC specs.
> - and if your answer is affirmative, is Cocoon running
> with multi-recordsets SQL stored procedures ?
Yes, there have been some modifications in this area in 2.1-dev for
ESQL that haven't been propagated to 2.0.3 yet. Since there haven't
been complaints so far they will show up in 2.0.3 later on. Anyway,
multiple results are already supported but update counts may only be
last.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>