Re: JDBC Connection

[Bill Brosch <bbrosch@xxxxxxxxxxxxxx>]

Albert,

Is P1400 defined on the V5R2 machine?  Can you ping that address from the V5R2 
command line?


albert_dalmau@xxxxxxxx wrote:

> 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.
>
>
>
>
> _______________________________________________
> 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.

--
Bill Brosch
Swift Technologies
email:  bbrosch@xxxxxxxxxxxxxx
Voice:  (847) 289-8339
Fax:    (847) 289-8939