Article View: comp.lang.java.databases
Article #35ORACLE and QUOTE identifier
From: uncle.scrooge
Date: Thu, 02 Sep 1999 00:00
Date: Thu, 02 Sep 1999 00:00
33 lines
1952 bytes
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-mailShow 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