Result set representing update count of 0

Once the "resultsAvailable " method has been called, the next result if available can be either a ResultSet or an UpdateCount, if the default "enableResultSetsAndUpdateCount " was used. Therefore, you must retrieve all ResultSet s and update counts first, followed by retrieving the OUT type parameters and return values. The method resultsAvailable implicitly calls getMoreResults when it is called more than once. Do not call both methods in your Java code. If you do, there may be skipped data from one of the ResultSets when more than one ResultSet is present.

The methods available and getResultSet cannot be used when mulitple ResultSets are open at the same time. Attempting to open more the one ResultSet at the same time closes the previous ResultSet. Collectives on Stack Overflow. Learn more. Asked 8 years, 6 months ago. Active 8 years, 6 months ago. Viewed 2k times. Driver" ; System. Improve this question. Sajad Sajad 2, 10 10 gold badges 46 46 silver badges 86 86 bronze badges. Are you sure "show tables" is a statement that your JDBC driver understands and returns a resultset for?

Try using execute. It returns boolean true if the querie get executed. I think "use mydb" never returns ResultSet. DaveHowes How sure for it? Add a comment. Active Oldest Votes.

Improve this answer. Mark Rotteveel Mark Rotteveel Click the variables drop down and select "user::accessCount" Let's presume that you will route to a data flow task to load data and to an email if there is no data.

SSIS can seem cumbersome but once you get into it; it really becomes a powerful tool. Hope this helps! July 29, at am No problem, glad it was what you were looking for. June 23, at pm Viewing 5 posts - 1 through 4 of 4 total.