Results 1 to 6 of 6
  1. #1
    tandonpiyush is offline Member
    Join Date
    May 2011
    Posts
    10
    Rep Power
    0

    Default MS word file in Oracle

    How can i keep MS word file in one of the field of Oracle 10g database.

    And i want to access, display the same file trough my jsp servlet application.

    Can any1 help!!

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,120
    Rep Power
    20

    Default

    Store it as a BLOB.
    Use the setBinaryStream() method on a PreparedStatement to send the file stream to the db.
    Use the getBS() to retrieve it and send to the front end (with the correct response header).

  3. #3
    tandonpiyush is offline Member
    Join Date
    May 2011
    Posts
    10
    Rep Power
    0

    Default

    Kindly help me creating one application for uploading and downloading word or pdf files in /from database(oracle)

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,120
    Rep Power
    20

    Default

    I've given you the pointers.
    I'm not going to write it for you.
    If you have a problem when you write your code then ask and we'll try and solve the issue.

  5. #5
    tandonpiyush is offline Member
    Join Date
    May 2011
    Posts
    10
    Rep Power
    0

    Default

    wat will be the query for storing pdf or word file in oracle.I have created the following table:

    Column Name Data Type Nullable Default Primary Key
    DOCNAME VARCHAR2(15) Yes - -
    DOCTYPE VARCHAR2(10) Yes - -
    DOCID VARCHAR2(15) Yes - -
    DOC BLOB Yes - -


    But when i insert any row it shows the following:


    Table: DOCDETAILS
    Docname
    Doctype
    Docid
    Doc not available to insert data

  6. #6
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,120
    Rep Power
    20

    Default

    Show us the code that's trying to insert the data, and also the full exception (plus stacktrace) of the problem you're getting.

Similar Threads

  1. Removing a word from a txt file
    By MiitchKay in forum New To Java
    Replies: 3
    Last Post: 06-02-2011, 04:45 PM
  2. Count same word from many file in directory
    By cassiests in forum New To Java
    Replies: 4
    Last Post: 05-20-2010, 10:21 AM
  3. printin word file
    By pinks_70986 in forum New To Java
    Replies: 2
    Last Post: 07-12-2009, 04:26 PM
  4. How can i save file with greek word?
    By mailbankey in forum Eclipse
    Replies: 0
    Last Post: 04-15-2009, 02:16 PM
  5. Replies: 7
    Last Post: 11-19-2008, 03:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •