updated code to use standard jdbc code in test class