I have over seven years of extensive database experience and am trying to figure what components of J2EE I need to understand in order to be able to apply my experience
in designing/developing web enabled databases.
Would anyone be able to suggest a road map for a database programmer trying to understand J2EE in the context of the database tier of the internet application architecture and its interactions with other tiers ?
Interesting question... The databases are usually the same, the only thing you've to understand is how your database tables are going to be mapped onto objects, O/R mapping is the first problem you should be concerned of.
I think you want to Learn that part of J2EE which is directly related to data base. I think you should concentrate on EJB and XML related work. XML is extensively used for creating static data base. Also in EJB you can study about how data base related problem should be scratched in term of EJBs.
If you are just talking about creating a database driven application, start with the basics.
Familiarize yourself with JDBC. Once you understand how to accomplish transactions, batch jobs, preparred statments, result sets, and a couple of the root JDBC items you will be ready to move on.
After JDBC, start in on EJBs. Understand Entity Beans and probably become familiar with OR mapping tools like CoccoBase and TopLink.
Finally, look at the new JDO spec.
If you are talking about becoming familiar with J2EE in itself, just go through the components that make up the spec.