RE: Connection pooling, JNDI and pcml

Please read the disclaimer at the bottom of this e-mail.

If anyones interested, i found a way to use the glassfish connection
pool to generate as400 objects. In fact i can use the same pool that
generates the jdbc connections (Using JT400):

ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("jdbc/as400Pool");
ConnectionHolder sunConn =
(ConnectionHolder)ds.getConnection();
AS400JDBCConnection conn = (AS400JDBCConnection)
sunConn.getMetaData().getConnection();
AS400 as400 = AS400JDBCConnection.getSystem();

it seems to work well.

Mark

________________________________

From: Anderson, Mark
Sent: 28 January 2010 14:17
To: 'java400-l@xxxxxxxxxxxx'
Subject: RE: Connection pooling, JNDI and pcml


Hi all,

I hope someone can help me, I'm trying to come up with a solution to a
particular problem i have at the moment:

We have several java apps (approx 40) running on a glassfish cluster,
each of these apps connects to 1 of 4 as400 servers using the JTOpen
AS400ConnectionPool object. the problem is that because each application
has it's own connection pool, it's an inefficient use of resources and
can max out the number of allowed connections to the AS400. What i'd
like to do is have a connection pool that woks like a JNDI JDBC
connection pool where we have a connection pool per server rather than a
connection pool per application.

I know this is possible in WebSphere using a JCA connector and i could
probably develop a solution similar to this manually but i ideally want
to use the built in support for connection pools in glassfish. I've
found reference to a resource adaptor (iseriespgmcall.rar) that could
help me but i haven't got a copy of it (i'm using RAD 7 and it's not
included). does anyone know where i could get a copy of that file? Or is
this the wrong way to go? has anybody got any other ideas?

Regards,

Mark

*****************************************************

Confidentiality: -

This message and any attachments are strictly confidential and may contain legally privileged information.
The contents of the transmission are intended for the named addressee(s) only. If you are not the addressee please do not read, print, store or re-transmit it or any attachments to it. Instead, please email it back to the sender and then immediately permanently delete it from your system

The views or opinions presented here are solely of the author and do not necessarily represent those of Redcats (UK) PLC or any of its subsidiaries.

Redcats (UK) plc. Registered Office: 2 Holdsworth Street, Bradford, BD1 4AH. Registered in England, No. 106691