× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.