Does anyone know of a simple tool or plugin that can be used in JDeveloper to spit out what database objects are in use within a JDeveloper business component project?
For example, if I'm using emp, dept etc from the scott database schema as business objects, is there a tool that can be used to analyse the JDev BC project and generate something like a pdf that lists these tables?
I know there are more enterprise options available but I just need a quick and simple tool that will analyse my business components project and tell me the database tables that are in use in that project.
Thanks. I have but it doesn't allow me to easily generate a complete listing of business components.
In the database world, I'd simply run a select against dba_objects to list all the objects in a database. I would be very helpful to have something similar in JDeveloper to list all the database objects used in business components.
AFAIK there isn't such a diagram or tool available. The framework doesn't store this information in n a central repository but in multiple meta data files (xml files). You can searchthrough them to find the info you like to get. Problem might be that some of the business componentes e.g. VO are not build one DB object alone but on multiple of them (union, joins...). To get the DB objects from such a VO you have to analyse the query.