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  = 

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

        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);

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 


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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.