• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Multiple Resultsets?

 
kiran mahavir
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello javaranch,
It is given in the API that Statement.execute() method returns multiple results and you navigate to the next resultset by getMoreResults().Would you please let me know under what circumstances does Statement.execute() returns multiple resultsets.
Thanx in advance
kiran
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Presumably if the statement you have executed contains multiple "SELECT"s, for example:
"SELECT * from dual; SELECT * from dual"
or if you have autocommit turned off, and specify two or more queries before committing etc.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic