Updatin blob column in a table with file on my disk

[navi kumar]

Hi all,

Could someone help me!

I have a file called "FILE.txt" on my disk at c:/dir/FILE.txt

Now I want to upload this file into the following table.

Table NAME : ATTACHMENTS_TABLE

FILE_NAME varchar2(30)
FILE_CONTENT BLOB
ATTACHED_DT DATE

Can some one suggest how to get that file on my disk into the input Stream?

THanks for you help

[Dan Howard]

You could read the whole file into a string and then simply assign the string:

private static String readFileAsString(String filePath)
    throws java.io.IOException{
        StringBuffer fileData = new StringBuffer(1000);
        BufferedReader reader = new BufferedReader(
                new FileReader(filePath));
        char[] buf = new char[1024];
        int numRead=0;
        while((numRead=reader.read(buf)) != -1){
            String readData = String.valueOf(buf, 0, numRead);
            fileData.append(readData);
            buf = new char[1024];
        }
        reader.close();
        return fileData.toString();
    }

[navi kumar]

Dan, thanks for you reply

Can I give something like this:

String filePath = C:/dir/file.txt;

Regards,