cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christophe Rykiel" <c.ryk...@rectangle.fr>
Subject Re: JConnect / Sybase + Cocoon
Date Tue, 22 Jan 2002 19:23:34 GMT
I did run the script when I did install JDBC and I have a few JAVA apps
running and currently using the DBASE without any apparent problem.
the SQL server is Sybase 11.9.2 in a linux box.

I created the tables and entries needed for the samples to run, and just
changed the datasource.

I go to the "manage employee" example and try to modify a few entries.
after 2 or 3 times ( I have a 5 min  10 max connection pool ) I get the
following error:

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get
the datasource java.sql.SQLException: SET CHAINED is not authorized inside a
transaction implying more than one instruction


Any clues ?????

Cheers,

Christophe Rykiel

From: "Christopher Painter-Wakefield" <paint007@mc.duke.edu>
To: <cocoon-users@xml.apache.org>
Sent: Tuesday, January 22, 2002 4:43 PM
Subject: Re: JConnect / Sybase + Cocoon


>
> Have you set up your Sybase for JDBC?  We were having similar problems
> until we had our DBA run a script (provided with jConnect in the "sp"
> subdirectory) to set up a bunch of stored procedures that jConnect needs.
> See
>
http://manuals.sybase.com/onlinebooks/group-jc/jcg0520e/jconnig/@Generic__Bo
okView
>
> under "Installation Instructions" and then under "Installing Stored
> Procedures".
>
> If that isn't the issue, then it sounds like you have some code that is
> setting autocommit to false, modifying data, then failing to issue a
> "commit".  This leaves your transaction pending, and you can see why they
> wouldn't want you changing the autocommit setting until the transaction is
> done.
>
> -Christopher
>
>
>
>
> Please respond to cocoon-users@xml.apache.org
>
> To:   "Cocoon mailing list" <cocoon-users@xml.apache.org>
> cc:
>
> Subject:  JConnect / Sybase + Cocoon
>
>
> Hi all,
> I am having trouble on cocoon2 with the connection pool. It seems that
> sybase doesn't allow to change the connection mode ( ie: setAutoCommit() )
> after a chained transaction has taken place ( a transaction with the
> autocommit to false ). Is there a fix for Avalon or some parameters i am
> missing ?
>
>             Thanks in advance,
>
> Christophe Rykiel
> C.T.O
> RECTANGLE
>
>
>
>
> ---------------------------------------------------------------------
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message