Re: JDBC Problems

["Dave Wall" <dawall@xxxxxxxxxx>]

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