Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to read a text file from a database table

 
parag Chatterjee
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can anybody help me out how to read a text file from a databse table using JDBC .
I need to know
1. what will be the query to extract the file?
2. what will be the jdbc snippet of code
3.
 
parag Chatterjee
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I also need to know how to store the file in local disc
 
Mahesh swami
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
U can use,rs.getObject() or rs.getBinaryStream() and then read from the stream.
 
parag Chatterjee
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot.
I had already used it with rs.getAsciiStream()
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic