Re: Sybase and Enhydra

Hello Aaron

you wrote:
> Thanks Vladimir
> 
> This worked ok.
> 
> Now I am get another problem:
> 
> 2005-07-15 10:31:51,343: Problem while initializing caches !!!
> com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command not allowed 
> within mu
> lti-statement transaction.
> 
>        at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:3069)
>        at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2373)
>        at 
> com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>        at 
> com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
>        at 
> com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
>        at 
> com.sybase.jdbc3.jdbc.SybStatement.updateLoop(SybStatement.java:1811)
>        at 
> com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(SybStatement.java:17
> 94)
>        at 
> com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(SybPreparedS
> tatement.java:116)
>        at com.sybase.jdbc3.tds.Tds.setOption(Tds.java:1344)
>        at 
> com.sybase.jdbc3.jdbc.SybConnection.setAutoCommit(SybConnection.java:
> 1011)
>        at 
> com.lutris.appserver.server.sql.standard.StandardDBConnection.setAuto
> Commit(StandardDBConnection.java:669)
> ...
> Is there a fix for this or I have to look in the source?

Add this line into Shark.conf: <database_name> is probably sharkdb.
DatabaseManager.DB.<database_name>.ChangeAutocommit=false

http://dods.objectweb.org/doc/6.5/dods/inside_dods.html#d0e2014

hope this helps
-- 
Vlada

--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws