RE: please critique

["Richard Casey" <casey_r@xxxxxxxxxxxxxxxx>]

Tim,

Both options work, but the first option is probably better. You could
enhance that option by passing the driver name, URL, userid, and password as
parameters to the program or storing them in a Properties file which your
program could load. That way a change to any of those 4 items would not
require changing and recompiling the program.

Hope this helps. Good luck!
Richard

-----Original Message-----
From: java400-l-bounces@midrange.com
[mailto:java400-l-bounces@midrange.com]On Behalf Of Hatzenbeler, Tim
Sent: Thursday, February 13, 2003 1:24 PM
To: 'Java Programming on and around the iSeries / AS400'
Subject: RE: please critique


Thank you for the link...  And after a few paragraphs, I saw something, that
is unclear to me..

Is it better to do 1
1)String sDriver = "COM.cloudscape.core.RmiJdbcDriver";
    String sURL = "jdbc:cloudscape:rmi:jGuru;create=true";
    String sUsername = "sa";
    String sPassword = "admin";

    try   // Attempt to load the JDBC driver
    {     // with newInstance
        Class.forName( sDriver ).newInstance();
    }

or a
2)                      DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());
                        con = DriverManager.getConnection
("jdbc:as400://"+system,"username","password");

Whats better?  Class.forName  or  registerDriver?  Or are they the same? Why
would I pick one over the other?

Thanks again,
tim