Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: writing in oracle database with java
"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 - 17:08:44 CDT