Very Computer

The statement I'm trying basically looks like:

INSERT INTO table (column) VALUES (nvl(max(column) + 1, 1))

(i.e. if no data, start at 1, otherwise add 1 to the current max)

So apparently it can't be done like this - how best can this be done without
the possibility that another client comes in in between calls (i.e. if I
first made a call to see what the max is, then the next call would be the
insert)

TIA,
mark

I have:
    - Solaris box
    - JDK 1.1.6
    - JDK 1.3 installed in another directory
    - Oracle 8.1.5
    - DB.java - a class that does the work involved with connecting to a test
database
    - TEST.java - a main program class that uses DB to fetch data from the test
database
    - everything is on the solaris box

The java program compiles and runs properly when I use javac/java version 1.1.6

The java program compiles with the 1.3 version of javac, but when I run it, I
get this:

% java Test
Exception in thread "main" java.lang.UnsatisfiedLinkError: make_c_state
        at oracle.jdbc.oci8.OCIDBAccess.make_c_state(Native Method)
        at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
        at java.sql.DriverManager.getConnection(DriverManager.java:517)
        at java.sql.DriverManager.getConnection(DriverManager.java:177)
        at DB.<init>(DB.java:18)
        at Test.main(Test.java:11)
%

I am pretty sure that $CLASSPATH and $LD_LIBRARY_PATH are correct.

I thought about providing the source code in this post, but I decided not to
since it works properly under JDK 1.1.6.

$ORACLE_HOME/jdbc/lib contains the files:
    classes111b.zip
    nlscharset11.zip

When I switch between JDK 1.1.6 to 1.3, I alter $path, $CLASSPATH, and
$LD_LIBARY_PATH as needed.

I have a feeling that my problem is that Oracle doesn't have a driver for JDK
1.3.   According to http://technet.oracle.com/tech/java/sqlj_jdbc/, these are
the available drivers:

       Download the drivers Solaris
             Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.2.x for Solaris
             Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.1.x for Solaris
             Oracle8i 8.1.6.2.0 JDBC Drivers for use with JDK 1.2.x for Solaris
             Oracle8i 8.1.6.2.0 JDBC Drivers for use with JDK 1.1.x for Solaris
             Oracle 8i (8.1.5) JDBC Drivers for use with JDK 1.1.x for Solaris
             Oracle 8i (8.1.5) JDBC Drivers for use with JDK 1.0.2 for Solaris

There is no mention is JDK 1.3.  Is this because an oracle driver for it doesn't
exist yet?

I apologize if these are simple simon questions, but I've been trying for hours
to find the answer to my problem.

Thanks,
Don

I do remember that THIN driver from classes111.zip
worked ok with jdk1.2.2 but I have no OCI driver
experience. OCI uses some native libraries than can
be more sensitive to jdk version.

Thus, you was in right place to download new drivers...

AlexV

Quote:> I'm fairly new to the world of Java.  I have a problem and I have been
searching
> all day for an answer without luck.  Perhaps someone with more knowledge
can
> help me.

> I have:
>     - Solaris box
>     - JDK 1.1.6
>     - JDK 1.3 installed in another directory
>     - Oracle 8.1.5
>     - DB.java - a class that does the work involved with connecting to a
test
> database
>     - TEST.java - a main program class that uses DB to fetch data from the
test
> database
>     - everything is on the solaris box

> The java program compiles and runs properly when I use javac/java version
1.1.6

> The java program compiles with the 1.3 version of javac, but when I run
it, I
> get this:

> % java Test
> Exception in thread "main" java.lang.UnsatisfiedLinkError: make_c_state
>         at oracle.jdbc.oci8.OCIDBAccess.make_c_state(Native Method)
>         at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)
>         at

Quote:>         at
> oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
>         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
>         at java.sql.DriverManager.getConnection(DriverManager.java:517)
>         at java.sql.DriverManager.getConnection(DriverManager.java:177)
>         at DB.<init>(DB.java:18)
>         at Test.main(Test.java:11)
> %

> I am pretty sure that $CLASSPATH and $LD_LIBRARY_PATH are correct.

> I thought about providing the source code in this post, but I decided not
to
> since it works properly under JDK 1.1.6.

> $ORACLE_HOME/jdbc/lib contains the files:
>     classes111b.zip
>     nlscharset11.zip

> When I switch between JDK 1.1.6 to 1.3, I alter $path, $CLASSPATH, and
> $LD_LIBARY_PATH as needed.

> I have a feeling that my problem is that Oracle doesn't have a driver for
JDK
> 1.3.   According to http://technet.oracle.com/tech/java/sqlj_jdbc/, these
are
> the available drivers:

>        Download the drivers Solaris
>              Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.2.x for
Solaris
>              Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.1.x for
Solaris
>              Oracle8i 8.1.6.2.0 JDBC Drivers for use with JDK 1.2.x for
Solaris
>              Oracle8i 8.1.6.2.0 JDBC Drivers for use with JDK 1.1.x for
Solaris
>              Oracle 8i (8.1.5) JDBC Drivers for use with JDK 1.1.x for
Solaris
>              Oracle 8i (8.1.5) JDBC Drivers for use with JDK 1.0.2 for
Solaris

> There is no mention is JDK 1.3.  Is this because an oracle driver for it
doesn't
> exist yet?

> I apologize if these are simple simon questions, but I've been trying for
hours
> to find the answer to my problem.

> Thanks,
> Don

Why don't you use an Oracle sequence?

Simon

The other columns are simply bound like a prepared statement or hard
coded into the select.

hth,
Heinz

Quote:> > INSERT INTO table (column) VALUES (nvl(max(column) + 1, 1))

> You have to use a select in the insert:
> INSERT INTO table (column, other)
>  SELECT NVL(MAX(column) + 1, 1)), :other (or 'other')
>   FROM table;

I notice that you didn't include 'VALUES' - isn't this required on an
INSERT?

Cheers,
Heinz

Quote:> There are two forms of supplying the values to INSERT:
> - with VALUES like INSERT INTO table (column) VALUES (some_value)
> - with SELECT like I did above; This can also insert more than one row!!

I can't:
INSERT INTO table (column1, column2, column3) SELECT 'value1', 4523.12,
nvl(max(column3) +1, 1) from table

If you don't want to supply the values as constants or if you have to
insert more than one row, simply use a PreparedStatement and insert the
values using setXXX.

By inserting more than one row using the select, I meant using the
result of a query (probably without constants like 'value1' or 4523.12).

hth,
Heinz