× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



When you open a JDBC Connection through the toolbox, a job on the AS/400 is
created, under the QUSER profile (I can't remember the job name of the top
of my head, along the lines of QSQxxxxx or something like that.) Every JDBC
call which uses that connection, whether dynamic SQL, prepared statement or
stored procedure will be executed by the same QUSER job.

So if a non-LR RPG program is called twice, through the same connection,
then it will the same as if the program was called twice in a "normal" job,
with files open etc.

As far as I'm aware, the OS/400 job is not multithreaded. If two java
threads used the same connection to try and run a stored procedure, one of
the calls would wait until the first had completed.

Chris

 -----Original Message-----
From:   Tanveer, Mohammad [mailto:MTanveer@friedmancorp.com]
Sent:   11 June 2002 20:48
To:     'java400-l@midrange.com'
Subject:        RE: Stored Procedure Calls

When I call my stored procedure using jdbc and don't set LR on in RPG
program.  It seems like my next call using the existing instance of the RPG
program and if multiple calls are executed to the same procedure it seems
like OS/400 is creating multiple threads of the same job.

Is it a true analysis?

-----Original Message-----
From: Price, Chris [mailto:chris_price@nsb.co.uk]
Sent: Tuesday, June 11, 2002 2:49 PM
To: 'java400-l@midrange.com'
Subject: RE: Stored Procedure Calls



All client Stored Procedures calls, along with all JDBC operations are batch
through the Toolbox.

I think that only if the Java App is running on the iSeries/AS400 in an
interactive 5250 session, then the JDBC calls will probably also be
interactive (perhaps one of the Toolbox guys could confirm this?)

Chris

 -----Original Message-----
From:   Tanveer, Mohammad [mailto:MTanveer@friedmancorp.com]
Sent:   11 June 2002 20:37
To:     'java400-l@midrange.com'
Subject:        Stored Procedure Calls

Stored Procedure Calls using JDBC drivers are interactive jobs on AS/400 or
Batch Jobs?  If interactive is there any study on performance issues using
stored procedures?

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.