Connection con = DbPool.getConnection();
CallableStatement cstmt = con.prepareCall("{?=call test}");
cstmt.registerOutParameter(1, Types.VARCHAR);
cstmt.execute();
String strValue = cstmt.getString(1);
System.out.println("The return value is:" + strValue);
cstmt.close();
con.close();
CallableStatement cstmt = con.prepareCall("{?=call test}");
cstmt.registerOutParameter(1, Types.VARCHAR);
cstmt.execute();
String strValue = cstmt.getString(1);
System.out.println("The return value is:" + strValue);
cstmt.close();
con.close();