🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.java.databases
Article #35

ORACLE and QUOTE identifier

#35
From: uncle.scrooge
Date: Thu, 02 Sep 1999 00:00
33 lines
1952 bytes
I'm using oracle's thin drivers to access an oracle 8.0.5 database. I'm
also jbuilder 2.0.

My problem is that I have legacy schema definitiions in sybase with
lowercase column names.
I want this same definitions to work with oracle. No problem you say?
Oracle is case insensitive you say?

To keep a long story short, this is what's happening:

- give a table such as
    create table foo (X number)

- this insert works
    insert into foo ("X", 100)

- this doesn't
    insert into foo ("x", 100).

With the latter I get the quintissential "invalid column name" problem.
The SQL is generated for me
from all the layers I'm using (jbuilder, jdbc, oracle driver etc).

I can't change my column names easily, since if I do so, the code will
stop working with sybase.

So...
    - At the java driver level, is there a way to set what the "quoted
identifier" character should be? or to tell the database not to use it?
   or..
    - is there way at the server level to make the above 2 inserts
behave the same?
Technical Details
Message-ID: <37CF1CE6.711D5F04@worldnet.att.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10fec3,431bbdfd88a4a1f,start
X-Google-Attributes: gid10fec3,public
X-Google-Thread: 1073da,431bbdfd88a4a1f,start
X-Google-Attributes: gid1073da,public
X-Google-Thread: 107d46,431bbdfd88a4a1f,start
X-Google-Attributes: gid107d46,public
From: "uncle.scrooge" <uncle.scrooge@worldnet.att.net>
Subject: ORACLE and QUOTE identifier
Date: 1999/09/02
Message-ID: <37CF1CE6.711D5F04@worldnet.att.net>
X-Deja-AN: 520414403
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@worldnet.att.net
X-Trace: bgtnsc02.worldnet.att.net 936320160 17842 12.77.27.60 (3 Sep 1999 00:56:00 GMT)
Organization: AT&T WorldNet Services
Mime-Version: 1.0
NNTP-Posting-Date: 3 Sep 1999 00:56:00 GMT
Newsgroups: comp.lang.java.databases,comp.databases.oracle,borland.public.jbuilder.database