Multi Datasource bounded but can't use?

[georged]

Hi all,

I'm new to Jboss. I'm using Jboss3RC2 try to deploy two hsql datasource to jboss server. I created a new hsqldb2-service.xml use a new datasource jndi name HsqlDs2, and place it to deploy directory. That's deployed succesful. jndi view also there. However, when I try deploy a CMP bean use the java:/HsqlDS2 in my jaws.xml. It always give me the following deploy error:

ERROR [EntityContainer] Exception in service lifecyle operation: create
java.sql.SQLException: ResourceException javax.resource.ResourceException: No matching credentials in Subject!
at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:105)
at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getConnection(JDBCCommand.java:694)
at org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java:120)
at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.create(JAWSPersistenceManager.java:130)

If I use my first datasource, it's working well. Any idea will appreciate.

Thanks in advance,

George

[davidjencks]

You need a section in login-conf.xml for each datasource. BTW you can put both mbean configurations in one hsqldb-service.xml file.

[georged]

Thank you david, its working well now, and also I pu both mbean in one hsqldb-service.xml file.