How can EJB connect to database user specific?

[cmou]

Hi,

I want to connect with Datasource.getConnection(user, password). oracle-service.xml is deployed with following configuration:


  <depends optional-attribute-name="ManagedConnectionFactoryName">
    
      jdbc/tnet
      
        ...
      

      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
    
  

  <depends optional-attribute-name="ManagedConnectionPool">
    
      0
      ...
      ByApplication
    
  

  <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

  <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

  java:/TransactionManager

  jboss.jca:service=RARDeployer



If I want to connect twice with different users the first connect works correctly but the second one throws an ResourceException ("Wrong credentials passed to getConnection!").

What's going wrong and what can I do?

Thank's for your help

-chris

[davidjencks]

Could you please file a bug report? I don't think I ever wrote any tests for this functionality, and they are obviously needed. If you want to write a test using the TestAdapter (org.jboss.test.jca....) that would be welcome and speed things up a bit.

I will try to get to this very soon.

thanks
david jencks

[cmou]

David,

thank you for answering.

I did report the bug (RequestID 648442).

How do I use the TestAdapter? Is there any documentation about it?

regards

-chris

[davidjencks]

Thanks for reporting the bug. The test adapter is in the testsute in org.jboss.test.jca.adapter. It only connects to test cases:-)