Re: JDBC Connection

Hi Ashish,

This simple JDBC connection example is working fine in V4R5 and has an
error on V5R2 (java.sql.SQLException: The application requester cannot
establish the connection.(localhost))

public static void main(String[] parametros) {

      try {
            DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());
            Connection  connection = DriverManager.getConnection
("jdbc:as400://P1400","KESTAD","KESTAD");

            int count = 0;
            Statement read = connection.createStatement();
            ResultSet rs = read.executeQuery("SELECT * FROM
CO1DSASTIL.CE10");
            while (rs.next()) {
                  count++;
            }
            System.out.println(count+" records");

      } catch (Exception e) {
            e.printStackTrace();
      }
      System.exit(0);
}

I'm using /QIBM/ProdData/OS400/jt400/lib/jt400Native.jar and
/QIBM/ProdData/Http/Public/jt400/lib/jt400Access.zip in the classpath. You
said that in V5R2 only jt400Native.jar is needed.


Thanks a lot.

Albert.


                                                                                
                                                         
                      Ashish Kulkarni                                           
                                                         
                      <kulkarni_ash1312@y        To:       Java Programming on 
and around the iSeries / AS400 <java400-l@xxxxxxxxxx      
                      ahoo.com>                   om>                           
                                                         
                      Sent by:                   cc:                            
                                                         
                      java400-l-bounces@m        Subject:  Re: JDBC Connection  
                                                         
                      idrange.com                                               
                                                         
                                                                                
                                                         
                                                                                
                                                         
                      19/12/2003 17:36                                          
                                                         
                      Please respond to                                         
                                                         
                      Java Programming on                                       
                                                         
                      and around the                                            
                                                         
                      iSeries / AS400                                           
                                                         
                                                                                
                                                         




Hi
u only need jt400Native.jar in your classpath,
how do u build your connection string?

Ashish
--- albert_dalmau@xxxxxxxx wrote:
> Hi all,
> we moved our AS400 server from V4R5 to V5R2. Now we
> have a problem with our
> JDBC connections:
>
> java.sql.SQLException: The application requester
> cannot establish the
> connection.(localhost)
>
> We are using this classpath:
>
> /QIBM/ProdData/Http/Public/jt400/lib/jt400.zip
> /QIBM/ProdData/OS400/jt400/lib/jt400Native.jar
>
>
> Any idea?
>
> Thanks for your help in advance.
>
>
> Albert.
>
>
> _______________________________________________
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
>


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.