Hi
I am accesing AS400 data from Java on Windows using Java Tool box for IBM.
I have an RPG program on AS400. My java program will call this RPG program to perform some database operations. I am making connection from Java to AS400 sysem.
This question is about maintaitaining connections and jobs on AS400. If I call the RPG program similataniously 200 times it is going to make 200 connections (?).
Following are my questions
1. How to efficiently manage the number of connections to AS400 system and maintain performance?
2.If I use global static variable in Java for AS400 connection and call many RPG programs in different parts of my java program will I have only one connection or still will it make lot of connections?
3. To acces AS400 database from Java which is the best ? [Considering connetion pooling, performance etc]
a. Calling RPG program from Java
b. Calling Stored Procedure on AS400 using JDBC
Neena
I am accesing AS400 data from Java on Windows using Java Tool box for IBM.
I have an RPG program on AS400. My java program will call this RPG program to perform some database operations. I am making connection from Java to AS400 sysem.
This question is about maintaitaining connections and jobs on AS400. If I call the RPG program similataniously 200 times it is going to make 200 connections (?).
Following are my questions
1. How to efficiently manage the number of connections to AS400 system and maintain performance?
2.If I use global static variable in Java for AS400 connection and call many RPG programs in different parts of my java program will I have only one connection or still will it make lot of connections?
3. To acces AS400 database from Java which is the best ? [Considering connetion pooling, performance etc]
a. Calling RPG program from Java
b. Calling Stored Procedure on AS400 using JDBC
Neena
Comment