Using J2C Connection Factory with EGL

VERSION 1 Published

Created on: Jan 19, 2009 4:51 AM by AndySteele - Last Modified:  Jan 19, 2009 6:41 AM by AndySteele

This idea was previously posted on discussion forums.

Whilst investigating the RDi Web Services wizard for RPG code I noticed the ability to abstract the connection to the iSeries using a J2C connection factory - see topic "Developing i5/OS Web services" in the RDi help files. This allows one to delegate the management of the connection, including server name and authentication details to Websphere and not have to build this into the application. It also gives us the ability to provide connection pooling, monitoring and so on.

The current method we have of using runtime linkage parts means that we still need to update server settings in a properties file before moving the application between development, test, production etc. servers. It also means that we need to develop our own means of setting, storing and retrieving user credentials to supply to sysLib.setRemoteUser()

Is there any way that the existing CALL statements could use a connection factory to manage the connection to the remote system?

From one reply to the original discussion I realise that this is one of many possible solutions but I think has merit in that it essentially makes the iSeries connection available as a container managed resource in the same way that DataSources are.
Average User Rating
(7 ratings)




Jan 22, 2009 2:07 PM Click to view dan_darnell's profile dan_darnell says:

Andy has hit upon a crucial issue with regard to application configuration/deployment. Inevitably mistakes are made as an application is manually reconfigured for deployment to development, test, production, etc. servers. This plagues us constantly. I think the J2C connection factory idea is a great one!

Jan 23, 2009 10:28 AM Click to view S.Westerlinck's profile S.Westerlinck says:

This is one of the reasons why I would have loved to see the linkage in the EGL runtime be based on an SCA container.

Jan 28, 2009 3:05 PM Click to view dan_darnell's profile dan_darnell says:

To me, all of the following Jam topics seem related:

http://www-949.ibm.com/software/rational/cafe/docs/DOC-2847
http://www-949.ibm.com/software/rational/cafe/docs/DOC-2843
http://www-949.ibm.com/software/rational/cafe/docs/DOC-2850
http://www-949.ibm.com/software/rational/cafe/docs/DOC-2793

And also my thread in the Cafe:

http://www-949.ibm.com/software/rational/cafe/thread/1394?tstart=45

...which says to me that this is an area (call it "configuration and deployment to a variety of target environments") that many people are finding cumbersome to manage in the EGL/RBD world.

Bottom Banner