|
For what it is worth, I cut the code to a file and compiled it with javac on my Windows PC. It compiled with the javac that comes with both jdk 1.1.8 and jdk 1.3. Other appends have correctly pointed out better ways to write the code, but syntactly the code is correct. I agree that it may be something with VAJava. One thing to try (a real long shot) is removing the "java.sql" before DriverManager. You import java.sql.* so you don't need to qualify DriverManager. Maybe you are confusing the compiler by qualifying it. Another thing to try (another long shot) is don't import com.ibm.as400.access.*. If you use ONLY JDBC there are many cases where you don't need to import the Toolbox classes because the driver manager automatically find them. Maybe VAJava finds the Toolbox Connection object before it finds java.sql's, and is getting confused. David Wall AS/400 Toolbox for Java "Maarten Vries, de" <m_devries74@hotmail.com>@midrange.com on 01/30/2001 12:36:44 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 Joe This gives me the same error. Is perhaps something wrong with my visual age? Maarte >From: Joe Teff <joeteff@earthlink.net> >Reply-To: JAVA400-L@midrange.com >To: JAVA400-L@midrange.com >Subject: Re: JDBC Problems >Date: Tue, 30 Jan 2001 11:18:20 -0500 (EST) > >By enclosing all of your logic in a single try-catch block, any error will >cause the catch to be called. This may leave the connection to the >database. You should include a finally to remedy that. > > >import com.ibm.as400.access.*; >import java.sql.*; > >public class DisplayAudit { > public static void main(java.lang.String[] args) { > Connection conn = null; > try { > Class.forName("com.ibm.as400.access.AS400JDBCDriver"); > conn = 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); > } > rs.close(); > } > catch (Exception e) { > System.out.println("Exception: " + e); > e.printStackTrace(); > } > finally { > if (conn != null) { > conn.close(); > } > } > } >} > > >Joe Teff > > > >+--- >| 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 +---
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.