Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Table not found with jdbc sql statement
Hi
I have a big problem. I created some tables in a db with a standard sql
script (script is below).
Now I try to select the table DbTableOne with a normal java script via
oracles jdbc thin driver (I tried with both classes111.zip as well
classes12.zip). When I enter the table name without double quotes
(DbTableOne), I can connect to it. When I enter the table name with the
double quotes ("DbTableOne"), I receive the error message, that there's
no such table.
What's wrong? With SQL 99 standard this should not be a problem?
Please, help me!
Here's the sql script.
@define.sql
@crspool 101_cr_table
@whoami
CREATE TABLE "DbTableOne"
(
"DateTime" VARCHAR2(20) NOT NULL,
"Id" VARCHAR2(8) NULL,
"Status" VARCHAR2(2) NULL,
"ErrorDescr" VARCHAR2(300) NULL,
"MessageTextA" VARCHAR2(2000) NULL,
"MessageTextB" VARCHAR2(2000) NULL,
"MessageTextC" VARCHAR2(2000) NULL,
"MessageTextD" VARCHAR2(2000) NULL,
"MessageTextE" VARCHAR2(2000) NULL
)
TABLESPACE &TBS_D01;
CREATE TABLE "DbTableTwo"
(
"DateTime" VARCHAR2(20) NOT NULL,
"Id" VARCHAR2(8) NULL,
"Status" VARCHAR2(2) NULL,
"ErrorDescr" VARCHAR2(300) NULL,
"MessageTextA" VARCHAR2(2000) NULL,
"MessageTextB" VARCHAR2(2000) NULL,
"MessageTextC" VARCHAR2(2000) NULL,
"MessageTextD" VARCHAR2(2000) NULL,
"MessageTextE" VARCHAR2(2000) NULL
)
TABLESPACE &TBS_D01;
usw.
spool off
-- I believe the entire IQ of mankind is a constant while the count of human being is constantly increasing. (As you can see in the governments of the world) -!Bitte Reply-To beachten!-Received on Thu Oct 30 2003 - 05:53:55 CST