Re: Why I cannot update the table?
Date: Fri, 26 Oct 2001 14:31:59 -0500
Message-ID: <9rcdmu$dhb$1_at_bob.news.rcn.net>
Are you sure that you are not locking your session?
For eg:
From SqlPlus do update table set filename = value;
From another window, if you run your java program to update the same table,
it will just wait for you to issue "commit" in your sqlplus session.
Exit from all your oracle sessions and run your Java program and let us know if you still have this problem.
bhogak.
ftp <shyan_at_cse.cuhk.edu.hk> wrote in message
news:9r8jcd$3o$3_at_eng-ser1.erg.cuhk.edu.hk...
> I have installed Oracle8i in Windows 2000.
> I can use update table_name set fieldname=value to update a record in
> sqlplus.
> Hoever, when I use JDBC (thin driver and OCI driver) and SQLJ, the program
> will block after calling uppdate table_name set fieldname=value. I need to
> press Ctrl-C to terminate the program.
>
> Why I cannot update record in database through Java program?
>
> --
Received on Fri Oct 26 2001 - 21:31:59 CEST