Re: Setting the Isolation Level in the Connection Properties

Just trying to understand your scenario, we currently don't allow changing 
the default isolation level at the connection level and I really don't see a 
good reason for this feature right of the bat.

The one thing that may be interesting is when you want to modify the default 
ReadCommitted transaction level to Snapshot, fortunatelly this can be 
achieved at the DBMS level by setting  READ_COMMITTED_SNAPSHOT to ON on the 
database that your application is using. When this is set all your Read 
Committed transactions (Default) will behave as Snaphot transactions.

Hope this helped, if not please expand on the scenario that you are 
interested in.
-- 
Angel Saenz-Badillos [MS] DataWorks
This posting is provided "AS IS", with no warranties, and confers no 
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://weblogs.asp.net/angelsb/




"pjhavariotis" <pjhavariotis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message 
news:4A1C375B-0262-46D0-971F-D3FD1FE31C27@xxxxxxxxxxxxxxxx
>I am using the newly released JDBC driver (SQL Server 2005 JDBC Driver) 
>with
> WebSphere Application Server 5.1.1.
> Is it possible to setup the isolation level for ALL the connections of the
> pool in the connection properties of the datasource?
>
> Thanks for your help. 


.

Relevant Pages

  • Re: Working Transactions somehow started not to work
    ... For the simple reason: transactions and locking involve ... Client-based cursors create their own ... the server-based cursors, hence from locking, hence from transactions. ... SL> Instead of using one of the connection created by Access, ...
    (microsoft.public.access.adp.sqlserver)
  • RE: [Full-Disclosure] RE: MS SQL WORM IS DESTROYING INTERNET BLOCK PORT 1434!
    ... sites is not that transactions are going over the Internet through vpn ... connection for that matter when you can get thousands from a SQL database?) ... Subject: [Full-Disclosure] RE: MS SQL WORM IS DESTROYING INTERNET ...
    (Full-Disclosure)
  • Re: Working Transactions somehow started not to work
    ... are not associated necessarily with server-based cursors. ... For the simple reason: transactions and locking involve ... SL> Instead of using one of the connection created by Access, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cross Transactions between ADO & ADO.Net
    ... connection--it thrashes the server unnecessarily and discards useful server ... goes away and quietly reopen the connection when they return. ... > DTC transactions are not only heavy, they might also cause deadlocks due ... We even call ADO ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Working Transactions somehow started not to work
    ... For the simple reason: transactions and locking involve ... the server-based cursors, hence from locking, hence from transactions. ... make begintrans etc. fully working in ADP, but then it was stopped in the ... SL> Instead of using one of the connection created by Access, ...
    (microsoft.public.access.adp.sqlserver)
Loading