Re: postioned update on ORACLE

Elton-

    I believe at least Oracle 7.3 supports cursor updates, but perhaps the JDBC driver you are using does not.

    Check with the supplier of the driver.

-David Small
Blessing/White, Inc.

Elton Chan <97980015r_at_polyu.edu.hk> wrote in message <6cjgoe$u6v1_at_hkpa05.polyu.edu.hk>...
>Hi all,
>
> Does anybody knows if positioned update can be enabled on ORACLE?
>I use the follow code and try to use postioned update on a ORACLE 7.0
>server. However, it found that ORACLE does not support this feature.
>
> try{
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> String URL = "jdbc:odbc:SUNSERVER";
> String username = "";
> String password = "";
>
> Connection con = DriverManager.getConnection(URL, "", "");
>
> DatabaseMetaData dmd = con.getMetaData();
>
> if (dmd.supportsPositionedUpdate() == false) {
> System.out.println("Positioned update is not supported by
>this database.");
> System.exit(-1);
> }
>
>Elton
>
>
Received on Thu Feb 26 1998 - 00:00:00 CET