3 Replies Latest reply on Dec 5, 2002 6:53 PM by David Jencks

    How can EJB connect to database user specific?

    Christian Mouttet Newbie

      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