|
Indeed, the error I am getting is at compile time. Your statement seems to work fine altough I have to make same changes to the rest of the program. It is strange, because I followed the book. Even when Dave is able to compile it. Message for Dave, the longshots did not work either. Can you tell me why I have to put (Connection) in front of the java.sql.DriverManager.getConnection? Maarten (I am still a newbie and Dutch to, so sorry if the language is not totally ok) >From: Nick.Vrtis@alticor.com >Reply-To: JAVA400-L@midrange.com >To: JAVA400-L@midrange.com >Subject: Re: JDBC Problems >Date: Tue, 30 Jan 2001 14:43:32 -0500 > > >Duh!... as he hits himself for not reading...Try > > conn = (Connection) java.sql.DriverManager.getConnection >("jdbc:as400://KITS01"); > >and do the cast explicitly. You are getting a compiler error correct? Not >a run time exception? > >Nick > > > > >"Maarten Vries, de" <m_devries74@hotmail.com>@midrange.com on 01/30/2001 >01:30:48 PM > >Please respond to JAVA400-L@midrange.com > >Sent by: owner-java400-l@midrange.com > > >To: JAVA400-L@midrange.com >cc: > >Subject: 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 >+--- > > > >+--- >| 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 +---
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.