|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.