Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Urgent: Setting values for the bind parameters of a RowSet query

 
raj agastya
Greenhorn
Posts: 22
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am using JDBC rowset to display values from an Oracle database. I am using the setter methods to set username, password, port, sid, host, query. Now that my query has some input parameters, I tried using rowset.getXXX methods to pass values for the bind parameters. I get NullPointerException while doing setXXX.
How do I set values for the bind parameters for a rowset or how do I create a query having bind parameters and pass values for them using rowset?
BTW, I know doing this using normal the PreparedStatement and populating the rowset with the resultset. But is it not possible to do it directly i.e using only the rowset object?
Please help. Below is the code I used:

Thanks
-raj
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic