JDBC Problems

["Maarten Vries, de" <m_devries74@xxxxxxxxxxx>]

I am new to Java on the AS/400
Just received the Visual Age Enterprise edition with a new model 170.

I have a couple of questions if you don't mind. I bougth the book Java and 
the AS/400 from
Daniel Darnell which is very good.

However, some things I don't seem to get working:

For example: the following statements:

import com.ibm.as400.access.*;
import java.sql.*;

public class DisplayAudit {


        public static void main(java.lang.String[] args) throws Exception {




DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());
Connection conn  = 
java.sql.DriverManager.getConnection("jdbc:as400://KITS01");

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from " +
        "kleinr.audit");

while(rs.next())
{
        java.math.BigDecimal custID = rs.getBigDecimal("CDENTL", 0);
        String custName = rs.getString("CDJOB");
        String custStreet = rs.getString("CDUSPF");
        String custCity = rs.getString("CDETYP");

        System.out.println("Customer ID     : " + custID);
        System.out.println("Customer Name   : " + custName);
        System.out.println("Customer Street : " + custStreet);
        System.out.println("Customer City   : " + custCity);
}


conn.close();
}
}
When I save this I get the error:
type mismatch: cannot convert from java.sql.Connection to Connection.

In addition I try to put a try box in front of the connection, use try, 
before the statements I put a { and after the statements I put a }. Then I 
get the error Expecting Catch or Finally.

Can anybody please guide me, I got it working last week but I don't know how 
anymore.

Maarten


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---