1) Using the JDBC-ODBC-driver should always be avoided
due to a lack of performance.
Oracle provides 2 very good drivers:
	* Thin-driver which connect to the DB directly.
	* OCI8-driver which connect to the DB using the
	NET8-connection.
The archive-file is called (classes12.zip of classes11.zip)
which should be somewhere in the directory of you're DB.

2) You can open you're file in Java with one of
java.io-classes and write it using SQL to the
BLOB-field in the database (BLOB =3D Binary Large OBject),
I suggest using the java.sql.PreparedStatement class.
=09
Greetings

Bart Laeremans


-----Original Message-----
From: Naumann Yousuf [mailto:nauman_yousuf@d...]
Sent: woensdag 13 maart 2002 12:36
To: Pro_JavaServer_Pages
Subject: [pro_jsp] Re: Reading/Writing '.pdf' files to a database.


do u wish to connect to the unix oracle server thru a WinOs box? If so,
simply install the client for oracle on your system and configure a 
service
for the unix oracle server. Make sure listener is started at the oracle
server...
----- Original Message -----
From: "Dean Kirby" <dean_kirby@y...>
To: "Pro_JavaServer_Pages" <pro_jsp@p...>
Sent: Wednesday, March 13, 2002 4:22 PM
Subject: [pro_jsp] Reading/Writing '.pdf' files to a database.


> I have been given a task which involves reading and
> writing '.pdf' files to an Oracle database using java.
> The application and database are on a Unix platform.
> It is for timed archiving and deletion. I am fine with
> the PL/SQL part. I am competent with Java, not an
> expert.
>
> I need to know how to:
> 1) Connect to Oracle from Unix, i.e. this implies not
> using ODBC (Windows specific).
> 2) How to read/write a binary file to/from an Oracle
> Database.
>
> I would appreciate any offered guidance that helps me
> resolve my problem.
> I have already searched the web but have found
> nothing.
>
> Thanks in advance,
> Dean
>
>
> __________________________________________________
> Do You Yahoo!?
> Try FREE Yahoo! Mail - the world's greatest free email!
> http://mail.yahoo.com/
>
$subst('Email.Unsub').
>