okay, stored proc...now can't get oci805 working...

From: <afrancis_at_my-dejanews.com>
Date: Tue, 13 Apr 1999 16:59:35 GMT
Message-ID: <7evt5h$8u9$1@nnrp1.dejanews.com>

Dogan,

thanks for the reply, I took your advice (thanks) and NOW, I can't get the darned oci805 driver working. I'm very sure that I'm referencing my LD_LIBRARY_PATH correctly because I do a "setenv LD_LIBRARY_PATH /appl/oracle/product/8.0.5/lib" and I can see the liboci805jdbc.so file in that directory. Yet I get the following runtime error:

Exception in thread "main" java.lang.UnsatisfiedLinkError: no oci805jdbc in

java.library.path  at java.lang.Throwable.fillInStackTrace(Native Method)  at
java.lang.Throwable.<init>(Throwable.java:94)  at
java.lang.Error.<init>(Error.java:50)  at
java.lang.LinkageError.<init>(LinkageError.java:43)  at
java.lang.UnsatisfiedLinkError.<init>(UnsatisfiedLinkError.java:42)  at
java.lang.ClassLoader.loadLibrary(Compiled Code)  at
java.lang.Runtime.loadLibrary0(Runtime.java:471)  at
java.lang.System.loadLibrary(System.java:745)  at
oracle.jdbc.oci7.OCIDBAccess.logon(OCIDBAccess.java:142)  at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:103)  at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:148)	at

java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(DriverManager.java:137) at ProcessOrder.main(Compiled Code)

Any and all help is gratefully accepted. Thanks.

In article <36FBCBD2.5A114ACC_at_gwl.com>,   Dogan Cibiceli <dcib_at_gwl.com> wrote:
> afrancis_at_my-dejanews.com wrote:
>
> > Hi,
> >
> > I've got a java program that selects from an oracle database that has 80
> > million rows and is tuned for speed. It takes me nearly an hour to do my
> > selection of 200,000 rows from an 80 million row database that's been
bit-map
> > indexed for speed.
> >
> > I am using the thin driver because I haven't set up oci.
> > I guess that's my first question:
> >
> > Question 1: Will using oci driver enhance performance? (this is a backend
> > application, runs in batch).
> >
> > Right now I'm doing the select, doing some slight manipulation of the data
> > (ie: concatenating fields, etc...) and then writing a record out to a file.
> >
> > Question 2: Is there any way to "buffer" the result set? I have to do minor
> > data conversion and then print it out in a certain format.
> >
> > Question 3: Are there any "gotchas" as far as performance and doing selects?
> >
> > Any and all input is appreciated.
> > TIA
> > Amy Francis
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> If this is a back end job, why don't you write a stored procedure in PL/SQL
and
> call it and let do the work for you. ?
>
> Dogan
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 13 1999 - 11:59:35 CDT