Hello folks, i have a question regarding this scenario :
- All data is stored in a relational database system - multiple applications access this data using a single persistence layer. - The model includes complex relationships between tables. - Design requirements will include supporting complex queries, bulk updates/deletes, and disconnected operations
I think JPA can be used for both simple and complex queries, although it does depend on how complex 'complex' is. You can usually get JPA to do what you want it to do, although sometimes just straight SQL may be easier than doing it through JPA - as could be said for pretty much any persistence mechanism built upon JDBC.
As far as bulk updates go, well, I'd use a bulk updating mechanism at the database level. Why involve Java processing when it's a bulk process? That's what ETL tools are for. If you have a license for Datastage hanging around then you should use it.
Joined: Feb 18, 2005
OK, tks Cameron !! ;-)
Cameron Wallace McKenzie
author and cow tipper
One thing you are very right about is "figuring out what the exam questions is asking."
You could post just about any SCEA exam question on JavaRanch and start a firestorm debate about which answers is 'most correct.' But on the exam, it's not up for debate. Knowing the correct answer is just as important as knowing the correct answer that they want.