Connection.TRANSACTION_SERIALIZABLE

I have a Java developer using a connection setting of
Connection.TRANSACTION_SERIALIZABLE to our SQL Server. How does this
connection setting interact with the code it touches? If it calls a stored
procedure that is using a nolock hint will it ignore it?
Thank!This doesn't appear to be an ODBC issue. Perhaps if you can't get a
response in this alias you could try a Java or JDBC alias?
--
| Thread-Topic: Connection.TRANSACTION_SERIALIZABLE
| thread-index: AcWsS/nqoR9CPWgEQMKylP56fG3lXw==
| X-WBNR-Posting-Host: 199.181.134.212
| From: "examnotes" <MichaelW@.discussions.microsoft.com>
| Subject: Connection.TRANSACTION_SERIALIZABLE
| Date: Sun, 28 Aug 2005 20:44:36 -0700
| Lines: 6
| Message-ID: <FC25F063-3ECA-42A7-9095-642ECCDB8CBC@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| 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.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2628
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| I have a Java developer using a connection setting of
| Connection.TRANSACTION_SERIALIZABLE to our SQL Server. How does this
| connection setting interact with the code it touches? If it calls a
stored
| procedure that is using a nolock hint will it ignore it?
|
| Thank!
||||I'm not seeing a JDBC section on here. Using non Microsoft JDBC connectiong
to SQL server.
"Warren Read" wrote:

> This doesn't appear to be an ODBC issue. Perhaps if you can't get a
> response in this alias you could try a Java or JDBC alias?
> --
> | Thread-Topic: Connection.TRANSACTION_SERIALIZABLE
> | thread-index: AcWsS/nqoR9CPWgEQMKylP56fG3lXw==
> | X-WBNR-Posting-Host: 199.181.134.212
> | From: "examnotes" <MichaelW@.discussions.microsoft.com>
> | Subject: Connection.TRANSACTION_SERIALIZABLE
> | Date: Sun, 28 Aug 2005 20:44:36 -0700
> | Lines: 6
> | Message-ID: <FC25F063-3ECA-42A7-9095-642ECCDB8CBC@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | 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.0
> | Newsgroups: microsoft.public.sqlserver.odbc
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2628
> | X-Tomcat-NG: microsoft.public.sqlserver.odbc
> |
> | I have a Java developer using a connection setting of
> | Connection.TRANSACTION_SERIALIZABLE to our SQL Server. How does this
> | connection setting interact with the code it touches? If it calls a
> stored
> | procedure that is using a nolock hint will it ignore it?
> |
> | Thank!
> |
>|||Try microsoft.public.sqlserver.jdbcdriver
Perhaps someone on this alias can address your question.
Good luck!
--
| Thread-Topic: Connection.TRANSACTION_SERIALIZABLE
| thread-index: AcWujdAXO+ZlWwwzSwq0xDayA4RnlA==
| X-WBNR-Posting-Host: 199.181.134.212
| From: "examnotes" <MichaelW@.discussions.microsoft.com>
| References: <FC25F063-3ECA-42A7-9095-642ECCDB8CBC@.microsoft.com>
<sBlO1worFHA.1204@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: Connection.TRANSACTION_SERIALIZABLE
| Date: Wed, 31 Aug 2005 17:40:55 -0700
| Lines: 41
| Message-ID: <29F51F66-4E80-452C-B2CC-D27A28063A20@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| 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.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2648
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| I'm not seeing a JDBC section on here. Using non Microsoft JDBC
connectiong
| to SQL server.
|
| "Warren Read" wrote:
|
| > This doesn't appear to be an ODBC issue. Perhaps if you can't get a
| > response in this alias you could try a Java or JDBC alias?
| > --
| > | Thread-Topic: Connection.TRANSACTION_SERIALIZABLE
| > | thread-index: AcWsS/nqoR9CPWgEQMKylP56fG3lXw==
| > | X-WBNR-Posting-Host: 199.181.134.212
| > | From: "examnotes" <MichaelW@.discussions.microsoft.com>
| > | Subject: Connection.TRANSACTION_SERIALIZABLE
| > | Date: Sun, 28 Aug 2005 20:44:36 -0700
| > | Lines: 6
| > | Message-ID: <FC25F063-3ECA-42A7-9095-642ECCDB8CBC@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | 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.0
| > | Newsgroups: microsoft.public.sqlserver.odbc
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2628
| > | X-Tomcat-NG: microsoft.public.sqlserver.odbc
| > |
| > | I have a Java developer using a connection setting of
| > | Connection.TRANSACTION_SERIALIZABLE to our SQL Server. How does this
| > | connection setting interact with the code it touches? If it calls a
| > stored
| > | procedure that is using a nolock hint will it ignore it?
| > |
| > | Thank!
| > |
| >
| >
|