JDBC连接Progress

经过努力终于成功用JDBC连接progress了，注意两点：
一、在CLASSPATH中一定要加入 D:\PROGRESS\java\jdbc.jar;D:\PROGRESS\java\progress.jar;

例如我的CLASSPATH=.;D:\ProgramFiles\StormII\Codec\QTSystem\QTJava.zip;D:\PROGRESS\jdk\src.jar;D:\PROGRESS\java\jdbc.jar;D:\PROGRESS\java\progress.jar;C:\ProgramFiles\Java\jre6\lib\rt.jar

二、在path 中一定要加入progress的安装目录\bin.

例如我的path=%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;D:\ProgramFiles\StormII\Codec\QTSystem\;D:\ProgramFiles\UltraEdit-32;C:\Program Files\CommonFiles\Thunder Network\KanKan\Codecs;D:\PROGRESS\bin

由于JDBC连接的时候要用到D:\PROGRESS\bin\JdbcProgress.dll文件。

以下为测试代码：

import java.sql.*;

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 FROMPUB.ad_mstr";
ResultSet rs=stmt.executeQuery(sql);
rs.next();
System.out.println(rs.getInt(1));
}catch(Exception e){
e.printStackTrace();
}
}

}