Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Table not found with jdbc sql statement

Table not found with jdbc sql statement

From: Simon Bieri <Simon.Bieri_at_sisclear.com>
Date: Thu, 30 Oct 2003 12:53:55 +0100
Message-ID: <bnqtth$1447qm$1@ID-151365.news.uni-berlin.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US