Tuesday, February 21, 2017

No results in set for executeQuery() in Oracle

Issue:
executeQuery() returns no rows. Oracle SQL developer shows the rows persist into database.

Cause / error / solution:
I was not commited the transaction in Oracle SQL developer. The SELECT statement there shows data uncommitted, while Java does not see uncommitted rows.

No comments:

Post a Comment