SET QUOTED IDENTIFIER in JDBC connection string

• Ken Davis

  SSCarpal Tunnel

  Points: 4329

  More actions

  November 16, 2010 at 9:16 am

  #141439

  I have an app that connects to a SQL 2005 database with JDBC. I have added some indexed views in the database to improve performance. But inserts fail because SET QUOTED_IDENTIFIER is OFF. I would like to set that parameter ON in the app connection string but I can't find the JDBC syntax for that.

  Does anyone know how to set that parm to ON in a JDBC connection string? thanks!

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  November 18, 2010 at 12:13 pm

  #1252695

  in connections container there is a function called createStatement().

  Use it to issue SET QUOTED_IDENTIFIER ON

  Alex S

• Ken Davis

  SSCarpal Tunnel

  Points: 4329

  More actions

  November 19, 2010 at 7:37 am

  #1253056

  Thanks for the reply. I talked to one of our developers about that. She thinks your suggestion would work in code but I was looking for something that goes in the connection string, like QuotedId=Yes in an ODBC connection string.

  But it turns out the connection string idea might not work because a lot of the vendor's stored procs are coded with SET QUOTED_IDENTIFIER OFF and that is causing my problem with the indexed views. I think the stored proc setting would override the connection string setting.