RE: java-qtemp

Murali,

I see,

why do you need a proxy to access the native 400 JDBC driver? 
Why Cant you use the native JDBC driver directly without a proxy?

cheers
Colin.W

http://j2ee.mine.nu/javafeed
 
Extension   5800
Direct dial   0870 429 5800


-----Original Message-----
From: murali dhar [mailto:hydchap1@xxxxxxxxx] 
Sent: 10 January 2005 14:34
To: Java Programming on and around the iSeries / AS400
Subject: RE: java-qtemp 


we experienced using JT400 is very slow when using a distributed access,so
we use java proxy which runs in QBATCHXP in both development and production
as it by passes the use of JT400 and uses the native 400JDBC driver which is
much quicker...
 
Murali.

Colin Williams <colin.williams@xxxxxxxxxxxx> wrote:
Murali,

"JT400 is horrifically slow when using a distributed access"

Can you give more details on this as I use jt400 too access database all the
time

cheers
Colin.W

http://j2ee.mine.nu/javafeed

Extension 5800
Direct dial 0870 429 5800


-----Original Message-----
From: murali dhar [mailto:hydchap1@xxxxxxxxx] 
Sent: 10 January 2005 13:31
To: Java Programming on and around the iSeries / AS400
Subject: RE: java-qtemp 


Hi Joe,
we are not using JT400 as it is specific to AS400,any java code we write on
the AS400 needs to be platform independent,Using JT400 we can never freely
port Java code to run on Unix. JT400 is horrifically slow when using a
distributed access, so we are using Java Proxy which uses native 400 JDBC
driver which is much quicker.

Thanks,

Joe Pluta wrote:
I'm going to assume you've used IBM's Java Toolbox for the AS/400 (known as
JT400 or JTOpen, depending on which version you have). If so, you've used
the com.ibm.as400.access.AS400 class, which basically allows a Java program
to access an AS/400 or iSeries host. Once you create an AS400 object, you
can then use it to access the rest of the host objects. For example, the
ProgramCall class allows you to call a program, while the AS400KeyedFile
class allows access to keyed files.

I'm not 100% sure of the sequence of events, but when you create an AS400
object and then use it to call a program using the ProgramCall class, what
happens under the covers is that JTOpen submits a job named QZRCSRVS for
you. This job actually calls the program, and communicates back to the Java
application.

What I do is create a single AS400 object for my session, and then use it to
create all of my ProgramCall objects. That way, they'll all run under the
same QZRCSRVS job. This means that not only can I access the QTEMP library
for the QZRCSRVS job, I can change the library list and even execute
overrides. Pretty cool stuff.

Be warned: there are (or at least there used to be) circumstances under
which you may not get the same QZRCSRVS job for all of your ProgramCall
objects. However, I have not run across that in a long time, and as long as
you use the same AS400 object for all your ProgramCalls, you should be fine.

Joe



> From: murali dhar
> 
> whats QZRCSRVS? I reuest you write few more lines , Im new to Java
just
> like other AS400 folks.

-- 
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.



---------------------------------
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.
-- 
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.
This e-mail has been sent by a company of Bertram Group Ltd, whose
registered office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and
may contain privileged or confidential information. If you are not the
intended recipient, any disclosure, copying, distribution or any action
taken or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender immediately. Opinions, conclusions and statements of
intent in this e-mail are those of the sender and will not bind a Bertram
Group Ltd company unless confirmed in writing by a director independently of
this message. 
Although we have taken steps to ensure that this email and any attachments
are free from any virus, we advise that in keeping with good computing
practice the recipient should ensure they are actually virus free.

-- 
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.


                
---------------------------------
Do you Yahoo!?
 All your favorites on one personal page - Try My Yahoo!
-- 
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.

This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.