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:[EMAIL PROTECTED]]
Sent: mercredi 29 mai 2002 15:32
To: [EMAIL PROTECTED]
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
[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]>

Reply via email to