I have an existing web app built using J2EE 1.4, JSF 1.1, MySQL and Tomcat 6. The DB has 40 tables with lots of links between tables. The DB will soon grow to 60+ tables with even more links.
The current web app works fine - it's been up for almost a year - but managing inserts, updates and deletes is getting more and more complicated.
I'd like to migrate from data providers to JPA. So far I like what I've seen of JPA but I'm still evaluating it.
One problem is that the web app uses lots of table components that display information from related DB tables. That's easy to do with data providers. Not so easy to do with JPA, as far as I can tell.
Simple example:I have a contact table whose fields are FKs to company (company name, website), address (address1, address2, city, state, zip code), and person (first name, last name, email) tables. I can execute a JPA query to get the contacts I want. I can bind the results to a table component. But I can't display any properties of the company, address or person objects. Winston suggested adding getters to the contact POJO, but that seems to be duplicating what's already there.
Does anyone have another way to solve this problem?
Any ads or links to ads that appear in this post are not endorsed nor recommended by this poster.
