wood burning stoves 2.0*
The moose likes JDBC and the fly likes which  is best  solution to store wave and doc file? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "which  is best  solution to store wave and doc file? " Watch "which  is best  solution to store wave and doc file? " New topic
Author

which is best solution to store wave and doc file?

Kaleeswaran Karuppasamy
Ranch Hand

Joined: Jul 19, 2007
Posts: 154
in medical transcription domain we are receiving 300 voice file and further we have to maintain transcript ,editing and super editing file for particular voice file.Right now we storing all the in disc mean we are maintain unique folder structure to store.my question is can we use database to store all file as binary data using jdbc blob data type?.which is the right way please suggest me.


Judge a man by his questions rather than his answers --Voltaire
SCJP 1.5 97%
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

You can use a database. Ultimately this will just store these files on disk too, though in a differernt format. There is an overhead getting BLOBs in and out of a database, but it has the advantage of being a transactional store. The file system is not transactional, so data loss is possible, plus you will have issues with concurrency.

In addition, the file system is not as easy to access from a distributed environment in a platform agnostic way. You can't write to the file system from an EJB for example.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Kaleeswaran Karuppasamy
Ranch Hand

Joined: Jul 19, 2007
Posts: 154
thanks ti sudden reply.

yes. if i use file system i cannot use EJB because we should not perform I/O operation inside EJB.so can use inputstream and outstream object in ejb if i use database to store file?.why i am asking mean if the file may big out of memory exception will occur when using EJB.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: which is best solution to store wave and doc file?
 
Similar Threads
Users / Groups and roles
storing data in xml file
Prototype Design Pattern
Displaying XSL from XML
which is best to sending file to client?