|
midrange.com
Yes, perfect.
I tested your notes, I spoke with our AS400 administrator and we saw the
problem!!! It was a DNS configuration problem in our new AS400 system!!!
Nothing related with java environment. Perfect. With your help I have done
step by step that you said in order to finally discover the problem.
It's a perfect Christmas message: working together around the world we can
solve all the problems!!
Happy Christmas and happy new Year colleagues.
It was and will be very nice work with you.
Albert Dalmau.
"Tim Kosacek"
<tkosacek@visioninf To: "'Java Programming
on and around the iSeries / AS400'" <java400-l@midrang
o.com> e.com>
Sent by: cc:
java400-l-bounces@m Subject: RE: JDBC Connection
idrange.com
23/12/2003 13:27
Please respond to
Java Programming on
and around the
iSeries / AS400
It looks like maybe your PC knows how to resolve the name
P1400.eu.roca.net, but your AS400 does not. Is DNS configured on the
AS400? You should be able to test a simple connection with the toolbox
driver using the loopback address to see if it's the host name that is
causing the problem. Try "jdbc:as400://127.0.0.1"
Tim
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
albert_dalmau@xxxxxxxx
Sent: Tuesday, December 23, 2003 6:59 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: JDBC Connection
OK, perfect...
it works with the native driver:
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
Connection connection = DriverManager.getConnection("jdbc:db2:*local");
it works also with the Toolbox driver from VAJava environment (then my
host:, user and password are correct):
Class.forName("com.ibm.as400.access.AS400JDBCDriver");
Connection connection = DriverManager.getConnection
("jdbc:as400://P1400.eu.roca.net","KESTAD","KESTAD");
but it doesn't work with the Toolbox driver working on my AS400 V5R2
system....
Where could be my problem?
(By the way, thanks Ashish, Gary and Bill for your help. It's very
important for me. With the current situation we can start working our
production system.)
The stack trace is:
java.sql.SQLException: The application requester cannot establish the
connection.(localhost)
java/lang/Throwable.<init>(Ljava/lang/String;)V+4
(Throwable.java:94)
java/lang/Exception.<init>(Ljava/lang/String;)V+1
(Exception.java:42)
java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1
(SQLException.java:43)
com/ibm/as400/access/JDError.throwSQLException(Ljava/lang/String;Ljava/l
ang/Exception;)V+66
(JDError.java:480)
com/ibm/as400/access/AS400JDBCConnection.setProperties(Lcom/ibm/as400/ac
cess/JDDataSourceURL;Lcom/ibm/as400/access/JDProperties;Lcom/ibm/as400/a
ccess/AS400;)V+22
(AS400JDBCConnection.java:2742)
com/ibm/as400/access/AS400JDBCDriver.prepareConnection(Lcom/ibm/as400/ac
cess/AS400;Lcom/ibm/as400/access/JDDataSourceURL;Ljava/util/Properties;L
com/ibm/as400/access/JDProperties;)Ljava/sql/Connection;
+56 (AS400JDBCDriver.java:807)
com/ibm/as400/access/AS400JDBCDriver.initializeConnection(Lcom/ibm/as400
/access/JDDataSourceURL;Lcom/ibm/as400/access/JDProperties;Ljava/util/Pr
operties;)Ljava/sql/Connection;
+365 (AS400JDBCDriver.java:698)
com/ibm/as400/access/AS400JDBCDriver.connect(Ljava/lang/String;Ljava/uti
l/Properties;)Ljava/sql/Connection;
+82 (AS400JDBCDriver.java:285)
java/sql/DriverManager.getConnection(Ljava/lang/String;Ljava/util/Proper
ties;Ljava/lang/ClassLoader;)Ljava/sql/Connection;
+135 (DriverManager.java:4
57)
java/sql/DriverManager.getConnection(Ljava/lang/String;Ljava/lang/String
;Ljava/lang/String;)Ljava/sql/Connection;
+37 (DriverManager.java:137)
provesas400/PruebaP1400_JDBC.main([Ljava/lang/String;)V+0
(PruebaP1400_JDBC.java:18)
Thanks.
Albert Dalmau
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
22/12/2003 16:57
Please respond to
Java Programming on
and around the
iSeries / AS400
Hi
please try
Properties prop = new Properties();
prop.put("prompt", "false");
prop.put("naming", "system");
prop.put("date format", "iso");
prop.put("time format", "hms");
prop.put("libraries", liblList);
String sourceURLDB2 = "jdbc:db2:*local";
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
Connection db2conn = DriverManager.getConnection(sourceURLDB2,
prop);
db2conn.setAutoCommit(false);
return db2conn;
this type of code for getting connection using native
driver
--- 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.
>
=====
A$HI$H
__________________________________
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.
_______________________________________________
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.
As an Amazon Associate we earn from qualifying purchases.
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.
