Uploading an image into the Oracle DB

[shwetaaggarwal]

I have a form in which the client can browse and select an image file. This files needs to be stored in my oracle db as a clob object. How do i do this in jsp ? Any help please????

[MattCasters]

That's a job for Pentaho Data Integration. We have a sample of exactly that in the samples/transformations folder of the distribution.

[shwetaaggarwal]

First of all thanks for your reply Matt. I downloaded Kettle today and came across one transformation like this General - Load images and store into database table.ktr. I am trying to work on this.
However I do want to know how to integrate this in my web application where I have a jsp file and the images are uploaded from the clients machine

Also I am curious to know that in pentaho connection API, the IConnectionPentaho interface supports prepareAndExecuteQuery method. I was hoping to insert a single image in the DB I can simply use this method instead. I am however unable to do so as it keeps giving me error. Can you help me here?