Dear Members,
I want to know how to insert text file in sql server database field (having text data type) using java and jdbc technology. i want to store it by java program. As i want to do full text indexing on that field.
plz help me. Waiting for reply!!!!!!!!!!



Regards
sharvari

Hi,
You can use PreparedStatement for this and let the database driver handle the conversion. For example you've two columns in your table like

table name is myTable and two columns are
 myId integer
 myText text datatype

[code]
String sql = "INSERT INTO MYTABLE VALUES(?,?)";
String text = "some text";
PreparedStatement st = connection.prepareStatement(sql);
st.setInt(1, 12345);
st.setObject(2,text);
st.executeUpdate();
[code]

Hope it solves your problem.

Regards,
Rakesh

Hi,
thanks for reply. But i need to read .doc file & insert it into database. I m trying with BLOB & CLOB. Yet not completed.
bye!

hi,

Have a look at the following links, might be helpful to you

http://www.samspublishing.com/articl...p?p=26251&rl=1
http://publib.boulder.ibm.com/infoce...c/rjvjdata.htm
http://www.datadirect.com/developer/...sics/index.ssp

Regards,
Rakesh