public class test { public static void main(Stringagrs[]){ String url ="jdbc:jdbcprogress:T:hostname:port:dbname"; String userid ="XXXXX"; String passwd ="XXXX"; // Load thedriver try{ System.out.println(Class.forName("com.progress.sql.jdbc.JdbcProgressDriver").newInstance()); Driver d = DriverManager.getDriver(url); System.out.println(d.acceptsURL(url)); // Attempt to connectto a driver. Eachone // of the registereddrivers will be loadeduntil // one is found thatcan process thisURL. java.util.Propertiesprop = new java.util.Properties(); prop.put("user",userid); prop.put("password",passwd); Connection con = DriverManager.getConnection (url,prop); System.out.println(con); Statementstmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="SELECT Count(ad_addr)ad_count FROM PUB.ad_mstr"; ResultSet rs=stmt.executeQuery(sql); rs.next(); System.out.println(rs.getInt(1)); }catch(Exception e){ e.printStackTrace(); } }