Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Quote identifier setting

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-18 19:36:59.0Z
Kevin Ewert Posted on 1997-07-15 03:14:45.0Z
Message-ID: <33CAEB25.280@hp.com>
Date: Mon, 14 Jul 1997 20:14:45 -0700
From: Kevin Ewert <kevin_ewert@hp.com>
Reply-To: kevin_ewert@hp.com
Organization: Pacific Technology Park
X-Mailer: Mozilla 3.0Gold (WinNT; U)
MIME-Version: 1.0
Subject: Quote identifier setting
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 17
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:547
Article PK: 252299

Our java JDBC seems to have broken over the weekend. Literals in double
qoutes are now being treated as identifiers. The only related activity
that we think occurred was to run the sql_server.sql script.

Our investigation led us to the CONNECTCONFIG value in the spt_mda
table. When we changed the query value from CONNECTCONFIG from "set
quoted_identifier on" to "set quoted_identifier off", our programs
started working again.

The sql_server.sql script does indeed set CONNECTCONFIG to the "on"
value. Should this value be normally "off"? If so, when and how is it
set to the "off" value in the first place?


kevin_ewert@hp.com


Lance Andersen Posted on 1997-07-18 19:36:59.0Z
Message-ID: <33CFC5DB.6C7@sybase.com>
Date: Fri, 18 Jul 1997 15:36:59 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: kevin_ewert@hp.com
Subject: Re: Quote identifier setting
References: <33CAEB25.280@hp.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:508
Article PK: 252259

When a connection is made to the server, the CONNECTCONFIG
commands are executed.

You can turn this off as you did, execute a specific

set quoted identifier off when you connect

or use single quotes instead of double quotes in your queries.


I am not sure why we are doing this by default when the sql server
default is 'off'. I am checking on this..


-lance

Kevin Ewert wrote:
>
> Our java JDBC seems to have broken over the weekend. Literals in double
> qoutes are now being treated as identifiers. The only related activity
> that we think occurred was to run the sql_server.sql script.
>
> Our investigation led us to the CONNECTCONFIG value in the spt_mda
> table. When we changed the query value from CONNECTCONFIG from "set
> quoted_identifier on" to "set quoted_identifier off", our programs
> started working again.
>
> The sql_server.sql script does indeed set CONNECTCONFIG to the "on"
> value. Should this value be normally "off"? If so, when and how is it
> set to the "off" value in the first place?
>
> kevin_ewert@hp.com

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================