[jboss-user] [JCA] - Re: Custom/Wrapped JDBC Driver for DataSource

[Leticia Ozuna]

Leticia Ozuna [http://community.jboss.org/people/mostserene] created the discussion

"Re: Custom/Wrapped JDBC Driver for DataSource"

To view the discussion, visit: http://community.jboss.org/message/567959#567959

--------------------------------------------------------------
I am having the same issue as 
h2.  http://community.jboss.org/message/517062#517062 Custom/Wrapped JDBC Driver for DataSource
...

I need to instantiate a data source connection pool with a proxy user and at the session level switch the connection on behalf of the authenticated user.
I have a jaas security realm implmentation to create a custom principle, 
I have a custom driver that wraps an oracle oci driver in order to inject properties from the custom principal configured in a a datasource 
..
the issue is that the custom jdbc driver when set in a -ds.xml is ignored and the driver-url is the only element used to make the connection. The custom driver is never loaded.

I am using Pete Bennett's example in
 http://community.jboss.org/docs/DOC-10049 http://community.jboss.org/wiki/IntegratingOracleVPDandJBoss with a custom JAAS realm

I have tried JBOSS 4.2 with JDK 1.6 on solaris
as well as JBOSS 5.0 with JDK 1.6 on solaris

The realm works, the datasource works, the application works, a custom jsp page can interrogate the underlying connection to see that it is a WrappedConnection  but the driver never loads and worse yet never errors out

I see the reference to a jms /jca configuration and I have tried to set up the message queue but I don't see how it applies to the problem Roland and I are encountering.  Is there a more fleshed out discussion regarding interrogating a principle to inject it's properties to the datasource driver?

Thanks
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/567959#567959]

Start a new discussion in JCA at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2098]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101025/a829df65/attachment.html