EJB bean association to Database/Table

[dwightsmith]

I have what is probably a stupid newbie question. I'm sorry if I am wasting anyone's time or the Forum's space. If there is documentation that would answer this question please point me in the right direction.

I have a WebSphere application that we are testing to see what is involved in porting to Jboss. I have an ejb bean that i am deploying to Jboss 3/tomcat 4. 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 an orale table? How does it know which database and table it is representing? Especially if you want to have connections to different tables with different beans? I inherited 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 a different table in a different database? I assume you have to have another XXXX-service.xml file for each URL you want to connect to, but how do you associate a bean to one of these *service.xml so that it connects to the correct table.

I understand how the JDBC connections (I have made jdbc connections and returned data to JSP's) are made with the linitialcontext lookup for a datasource, but not the mechanics of how the beans are associated with a database table. Is it the name of the bean matching a table name in one of the connected xxxx-service.xml's? What if you have the same table in a different database?

Is there documentation that would help me understand this?

Thanks for any help you can give.
Dwight.

[jcordes]

Hi Dwight !

There's no such thing as a stupid question (only stupid answers) ;-). A good starting point for documentations is http://sourceforge.net/project/showfiles.php?group_id=22866. Under JBoss3.0.0 you can find the QuickStart-Guide and some examples. The beans are mapped to a table by the table-name tag (you can even map a bean to a different datasource (and database-type), see jbosscmp-jdbc_3_0.dtd in the docs/dtd directory for details). If you have only a single datasource all the configuration should go into the defaults-section. You were right about the assumption, that you have to write a service-file for each datasource, but then the datasources are identified by the jndi-names (again in the datasource-tag of jbosscmp-jdbc.xml).

Hope it helps,

Jochen.

[dwightsmith]

Thanks for the info. I'll work my way through the doc. Thanks.

[dwightsmith]

Thanks for the infor. I'll work throught the doc. Thanks

[dwightsmith]

Thanks for the info. I'll work through the doc. Thanks