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

ResultSet containing XML from SQL server 2000

 
Drepe Trooper
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying JDBC to work with SQL Server 2000. I have a resultset object from the following statement which outputs an XML string(as clearly seen on the query analyzer).
SELECT TOP 2 id FROM table WHERE (c_id = '32') FOR xml auto
When I use the ResultSet using getString(1), I get a stream of characters(probably encoded bytes). How do I convert this stream to a readable string?
Thanks,
Drepe
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic