Read all classes and report on table/sql statements
Hi all
I am documenting a large j2ee system. I would like to find a way to traverse all the classes in the application (1300) and print out a list of all available db info e.g. table names, sql statements etc.
Is there a tool that will help me to do this. Could I get a developer to write a utility that will easily to this.
Apologies if this question is misposted. I dont know a lot about java.
Thanks
[434 byte] By [
fireflynna] at [2007-11-26 17:51:27]
# 1
This would be very difficult to do without an understanding of how the application has been developed. There a numerous methods of database access in J2EE architectures, JDBC, EJB, Hibernate and many, many more. These often abstract the SQL, tables etc into objects so there may not be any info. The application could, of course use Stored Procedures instead of embedded SQL statements again, which may or may not have been abstracted away. I know this sounds very obvious, but do you not have access to the database?
The most viable solution is to use a developer resource to look at the architecture of the application instead and determine how it has implemented RDBMS connectivity and implementation and document that.
