writing in oracle database with java

[Stefan Seidel]

Hi NG,

i'm trying to create tables and to insert data into these tables using
oracle.jdbc.

(first a "create table" statement and then couple of "insert into"
statements)

There are no problems except for the last table. The table is created but
the data is not inserted.

This happens regardless of if i create 3,4,5 etc. tables with the last
table.

what am i doing wrong?

Stefan

[Daniel Morgan]

Stefan Seidel wrote:

Oracle version and edition?
Code sample?
JDBC driver being used?

Crystal ball is broken.

But I would advise you to not perform DDL on-the-fly. Tables should not be
built across a JDBC link as part of an application. Build them in SQL*Plus
and then leave them alone.
--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damo...@x.washington.edu
(replace 'x' with a 'u' to reply)

[Stefan Seidel]

Sorry, thought it might be something typical...

Oralce Ver. 9.0.1
jdbc version: ojdbc 1.4

Code example:

for(int i = 0;i< hierarchie.size();i++){

// CREATE TABLE
tableName = "DWH.snowflake_dim_" + i;
statementString = "CREATE TABLE " +tableName +
"(ID INTEGER,UEBER INTEGER)";
statement.executeUpdate(statementString);
Vector ebene = (Vector)hierarchie.elementAt(i);

// INSERT INTO
for(int z = 0;z < ebene.size(); z++){
statementString = "INSERT INTO "+tableName+" VALUES ("+
((Eintrag)(ebene.elementAt(z))).id+","+
((Eintrag)(ebene.elementAt(z))).ueber+")";

statement.executeUpdate(statementString);
}

"Daniel Morgan" <damo...@exxesolutions.com> wrote in message
news:3F4F7674...@exxesolutions.com...

[Rene Nyffenegger]

Stefan,

I'd say you forgot to commit the inserts. You see the other data because
create table does an implicit commit.

hth
Rene

--
Rene Nyffenegger
http://www.adp-gmbh.ch

[Maximus]

"Stefan Seidel" <sse...@uni-muenster.de> wrote in message
news:bint5i$qla$1...@redenix.uni-muenster.de...

> Sorry, thought it might be something typical...
>
> Oralce Ver. 9.0.1
> jdbc version: ojdbc 1.4
>
> Code example:
>
> for(int i = 0;i< hierarchie.size();i++){
>
> // CREATE TABLE
> tableName = "DWH.snowflake_dim_" + i;
> statementString = "CREATE TABLE " +tableName +
> "(ID INTEGER,UEBER INTEGER)";
> statement.executeUpdate(statementString);
> Vector ebene = (Vector)hierarchie.elementAt(i);
>
> // INSERT INTO
> for(int z = 0;z < ebene.size(); z++){
> statementString = "INSERT INTO "+tableName+" VALUES ("+
> ((Eintrag)(ebene.elementAt(z))).id+","+
>
((Eintrag)(ebene.elementAt(z))).ueber+")";
>
> statement.executeUpdate(statementString);
> }

Where are the commits?

[Jim Kennedy]

When he does the next create table statement. So maybe that is why he is
not seeing the last set of data, no commit. What is an uber integer?
Jim

"Maximus" <asdfa...@eqeqweqwe.com> wrote in message
news:M9Q3b.58367$la.11...@news1.calgary.shaw.ca...

[Maximus]

"Jim Kennedy" <kennedy-down_with_spammers@no_spam.comcast.net> wrote in
message news:O6U3b.301799$YN5.207911@sccrnsc01...

> When he does the next create table statement. So maybe that is why he is
> not seeing the last set of data, no commit. What is an uber integer?
> Jim

Makes sense, "executeUpdate('COMMIT')" after the inserts should fix that.

ueber integer... sounds like German for above, over, super... probably a
foreign key to the parent/master?

[Richard Kuhler]

Stefan Seidel wrote:
<snip>

> for(int i = 0;i< hierarchie.size();i++){
>
> // CREATE TABLE
> tableName = "DWH.snowflake_dim_" + i;
> statementString = "CREATE TABLE " +tableName +
> "(ID INTEGER,UEBER INTEGER)";
> statement.executeUpdate(statementString);
> Vector ebene = (Vector)hierarchie.elementAt(i);
>
> // INSERT INTO
> for(int z = 0;z < ebene.size(); z++){
> statementString = "INSERT INTO "+tableName+" VALUES ("+
> ((Eintrag)(ebene.elementAt(z))).id+","+
> ((Eintrag)(ebene.elementAt(z))).ueber+")";
>
> statement.executeUpdate(statementString);
> }
>

<snip>

I'd recommend you switch to using bind variables (set methods). If this
is a one time script you mike be ok without it but you're probably
scrambling the SGA pretty good here. As for the inserts missing, the
other posters are almost certainly right about the commit. Although,
since JDBC connections are auto-commit by default, this would assume
that you've changed it using the setAutoCommit method. That would seem
to indicate that you know about commits though and just didn't do it
here. Strange.

Richard Kuhler