AS400ConnectionPool as JNDI Resource

[Marc Logemann <spam1@xxxxxxxxxxxx>]

Hi,

i am wondering if anyone allready used AS400ConnectionPool (NOT mix that 
with AS400JDBCConnectionPool) in conjunction with a Tomcat JNDI 
Resource. I want to lookup an AS400 object with JNDI pretty much the 
same way, people use JDNI for JDBC Connections like this:

Context envCtx = (Context) initCtx.lookup("java:comp/env");
AS400 as400 = (AS400) envCtx.lookup("bean/as400connection");

When looking up the connection, the resource factory (which i have to 
write for the JNDI provider - something like the AS400JDBCObjectFactory 
from JTOpen)return an AS400 connection, the connection should come from 
the connectionPool of course. This pool can be configured in the 
server.xml of tomcat or any other J2EE container.

This could look like this:

<ResourceParams name="bean/as400connection">
 <parameter>
   <name>factory</name>
     <value>com.logentis.jtopen.AS400ObjectFactory</value>
   </parameter>
   <parameter><name>maxActive</name><value>10</value></parameter>
   <parameter><name>prestart</name><value>5</value></parameter>
   <paramter><name>system</name><value>myiSeries</value></parameter>
   [..]
 </ResourceParams>

The factory would work in a way that on first lookup, the Pool will be 
created based on the supplied parms and gets back the first connection. 
All subsequent lookups are just delegates to the pool instance that is 
inside the factory.

Indeed this is such an obvious generic problem / approach, that perhaps 
i missed some piece from IBM or an alleady built solution for this. If 
anyone is aware of something like that, please gimme a sign.

Otherwise i would implment that stuff the way like described. Perhaps 
its even useful to be implemented directly into JTopen, but to me the 
openess of JT-Open is more a marketing effect. There is no serious 
developer list, i once tried to bring something via the oficial JTOpen 
forum, needless to say that this wasnt very succesfull, but perhaps i 
should try once again.

--

regards
Marc Logemann
http://www.logemann.org

--
"Programming is like Sex, one mistake and you support it for a lifetime"