Re: Sybase and Enhydra

Ok that did the trick. Its working finally...

Thanks
Aaron

Vladimir Puskas wrote:

> 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
>
>------------------------------------------------------------------------
>
>
>--
>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
>  
>

---
[This E-mail was scanned for spam and viruses by NextGen.net.]

--
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