Re: JDBC Problems

["Maarten Vries, de" <m_devries74@xxxxxxxxxxx>]

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