JDBC连接Progress

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

}