Using EGL web service v8.5 deployed to WAS v6.1
I'm getting data from multiple database servers. The primary database is configured in EGLbld, secondary databases are fetched using SQLLib.connect. This works as needed. However, due to security compliance, I need to ensure the database credentials are not exposed in plain text. As such, SQLlib.connect("jdbc/secondDB", "myUser", "mySecret") is not permissible. It's preferable to have developers only need to know the jndi name without knowing the db credentials for the target server. The jndi resources are set by the WAS admin on the server and not in the applications.
In java, I would instantiate a Connection object using DataSource having been set by a jndi resource via the InitialContext.lookup() method. Can this be done similarly with EGL? Does J2EELib.getContext() provide similar functionality. Although I wouldn't expect to create an EGL connection like this.
Alternately, can the user and password be encrypted and supplied to the SQLLib.connect() method? If so, how would this be done?