Getting java.sql.Connection from WildFly 13 datasource when passing user and password as arguments

[sergiu_pienar]

Using WildFly 13.

I'm trying to get a java.sql.Connection from the datasource that is being defined in stadalone.xml, as so:

ctx = new InitialContext(); 
DataSource ds = (DataSource)ctx.lookup("java:jboss/datasources/myDS"); 
connection = ds.getConnection(user, password);   

The above always fails with  `Caused by: javax.resource.ResourceException: IJ031016: Wrong credentials passed to getConnection`,

while ds.getConnection() works just fine and can retrieve the connection.

Moreover, when getting and inspecting the metadata from the connection, the user and password seem to be the same that I'm passing to the method with arguments but which fails.

[simkam]

Hi,

how does your datasource definition look like? Just a guess but you might be missing datasource attribute allow-multiple-users=true.

[sergiu_pienar]

This is the config: https://pastebin.com/S4MEEuTY Sorry for not posting here but the embedded editor isn't that bright...not sure where I should add the mentioned attribute. Thanks.

[simkam]

Try to add attribute allow-multiple-users=true

<datasource ...>
    .... 
    <pool>
        ....
       <allow-multiple-users>true</allow-multiple-users>

        .....
    </pool>
    ....
</datasource>