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" <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 Fri Aug 29 2003 - 21:38:38 CDT
