This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Working with Oracle BFiles... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Working with Oracle BFiles..." Watch "Working with Oracle BFiles..." New topic
Author

Working with Oracle BFiles...

Franck Tranchant
Ranch Hand

Joined: Aug 07, 2003
Posts: 75
Hi,
Did someone here already tried to develop something based on Oracle's BFILE (used to store a locator to a file outside the database, stored somewhere on the filesystem of the data server) ?
I found some basic infos on Advanced JDBC Samples @ Technet.oracle.com but all samples seem to use that kind of query :
INSERT INTO BFILE_TABLE VALUES (BFILENAME('BFILEDIR', 'myFile.gif'))
In this case, myFile.gif need to reside in the server in which database is running
So, I wonder if it's possible to manipulate Streams instead of files stored on the Database server...
Basically, I would like allow a user to upload a file from his Internet Explorer to the Database.
Do you think the 3 following steps are required ?
1- Upload from Client side to Server Side (WebLogic)
2- Upload from Server Side to Database Side (Oracle)
3- Execute the Insert query
Any info is welcome


Franck<p>--------------------
 
GeeCON Prague 2014
 
subject: Working with Oracle BFiles...