cannot connect to db2 v8 trial version with jdbc

[Kelvin Mak]

I am using DB2 V8.1 trial version, and try to connect with JDBC. My code as following.

    try {
        Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
        String url = "jdbc :mrgreen: b2://localhost:50000/test";
        String user = "db2admin";
        String pwd = "system";
        Connection conn = DriverManager.getConnection(url,user,pwd);
        Statement stmt = conn.createStatement();
        String sqlStr = "select * from users";
        ResultSet rs = stmt.executeQuery(sqlStr);
        while(rs.next()) {
            out.println(rs.getString("username"));
        }
    }
    catch (Exception e) {
        out.print(e.getMessage() );
    }

It always complain "No suitable driver", I check my reference about the driver string, it is ok. Is it any limit in the db2 trail vesion? Any one meet this situation? Why it cannot use the jdbc driver? thx in advance.

[Michael Zalewski]

Doesn't look like you are registering the driver. Only loading the class. Try

  try {
    Class db2Driver = Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
    DriverManager.registerDriver( (Driver) db2Driver.newInstance() );
     
    ...