skip to main |

skip to sidebar



How To Test for an Empty Database Table in RFT



0

comments

at

5:09 PM

I used this script to test if a table in the database is empty or not. I am using IBM RFT boolean found; ResultSet result;try{ Connection db_connection = DriverManager.getConnection("jdbc:odbc:DBNAME","USERNAME","PWD");Statement stm2 = db_connection.createStatement(); result=stm2.executeQuery("your query");found = result.next(); if (!(found))logTestResult("Test Failed",false);else logTestResult("Test Passed",true); } catch( SQLException x ){logError(x.getLocalizedMessage().toString()); }Reference: http://www.rgagnon.com/javadetails/java-0116.html



&;



&;