Re: writing in oracle database with java

"Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in message news:O6U3b.301799$YN5.207911_at_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?

>
>
> "Maximus" <asdfasdasd_at_eqeqweqwe.com> wrote in message
> news:M9Q3b.58367$la.1191531_at_news1.calgary.shaw.ca...
> > "Stefan Seidel" <sseidel_at_uni-muenster.de> wrote in message
> > news:bint5i$qla$1_at_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?
> >
> >
>
>
Received on Sat Aug 30 2003 - 00:18:32 CDT