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

Home -> Community -> Usenet -> c.d.o.misc -> Re: writing in oracle database with java

Re: writing in oracle database with java

From: Maximus <asdfasdasd_at_eqeqweqwe.com>
Date: Fri, 29 Aug 2003 22:08:44 GMT
Message-ID: <M9Q3b.58367$la.1191531@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 - 17:08:44 CDT

Original text of this message

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