This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

I have the same problem, did you happen to find the answer ?

Posted by David C. Simmons on September 19, 2000 at 4:03 PM

> Good morning,
> I have a problem with Java and AS/400, i have made a program and i try to connect to my DataBase in AS/400 with Java baut i can't i have a program :
> import java.awt.*;
> import javax.swing.*;
> import java.lang.Object.*;
> import java.net.URLConnection.*;
> import java.net.URL.*;
> import java.net.*;
> import java.sql.*;

> // seconnecter.Java

>
> public class seconnecter
> {
> public static void main(String[] arguments)
> {

> try
> {
>
> Class.forName("com.ibm.as400.access.AS400JDBCDriver");
> System.out.println("La classe est charg�e");
> Connection conn = DriverManager.getConnection("jdbc:as400:HGPFICH/EDIREG");
> System.out.println("La connection est �tablie");
> Statement st = conn.createStatement();
> ResultSet rec = st.executeQuery(
> "SELECT CDMMEX, CDEP "+
> "FROM PORTED.ffd "+
> "WHERE " +
> "ORDER BY NAME ");
> while (rec.next())
> {
> System.out.println(rec.getString("CDEP") + "\n"
> + rec.getString("CDMMEX") +"\n");
> }
> st.close();
> }catch(Exception e)
> {
> System.out.println("Impossible d'�tablir la connexion" + e.toString());
> }
> }
> }

> I don't want to use JDBC-ODBC bridge, juste JDBC or if there are another methode like to access directly with SQL.

> and when i execute this program i have an error message :
> O:\mes documents\hicham\jdk1.2.2\bin\java.exe seconnecter

> Working Directory - O:\Mes documents\Hicham\Programmes\

> Class Path - D:\InterBase Corp\InterClient\interclient.jar;D:\Jars\jt400.jar;.;o:\mes documents\hicham\kawainstall\kawaclasses.zip;

> o:\mes documents\hicham\jdk1.2.2\lib\tools.jar;o:\mes documents\hicham\jdk1.2.2\jre\lib\rt.jar;

> o:\mes documents\hicham\jdk1.2.2\jre\lib\i18n.jar;D:\Jars;O:\Mes documents\Hicham\Toolbox

> La classe est charg�e

> Impossible d'�tablir la connexionjava.sql.SQLException: The application requester cannot establish the connection.

> Please if you have any idea i would like to send it to me.

> and i know if there are a methode without using access JDBC-ODBC bridge and JDBC to access a database

> Thanks.