Re: JDBC Error

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

I think that's PentaSafe...

On 3/15/07, Sivakumar Kanagavel <srkas400@xxxxxxxxx> wrote:
> I am trying to learn Java and how to access AS/400 data using JDBC and wrote a 
> small program :
>
>   import java.sql.*;
> public class MyDBRead{
> public static void main (String argv []){
>   try {
>   Class.forName("com.ibm.as400.access.AS400JDBCDriver");
>   String sys = "TESTSYS1";
>   String user = "SIVAKUMARK";
>   String pass = "TEXAS1";
>   Connection con =  DriverManager.getConnection("jdbc:as400://"+sys,user,pass);
>   Statement stm = con.createStatement();
>   ResultSet rs = stm.executeQuery("select FIELD1 from MYFILE");
>   while(rs.next())  {
>     System.out.println(rs.getString(1)); }
>  rs.close();
>  stm.close();
>  con.close();   }
>  catch(Exception e) {
>   e.printStackTrace();  }
>  }      }
>
>   The code compiled without any error. While trying to execute, its throwing 
> following exceptions. Can someone tell what I am missing here?. Thanks for in 
> advance.
>
>   java.sql.SQLException: [PWS9801] Function rejected by user exit program 
> NW0001E in PSCOMMON.
>       java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:85)
>       java/lang/Exception.<init>(Ljava/lang/String;)V+1 (Exception.java:33)
>       java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1
> (SQLException.java:34)
>       com/ibm/as400/access/JDError.throwSQLException(Lcom/ibm/as400/access/AS
> 400JDBCConnection;III)V+0 (JDError.java:388)
>       com/ibm/as400/access/AS400JDBCStatement.commonPrepare(Lcom/ibm/as400/ac
> cess/JDSQLStatement;)Lcom/ibm/as400/access/JDServerRow;+0 (AS400JDBCStatement
> .java:801)
>       com/ibm/as400/access/AS400JDBCStatement.executeQuery(Ljava/lang/String;
> )Ljava/sql/ResultSet;+0 (AS400JDBCStatement.java:1355)
>       MyDBRead.main([Ljava/lang/String;)V+0 (MyDBRead.java:7)
>
>
> ---------------------------------
> Looking for earth-friendly autos?
>  Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
> --
> 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.