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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > > To: "Cocoon mailing list" <[EMAIL PROTECTED]> > 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: <[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]>
