Cocoon and informix stored procedures

[Anna Bikkina <an...@pinksheets.com>]

Hi,

I have to some a web app that runs stored procedures in informix. Gets the 
data in xml and converts to html,(tables),excel and other formats. Hence I 
choose cocoon to write my webapp.

 Is there a way I can call a stored procedure from cocoon and convert the 
resultset into xml. The database we are using is informix. The data obtained 
from the stored procedure could be in tens of thousands or records.

Can cocoon handle such huge data?

Can someone please answer my questions.

Thanks,
Anna.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: Cocoon and informix stored procedures

[Christian Haul <ha...@informatik.tu-darmstadt.de>]

Anna Bikkina wrote:
> Hi,
> 
> I have to some a web app that runs stored procedures in informix. Gets the 
> data in xml and converts to html,(tables),excel and other formats. Hence I 
> choose cocoon to write my webapp.
> 
>  Is there a way I can call a stored procedure from cocoon and convert the 
> resultset into xml. The database we are using is informix. The data obtained 
> from the stored procedure could be in tens of thousands or records.

I'd go for ESQL (and XSP) in this case. Pls see docs on ESQL. When 
calling INFORMIX SP bear in mind that you may not use execute() but
executeQuery() (at least last time I looked at the driver) and you need
to set the corresponding flag for ESQL.

> Can cocoon handle such huge data?

Yes.

	Chris.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org