RE: setReadOnly(true) with SQL Server 2005 JDBC Driver v1.0 released
- From: evanba@xxxxxxxxxxxxxxxxxxxx (Evan T. Basalik (MSFT))
- Date: Tue, 29 Aug 2006 19:12:43 GMT
Our driver exposes this call to conform to the JDBC specification. However, SQL Server does support read-only connections, so this call will always return
false. To be clearer, the documentation should probably say something like "not supported by SQL Server".
Evan
--------------------
Thread-Topic: setReadOnly(true) with SQL Server 2005 JDBC Driver v1.0 released
thread-index: AcbKg0fyrSN0L/fEQR2BKom3AP0a7Q==
X-WBNR-Posting-Host: 194.55.212.71
From: =?Utf-8?B?cm9sbGU=?= <rolle@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: setReadOnly(true) with SQL Server 2005 JDBC Driver v1.0 released
Date: Mon, 28 Aug 2006 02:21:02 -0700
Lines: 13
Message-ID: <4B9A431C-0F14-49E4-9FB9-4DDFA14936BC@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.jdbcdriver
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.jdbcdriver:8049
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
Hello,
I try to set the readOnly-Flag of a connection by calling the method
connection.setReadOnly(true);
This doesn´t seem to work because the method connection.isReadOnly() then
always returns false. (Also read in the docs that these methods are not
"currently" supported - whatever this means...?!)
Is there a way to set (and get) the readOnly-Flag in an other way?
Cheers,
rolle
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
.
- Prev by Date: Re: Integrating w/ 3rd party TransactionManager?
- Next by Date: Re: MS SQL Server 2005 JDBC Driver Performance Issue
- Previous by thread: Re: setReadOnly(true) with SQL Server 2005 JDBC Driver v1.0 released
- Next by thread: RE: HA Cluster & XA Transactions
- Index(es):
Relevant Pages
|
Loading
