• Post Reply Bookmark Topic Watch Topic
  • New Topic

how to write BLOB type of data from java application into an oracle table  RSS feed

 
Aparna Yadav
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to write a java application which will store BLOB type of data into an oracle table & same way retrieve it from table.
 
Shailesh Chandra
Ranch Hand
Posts: 1084
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
use PreparedStatement !!! you can set your blob data using
PreparedStatement.setBlob(int i, Blob x)

and you can retrieve your blob from resultset using
resultset.getBlob(String colName)
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!