RE: RUNJVA problems

No worries about code man, nothing to laugh at there. I've seen far
worse in as few lines from people who claimed to have years of
experience.

Try this url: "jdbc:as400://192.168.1.50;libraries=TSTMIS"

And you don't need to call newInstance(). Just try
Class.forName(driver);


Dan Feather
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Smith, Mike
Sent: Wednesday, February 14, 2007 2:54 PM
To: Java Programming on and around the iSeries / AS400
Subject: RE: RUNJVA problems

Thanks for input John.  
I've been through most of what you have listed, still a couple things to
check, but I thought for the sake of it, I would go ahead and post my
code.  Don't laugh at the code, as I'm really just getting my feet wet
with java. 
package lockBox;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class ConnectDB2 {
        
        public static Connection connect()
        {
                Connection connection=null;
                String driver = "com.ibm.as400.access.AS400JDBCDriver";
                String url = "jdbc:as400:192.168.1.50;libraries=TSTMIS";
                
                try 
                { // load the driver 
                  Class.forName(driver).newInstance();
                        
                }
                catch( Exception e ) 
                { // problem loading driver, class not exist?
                  e.printStackTrace();
                  
                }
                try 
                {
                  connection = DriverManager.getConnection(url,
"remotecmd", "remote123");
                  System.out.println("Connection to ISERIES
successful!");
                  
                }
                catch( SQLException e ) 
                {
                  e.printStackTrace();
                }
                return connection;
        }

}



*************************************************
package lockBox;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.io.*;

public class UploadLockBox {
        //public FaciltyAccessGetFiles() {
        //      super();
        //}

        public static Connection condb = null;

        public static Statement stmtdb = null;

        public static void main(String[] args) {
                //              
                try {

                        condb = ConnectDB2.connect();
                        try {

                                BufferedReader in = new
BufferedReader(new FileReader(
        
"\\\\rgc-ad\\Public\\customer service\\lockbox\\lockbox payment
datafiles\\020707P.txt"));

                                String str;
                                while ((str = in.readLine()) != null) {
                                        names(str);
                                }
                                in.close();
                        } catch (IOException e) {
                        }

                } catch (Exception e) {
                        e.printStackTrace();
                        System.out.println(e.getLocalizedMessage());
                        System.out.println("SQL Exception");

                }

                finally {
                        if (condb != null) {
                                try {
                                        condb.close();
                                } catch (SQLException e) {
                                        e.printStackTrace();
                                }
                                System.exit(0);
                        }
                }

        }

        /*********************************************************
         * 
         *
         ********************************************************/
        public static void names(String str) {//B1
                //      the Statement object is what sends your SQL
statement to the DBMS
                // Read the Names file and populate USRMAPINI

                try {
                        stmtdb = condb.createStatement();
                        //if (!(str.equalsIgnoreCase("")))      
                        //{
                        String query2 = "INSERT into tstmis.PFRPMFLAT "
+ "VALUES (" + "'" + str
                                        + "'" + ")";

                        stmtdb.execute(query2);
                        //}

                }//B1 
                catch (SQLException f) {
                        System.out.println("Invalid PFRPMFLAT
statement");
                }

                //more = false;
        }
        /****************************************/

}

Michael Smith
iSeries.mySeries.


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Herbert, John M
Sent: Wednesday, February 14, 2007 3:36 PM
To: java400-l@xxxxxxxxxxxx
Subject: RE: RUNJVA problems


Hi Mike,

Thought I would put my 2 cents worth in.  Below I have included an
example of the Java command running on our iSeries, V5R3, Java 1.4.  It
may give some clues as to where you are going wrong.... (RUNJVA is set
up similarly):


JAVA CLASS('com.xxxx.pdfgen.SplfMonitor')
CLASSPATH('/com/xxxx/as400splf2pdf/as4
00splf2pdf.jar:COM/xxxx/as400splf2pdf/XXXX_COMMON.JAR:/COM/xxxx/as400spl
f2pdf/LO
G4J-1.2.8.JAR:/COM/xxxx/as400splf2pdf/MSBBarCode.jar:/QIBM/ProdData/OS40
0/jt400/
lib/jt400native.jar:/com/StyleReportPro/xtools.jar:/com/StyleReportPro/x
report_p
ro.jar:/com/StyleReportPro/design_pro.jar') OPTIMIZE(40)
PROP((java.version 1.4)  (java.awt.headless true)) OPTION(*VERBOSE)
JOB(*GEN)

Points to note:
(1) In this case I am using the Native jt400native.jar.  I am not
suggesting going this way, but it is an alternative.
(2) I checked my IFS and our jt400.jar resides in this location:
/com/ProdData/HTTP/Public/jt400/lib/jt400.jar.  This version does have
AS400JDBCDriver.class included.  You may want to verify that in your
version.
(3) Note that the Class of your program called needs to have the fully
qualified name of the package to the Class being called.
(4) Note that any supporting jars need to be included in the classpath,
not just the folder that the jar resides.  
(5) I recommend option(*verbose) while working out this issue.  It will
show you in the associated QPRINT every class that is being loaded, and
from where.
(6) You may want to verify with your admin that Java 1.4 is loaded on
the AS400.  I think it normally is with V5R3, but it may be an option
that needs to be added.  This can be checked with GO LICPGM, option 10.
You should see: 5722JV1   *COMPATIBLE  Java Developer Kit 1.4 
(7) Verify that the jt400.jar that you are picking up is the only one in
your classpath, and that the version being used has the AS400JDBCDriver
included. 
(8) Note: Running HelloWorld does not test jt400.jar capability as it
has no database connectivity. 
(9) Finally, you may want to verify with your admin that no particular
access restrictions have been placed on the jt400.jar file i.e. you
should have read access.  If you have sufficient privilage, you can
check this with the WRKLNK command (just navigate to the jt400.jar and
use option 9 to work with authority).  You should have *PUBLIC *RX for
each level to the jt400.jar and on the jar.

Failing all that, then we will need to see how your program loads
AS400JDBCDriver.  Perhaps it is using an explicit path or something like
that.

Regards
John                         


date: Wed, 14 Feb 2007 10:49:25 -0500
from: "Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>
subject: RE: RUNJVA problems

Don't take this the wrong way, but I feel better that you and Pete are
stumped on this.  

Any way I have tried your last 2 suggestions with the same results.  

I appreciate all the help, because  I just don't have a clue whats going
on.

Michael Smith
iSeries.mySeries.