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.
