|
midrange.com
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/
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.
