Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Working with Oracle BFiles...

 
Franck Tranchant
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic