Re: setReadOnly(true) with SQL Server 2005 JDBC Driver v1.0 released

Rolle,
What exactly are you expecting setReadOnly to do for you when running
against Sql Server? As far as I am aware this method was placed in the JDBC
API to provide the option for a performance optimized mode for the driver,
this may be useful for other RDBMS but for Sql Server we just did not see a
need. No read-only mode optimizations are currently planned, I would be
interested to know more about your scenario.

--
Angel Saenz-Badillos [MS] Data Programmability
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://blogs.msdn.com/angelsb/




"rolle" <rolle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B9A431C-0F14-49E4-9FB9-4DDFA14936BC@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: How to retrieve stored procedure error code in C#?
    ... Mark and William - thx for the replies, as they pointed me in the right ... > All Sql Server stored procedures have a return value parameter, ... > Please do not send email directly to this alias. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Merge Replication using ip address to distributor/publisher
    ... is no enterprize manager or client network utility. ... I also read that alias to ip address can be programmed in subscriber ... register the Publisher in Client Network Utility." ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • change a named instance to default instance
    ... Produced By Microsoft MimeOLE V6.00.2800.1441 ... even though there is only one SQL Server ... | Is there anyway I can make my named instance behave like the default? ... Configure an Alias by Using TCP/IP Sockets ...
    (microsoft.public.sqlserver.connect)
  • Re: Data Source connection fail
    ... In "SQL Server Client Network Utility", and in Alias tab I created a server alias with remote SQL Server IP address and port configured and "Network libraries" set to TCP/IP. ... I created a DTS Package and created a new "Microsoft OLE DB Connection for SQL Server". ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server VPN problems / Help
    ... Create Alias to SQL server from your machine using CLIEN NETWORK UTILITY, ... I want to use the remote SQL as ...
    (microsoft.public.sqlserver.server)
Loading