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


  1.  Home
  2. JAVA400-L
  3. September 2005

Re: PCML and connection pooling

You can code a connection pool handling class that all applications use to get/return connections.
When web facing AS400 applications often the user needs to login AS400 with a userId then there may have to be a connection pool for each user. Sometimes in this kind of situation a pool is not needed and you can simply store the connection (in session for example) for use by all applications. 



SPoger@xxxxxxxxxxxxxxxxxx wrote:


How would a single pool be shared among many Java applications? Would I
put a reference to the pool in JNDI? I do not want a different pool for
each application.

Thanks

Sarah Poger * Manager * SunGard * GMI * 1 S. Wacker, suite 400, Chicago,
IL 60606
Tel 312-577-6193 * Fax 312-577-6101 * www.sungard.com/gmi
CONFIDENTIALITY:  This email (including any attachments) may contain
confidential, proprietary and privileged information, and unauthorized
disclosure or use is prohibited.  If you received this email in error,
please notify the sender and delete this email from your system.  Thank
you.


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Monday, September 12, 2005 12:27 PM
To: Java Programming on and around the iSeries / AS400
Subject: RE: PCML and connection pooling


Hi
please look in documentation, there is an example of
how to use it
here it is
This example creates an AS400ConnectionPool with a
limit of 128 connections:

 // Create an AS400ConnectionPool.
 AS400ConnectionPool testPool = new
AS400ConnectionPool();
 // Set a maximum of 128 connections to this pool.
 testPool.setMaxConnections(128);
 // Preconnect 5 connections to the AS400.COMMAND
service.
 testPool.fill("myAS400", "myUserID", "myPassword", AS400.COMMAND, 5);
 // Create a connection to the AS400.COMMAND service.
(Use the service number constants // defined in the AS400 class (FILE, PRINT, COMMAND, DATAQUEUE, etc.)) 
 AS400 newConn = testPool.getConnection("myAS400",
"myUserID", "myPassword", AS400.COMMAND);
 // Create a new command call object and run a
command.
CommandCall cmd = new CommandCall(newConn); cmd.run("CRTLIB FRED"); 
 // Return the connection to the pool.
testPool.returnConnectionToPool(newConn); // Close the test pool. 
 testPool.close();

--- SPoger@xxxxxxxxxxxxxxxxxx wrote:


How is the pool configured and managed?

Sarah Poger * Manager * SunGard * GMI * 1 S. Wacker,
suite 400, Chicago,
IL 60606
Tel 312-577-6193 * Fax 312-577-6101 *
www.sungard.com/gmi
CONFIDENTIALITY:  This email (including any
attachments) may contain
confidential, proprietary and privileged
information, and unauthorized
disclosure or use is prohibited.  If you received
this email in error,
please notify the sender and delete this email from
your system.  Thank
you.


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni 
Sent: Monday, September 12, 2005 10:09 AM
To: Java Programming on and around the iSeries /
AS400
Subject: Re: PCML and connection pooling


You can use AS400ConnectionPool to create a pool of
AS400 objects and use them

Ashish

--- SPoger@xxxxxxxxxxxxxxxxxx wrote:


Is there a way to take advantage of connection
pooling when using PCML
or the ProgramCall API in the jt400 toolkit?

Thanks,
Sarah Poger


Sarah Poger * Manager * SunGard * GMI * 1 S.

Wacker,

suite 400, Chicago,
IL 60606
Tel 312-577-6193 * Fax 312-577-6101 *
www.sungard.com/gmi
CONFIDENTIALITY:  This email (including any
attachments) may contain
confidential, proprietary and privileged
information, and unauthorized
disclosure or use is prohibited.  If you received
this email in error,
please notify the sender and delete this email

from

your system.  Thank
you.


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf

Of

michael@xxxxxxxxxxxxxxxxxx
Sent: Friday, September 02, 2005 8:30 AM
To: Java Programming on and around the iSeries /
AS400
Subject: JSPs and Property Files - Websphere

Dynamic Reloading

Aha...found something...In the Admin Console, I

can

do this:

Applications > Enterprise Applications >
application_name and work with
reloading...

Reload Enabled
   Specifies whether to enable class reloading

when application files

are updated.
   Data type    Boolean
   Default      true
Reload Interval
   Specifies the number of seconds to scan the application's file
system for updated files. The default is the value
of the reload
interval attribute in the IBM extension
(META-INF/ibm-application-ext.xmi) file of the EAR
file. This setting
takes effect only if class reloading is enabled.

   The reload interval specified here overrides

the

value specified in
the IBM extensions for each Web module in the EAR
file (which in turn
overrides the reload interval specified in the IBM extensions for the application in the EAR file). 

Is this what I'm looking for? Will this cause all
pages to be reloaded?
What application files are indicated here?

Thanks...


-------- Original Message --------
Subject: RE: JSPs and Property Files
From: "Mike Silvers" <msilvers@xxxxxxxxxxx>
Date: Fri, September 02, 2005 9:15 am
To: "Java Programming on and around the iSeries

/

AS400"

<java400-l@xxxxxxxxxxxx>

You can force it to reload from the application

server (there is a

property of Tomcat that allows this).

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On 
Behalf

Of

michael@xxxxxxxxxxxxxxxxxx
Sent: Friday, September 02, 2005 9:06 AM
To: java400-l@xxxxxxxxxxxx
Subject: JSPs and Property Files

We have a property file (actually a couple) that

is being loaded in a

jsp. We have a problem where the property file

is

changed, but the

change is not reflected in the jsp. So...is

there

a way to force the

jsp to be recompiled? I suppose I could delete

the

.java and .class

associated with the jsp programatically when the

property file changes


to force the jsp to be recreated, but that seems

to be a bit kludgy.

Or, is there a way for the jsp to dynamically

read

the property file

when the page is accessed?

TIA...

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




                
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com 
--
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 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.
__________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
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.