JBoss Community

Re: Custom/Wrapped JDBC Driver for DataSource

created by Leticia Ozuna in JCA - View the full discussion

I am having the same issue as

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/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

Start a new discussion in JCA at Community