|
midrange.com
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/lang/Exception;)V+66
(JDError.java:480)
com/ibm/as400/access/AS400JDBCConnection.setProperties(Lcom/ibm/as400/access/JDDataSourceURL;Lcom/ibm/as400/access/JDProperties;Lcom/ibm/as400/access/AS400;)V+22
(AS400JDBCConnection.java:2742)
com/ibm/as400/access/AS400JDBCDriver.prepareConnection(Lcom/ibm/as400/access/AS400;Lcom/ibm/as400/access/JDDataSourceURL;Ljava/util/Properties;Lcom/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/Properties;)Ljava/sql/Connection;
+365 (AS400JDBCDriver.java:698)
com/ibm/as400/access/AS400JDBCDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;
+82 (AS400JDBCDriver.java:285)
java/sql/DriverManager.getConnection(Ljava/lang/String;Ljava/util/Properties;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.
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.
