| Configuring Oracle OCI JDBC driver [message #88162] |
Fri, 22 August 2003 06:50  |
Eclipse User |
|
|
|
Originally posted by: joonas.reynders.merideasoftware.com
Hi
Has anyone succeeded in configuring the JDT to work with Oracle 9 OCI JDBC
driver? If I just try using the oci library with jdbc I get an error stating
that the ocijdbc9.dll is not in java.library.path, if I add the directory
(oracle_home/bin) in the run-time workbench settings I get this:
Failed to execute runnable (java.lang.UnsatisfiedLinkError:
C:\oracle\ora9\bin\ocijdbc9.dll: Can't find dependent libraries)
All help is appreciated,
Joonas
|
|
|
|
|
|
|
|
| Re: Configuring Oracle OCI JDBC driver [message #88716 is a reply to message #88528] |
Sun, 24 August 2003 03:49  |
| Eclipse User |
|
|
|
Originally posted by: joonas.reynders.merideasoftware.com
From the Oracle 9.2.0 JDBC readme.txt
What Is New In This Release Since 9.0.2 ?
-----------------------------------------
Direct support for LOBs in the Thin driver.
The Thin driver now provides direct support for BFILEs, BLOBs, and
CLOBs. Prior to this release it supported them via calls to PL/SQL
routines.
but:
* There is a limitation regarding the use of stream input for LOB
types. Stream input for LOB types can only be used for 8.1.7 or
later JDBC OCI driver connecting to an 8.1.7 or later Oracle
server. The use of stream input for LOB types in all other
configurations may result in data corruption. PreparedStatement
stream input APIs include: setBinaryStream(), setAsciiStream(),
setUnicodeStream(), setCharacterStream() and setObject().
To best of my understanding this means that if I use binary streams with
LOBs (I do), I must use OCI drivers
Joonas
"snpe" <snpe@snpe.co.yu> wrote in message news:bi7jvs$3gm$1@eclipse.org...
> It isn't true for jdbc driver >= 9.0.2 (ojdbc14.jar)
>
> regards
> Haris Peco
> Igor Fedorenko wrote:
>
> > You need OCI driver to access BLOB/CLOB.
> >
> > snpe wrote:
> >
> >> Performance reason is first and only for oci driver
> >>
> >> regards
> >> Haris Peco
> >> Jeff Duska wrote:
> >>
> >>
> >>>Joonas, is there a reason you don't want to use the type 4 drivers?
I've
> >>>found that the Oracle JDBC Thin drivers work exceptionally well. These
> >>>would elminate you need to setup any Oracle client libraries on
> >>>development system. The only two reasons that I know of not using Thin
> >>>Driver is that you must use something other than TCP/IP for you network
> >>>layer or you are supporting an Oracle database earlier than 7.2.
> >>>
> >>>Regards,
> >>>
> >>>Jeff Duska
> >>>
> >>>Joonas Reynders wrote:
> >>>
> >>>
> >>>>Hi
> >>>>
> >>>>Has anyone succeeded in configuring the JDT to work with Oracle 9 OCI
> >>>>JDBC driver? If I just try using the oci library with jdbc I get an
> >>>>error stating that the ocijdbc9.dll is not in java.library.path, if I
> >>>>add the directory (oracle_home/bin) in the run-time workbench settings
I
> >>>>get this:
> >>>>
> >>>>Failed to execute runnable (java.lang.UnsatisfiedLinkError:
> >>>>C:\oracle\ora9\bin\ocijdbc9.dll: Can't find dependent libraries)
> >>>>
> >>>>All help is appreciated,
> >>>>
> >>>>Joonas
> >>
> >>
>
|
|
|
Powered by
FUDForum. Page generated in 0.04727 seconds
Home