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: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 29 Aug 2003 16:59:55 GMT
Message-ID: <bio0qb$bigmm$1@ID-82536.news.uni-berlin.de>

> 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,

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
Received on Fri Aug 29 2003 - 11:59:55 CDT

Original text of this message

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