RE: JDBC Problems

[Lee Bircham <lee.bircham@xxxxxxxx>]

Title: RE: JDBC Problems

Embedding your Main method code in a try/catch block should remove your catch/finally error.

        try {

        // Your java code
        
        }

        catch (Exception e) {
                System.out.println("Error : " + e);            
        }

Regards,
Lee Bircham.

-----Original Message-----
From: Maarten Vries, de [mailto:m_devries74@hotmail.com]
Sent: Tuesday, January 30, 2001 10:57 AM
To: JAVA400-L@midrange.com
Subject: JDBC Problems

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
+---

This E-Mail and any attachments maybe confidential and be the subject of legal professional privilege.
Any disclosure , use, storage or copying of this E-Mail without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended recipient and then delete the E-Mail from
your inbox and do not disclose the contents to another person ,use, copy or store the information in any medium.