Re: Java Stored Procedures

Regards.


Scott Jordan wrote:

Java *VERSION returns Version JVM V5R1M0 JDK 1.4.2.

Yes, I verified in LICPGM that 5722JV1 optino 4 is no longer installed.

Whether I call it via JDBC from another machine or JDBC using *LOCALHOST, I get the same results. Here is the source:

CREATE PROCEDURE SSLIB.TEST(INOUT prm1 VARCHAR(4096)) LANGUAGE JAVA

                 PARAMETER STYLE JAVA
                 NOT FENCED
                 EXTERNAL NAME 'ssi.SSIAPI.test';
package ssi;

public class SSIAPI {

public static void test(String[] result) throws Exception {

                                 StringBuffer b = new StringBuffer();
 b.append(System.getProperty("java.version")).append('\n');
 b.append(System.getProperty("java.class.path")).append('\n');
                                 result[0] = new String(b);
                 }

public static void main(String[] args) {

                                 String[] sa = new String[] {"aaa"};
                                 try {
                                                 test(sa);
                                 }
                                 catch (Exception ex) {
                                                 ex.printStackTrace();
                                 }
                                 System.out.println(sa[0]);

} }

package ssi;

import java.sql.CallableStatement;
import java.sql.DriverManager;
import java.sql.Types;
import com.ibm.as400.access.AS400JDBCConnection;
import com.ibm.as400.access.AS400JDBCDriver;

public class Test {

public static void main(String[] args) {

                                 test1();
                 }

public static void test1() { System.out.println("Hello Scott. Here is the same program with debug"); System.out.println("Entering function. Here I print version of JVM this program runs");

 System.out.println(System.getProperty("java.version"));
                                 AS400JDBCConnection connection = null;
                                 try {
                                                 new AS400JDBCDriver();

System.out.print("Now connectiong to local host over JDBC... "); connection = (AS400JDBCConnection)DriverManager.getConnection("jdbc:as400://localhost");

 System.out.println("Connected");

System.out.print("Now preparing to call SSLIB.TEST... "); CallableStatement stmt = connection.prepareCall( "call SSLIB.TEST(?)"

                                                 );
 stmt.registerOutParameter(1, Types.CHAR);
                                                 stmt.setString(1, "aaa");
 System.out.println("Prepared");

System.out.print("Now executing SSLIB.TEST... " + "It'll make host server to create another JVM to execute ssiSSIAPI... ");

                                                 stmt.execute();
 System.out.println("Done");

System.out.println("Here is the version of second JVM");

 System.out.println(stmt.getString(1));

System.out.print("Now closing all resources... ");

                                                 stmt.close();
 System.out.println("Done");
                                 }
                                 catch (Exception e) {
                                                 e.printStackTrace();
                                 }
                                 finally {

if (connection != null) try {connection.close();} catch (Exception ex) {}

                                                 System.exit(0);
                                 }
                 }

}

Thanks!

Scott

Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx> Sent by: java400-l-bounces@xxxxxxxxxxxx

08/03/2006 07:53 AM
Please respond to

Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx>

To

Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx>

cc

Subject
Re: Java Stored Procedures






What  does “java *version” return? (or “java -version” in qshell).

You removed JDK 1.2. Can you verify it using “GO LICPGM” option 10?

What is “remotely called stored procedure”? is the code running remotely on another box?

Thanks.

Scott Jordan wrote:

Sorry!

I didn't mean to be so terse. I'm using the following to retrieve the

JDK

version:
System.out.println(System.getProperty("java.version"));

Thanks for any help!

Scott

Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx> Sent by: java400-l-bounces@xxxxxxxxxxxx

08/02/2006 09:50 AM
Please respond to

Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx>

To

Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx>

cc

Subject
Re: Java Stored Procedures

How do you know you are getting JDK 1.2 from a remotely called stored Procedure?

Scott Jordan wrote:

Hello!

We are writing Java Stored Procedures on V5R1. Our Java.Version always

returns 1.2. However, when we run the same procedure interactively, we

get JDK 1.4. We've tried messing with the SystemDefault.properties

both

for the system and in the user's directory, as well as QUSER, and even QSYS!

We removed JDK 1.2. We still get JDK 1.2 from a remotely called stored

procedure.

Has anyone else experienced this?

Thanks!

Scott