Re: JDBC Problems

Duncan

When I do the try (as in this email)
I get the same error: cannot convert from java.sql.Connection to Connection.
I use Visual Age for Java 1.1

Maarten


>From: Duncan_Folkes@cuk.canon.co.uk
>Reply-To: JAVA400-L@midrange.com
>To: JAVA400-L@midrange.com
>Subject: Re: JDBC Problems
>Date: Tue, 30 Jan 2001 13:38:48 +0000
>
>
>
>Maarten,
>
>A try statement must be accompanied by at least one catch block or
>one finally block.
>
>try (pardon the pun!)
>
>import com.ibm.as400.access.*;
>import java.sql.*;
>
>public class DisplayAudit {
>
>
>public static void main(java.lang.String[] args) {
>
>try {
>
>
>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();
>rs.close();
>}
>catch (Exception e) {
>System.out.println("Exception: " + e);
>e.printStackTrace();
>}
>}
>}
>
>
>Duncan
>
>
>Dr Duncan E. Folkes
>
>
>+---
>| 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
>+---

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