res-auth Application and XAPoolDataSource

[randyp]

We need to connect to a DataSource using a large number
of different client schemas. I've specified
<res-auth>Application</res-auth> in ejb-jar.xml and am
using the DataSource.getConnection(user,pass) method to
obtain the connection. However, querying the returned
connection for the USER returns the username that
XADataPoolSource is forcing me to specify in jboss.jcml
(or it throws a NullPointer fit)

I recall a similar question arising before about the
Minerva pooling not honouring the application requested
username/passwword and a comment that the fix should be
relatively easy.

I'm using JBoss 2.4.0 + Tomcat 3.2.3 connecting to
Oracle 8i.

1. Is it true that this is still a problem? If so, any
plans to fix it?
2. Where has the source for
org.jboss.pool.jdbc.xa.XAPoolDataSource
escaped to? I downloaded the complete source and
could not find it.

[johnnycannuk]

Yeah, I'm having the same problem and I would like a fix ...please tell me that 2.4.1 fixes this

[davidjencks]

The source is gone in 3.0, these classes are obsolete there. Are you browsing cvs? you have to try the attic or the 2.4 ( I think ) cvs branch. Before they left they moved to jbosspool, but I think this is post-2.4

With the jca stuff, you can specify "per-factory" or "per-user" pooling. I think "per-user" is what you want; I don't know if or how to do this with XADataSourceLoader configuration.