Hello,

How can I change the default isolation level for JDBC connections?

I´ve already changed "dbo.sp_mda" and "dbo.sp_tsql_environment" system
procedures, but nothing changed. It´s always value "1". The database
default is set to "0".

My server is running on SQL Anywhere 9.0.2.3687.

This is the JDBC Parameters on my Cold Fusion Server:

URL: jdbc:sybase:Tds:10.2.2.43:49152/ftsjdb
CLASS: com.sybase.jdbc2.jdbc.SybDriver

Thanks,
Thiago<thiago.reis (AT) embraer (DOT) com.br>

I´ve changed my JDBC config and now I´m using iAnywhere JDBC driver

URL: jdbc:ianywhere:dsn=sybase_bdi
CLASS: ianywhere.ml.jdbcodbc.IDriver

Unfortunately I´m still getting isolation level = 1.

The application is a Cold Fusion page that runs a simple CFQuery,
WITHOUT the <cftransaction> tag.


Any clue?

Thiago.

Thiago,

Thiago wrote:
At the JDBC level, this is a Connection.setTransactionIsolation() call:
http://java.sun.com/javase/6/docs/ap...nIsolation(int)

For ColdFusion, the solution really seems to be running it WITH the
<cftransaction> tag as the ColdFusion docs would suggest:
http://livedocs.adobe.com/coldfusion...0 0000346.htm

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/