I followed the post which you had pointed to, but got the error:
"java.sql.SQLException: Unable to convert between java.io.File and JAVA_OBJECT."

I tried using the same routine given in the post which was how the problem was resolved there,
but my requirement was a bit different ( I do not want to store the whole file in the XML column as is, I only want to store
the XML row/string/ content of the XML)  because of which i wrote this routine and resolved the issue.

public static String getFiletoInsert(String file) {
        try {
            FileReader fileReader = new FileReader(file);
            StringBuffer fileDataBuff = new StringBuffer();
            String fileData = null;
            BufferedReader bufferedReader = new BufferedReader(fileReader);
            int i = 0;
            while ((fileData = bufferedReader.readLine()) != null) {
                if (i != 0) {
                    fileDataBuff.append(fileData);
                }
                i++;

            }
            fileReader.close();
            bufferedReader.close();
            return fileDataBuff.toString();
        } catch (Exception err) {
            err.printStackTrace();
            return null;
        }
    }


The expression used in the tMap was :
ByteArrayFromFile.getFiletoInsert(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")))
for the XML field and the Type of the output column (XML field in the database) was specified as an 'String' and not as an Object in this case.

Thanks for the pointers given to resolve.

Last edited by ranimath (2008-01-31 13:00:09)