How To Test For Empty ResultSet In Java

In theory, we set a String variable populated with “before” indicating that “results” have not been populated with .executeQuery yet. Set a watch on the String variable. Set a breakpoint so you can see the variable populate with your “before” text. Set a breakpoint on the first line of the setters code so you can … Read more

FIX: Oracle SQL Developer timeout when connected to Azure

When using Oracle SQL Developer to connect to an Oracle database housed on a VM in Microsoft Azure, Developer will “timeout” after approx. 2 – 3 minutes due to Azure closing unused connections. Using this configuration, Oracle SQL Developer will hold the connection open indefinitely. Download and unzip the Oracle InstantClient: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Put the unzipped … Read more