I've done a little research since the last post and found that tranql
documentation is pretty much non-existent, not to mention the project looks
mostly dead.
Anyway, I have a custom LoginModule that with do the front-line
authentication straight from Oracle users and populate the principals as
needed. I also have JPA code working from a console defined database pool,
but was just looking for that one piece that would allow me to to the proxy.
I think I understand what you're suggesting but how do I get geronimo to use
the new class instead of the default? I used the console database pool
configuration and it doesn't contain any class references besides the jdbc
driver.
The console doesn't seem to generate a working deployment descriptor:
<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
<dep:environment
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
<dep:moduleId>
<dep:groupId>console.dbpool</dep:groupId>
<dep:artifactId>TestPool</dep:artifactId>
<dep:version>1.0</dep:version>
<dep:type>rar</dep:type>
</dep:moduleId>
<dep:dependencies>
<dep:dependency>
<dep:groupId>com.oracle</dep:groupId>
<dep:artifactId>oracle-jdbc-driver</dep:artifactId>
<dep:version>10.2.0.1.0XE</dep:version>
<dep:type>jar</dep:type>
</dep:dependency>
</dep:dependencies>
</dep:environment>
<resourceadapter>
<outbound-resourceadapter>
<connection-definition>
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
<connectiondefinition-instance>
<name>TestPool</name>
<config-property-setting
name="Driver">oracle.jdbc.OracleDriver</config-property-setting>
<config-property-setting
name="Password">test</config-property-setting>
<config-property-setting
name="UserName">test</config-property-setting>
<config-property-setting
name="ConnectionURL">jdbc:oracle:thin:@localhost:1521:SID</config-property-setting>
<connectionmanager>
<local-transaction/>
<single-pool>
<max-size>10</max-size>
<min-size>0</min-size>
<match-one/>
</single-pool>
</connectionmanager>
</connectiondefinition-instance>
</connection-definition>
</outbound-resourceadapter>
</resourceadapter>
</connector>
djencks wrote:
>
>
> On Feb 11, 2008, at 6:35 AM, Brian Gregory wrote:
>
>>
>> 1. Misconception on my part, what library is used for connection
>> pooling?
>> (Where is this is the docs?)
>
> Dunno about docs. The basic implementation is in
>
> https://svn.apache.org/repos/asf/geronimo/components/txmanager/trunk/
> geronimo-connector
>
> and the gbean wrappers and deployment code are in
>
> https://svn.apache.org/repos/asf/geronimo/server/trunk/plugins/connector
>
>> 2. Proxy session is another name for changing the user credentials
>> on an
>> oracle connection. OracleConnection.openProxySession()
>> 3. I'm not familiar with tranql. Can you point me to the
>> documentation?
>
> Again, no docs I know of.
>
> https://svn.codehaus.org/tranql
>
> especially vendors/oracle/trunk
>
> I think what you want to do is override
> AbstractXADataSourceMCF.matchManagedConnections in the oracle
> subclass so if there is no match on connections with their existing
> credentials it calls openProxySession on one of the connections to
> switch users. If openProxySession is very lightweight then just
> calling it without a search would be reasonable.
>
> Out of curiousity, how are you supplying the correct user to the
> connector? Application managed security (datasource.getConnection
> (user, password) or container managed security (using the identity of
> the logged in user as tracked by the app server, possibly mapped with
> an appropriate login module)?
>
> Hope this helps and let us know if you run into problems or succeed :-)
>
> thanks
> david jencks
>
>
--
View this message in context: http://www.nabble.com/proxy-session-w--built-in-dbcp-%2B-openjpa-tp15404731s134p15425716.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
|