• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
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: 1082
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)
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!