• Post Reply Bookmark Topic Watch Topic
  • New Topic

ExecuteQuery Error

 
Lalit Vora
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi when i run following code

String N= "abc";
ResultSet rset2 = stmt.executeQuery("select price from stock where symbol='"+N+"'");
System.out.println("value is "+rset2);

i get error oracle.jdbc.driver.OracleResultSetImpl@2c84d9

But query works for simple statement select * from stocks;
Any idea please guide me.
Thanks
Lalit
 
Paul Clapham
Sheriff
Posts: 21987
36
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That isn't an error. That is simply the value returned by the toString() method of the ResultSet you created. It doesn't mean anything, true, but then it doesn't mean anything to print a ResultSet anyway. Normally the next part of your code would read through the ResultSet and extract the data from it.
 
Lalit Vora
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Paul,

Can explain in more simpler way i am not getting it. How will i get my actual value from resultset like i should get price as 26.97 instead this value. How to display then original value so that i can display it in report?

Please guide me

Thanks
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!