Jaws, Standardjaws, and EJB datasource

[dwightsmith]

I have what is probably a stupid question. I have an ejb bean that i am deploying.
I have defined the <table-name> tag in the jaws.xml file that I am deploying with it
In the standardjaws.xml I have defined a tag that corresponds to one
that I defined in the oracle-service.xml in the ..\server\default\deploy.

My question is how is the ejb bean associated with a datasource? How does it know
which database and table it is representing? Especially if you want to have multiple
datasources? I inherited an a project with one bean that works fine, but there is only
one datasource on the server. What if i have another bean that I want to add that represents
another table in a different database?

I understand how the JDBC connections are made with the linitialcontext lookup for a
datasource, but not how the beans are associated with a datasource.

Thanks for any help you can give.

Dwight.

[tdang]

Which version of JBoss are you using? Since JBoss 3.xx uses jbosscmp-jdbc.xml for mapping. In this file you have a tag for mapping datasource:

java:/MyDB


Take a look in QuickStart.

Hope this helps.

[dwightsmith]

Thanks for the help. I will try posting to the other forum because its more the EJB bean association to a database/table that I am wondering about as opposed to the JDBC stuff.

Thanks again

[chgrimm]

the way you did it was absolutely right if you want to use ony one database with one schema.
you can still use standardjaws.xml & jaws.xml with jboss 3.x

if you want to access multiple databases or database-schemas just specify your datasource in the particular jaws.xml

the datasource specified there overwrites the config made in standardjaws.xml