Javalee DB2Java

 What's Javalee DB2Java?

 Downloads

 Installing and Running

 Personalization

 History

 TO DO List

 Java API Doc

 CVS

 Author

What's Javalee DB2Java?

The Javalee DB2Java is a tool designed to help developers to make their ‘dirt job' a little easier. Javalee DB2Java helps developers with automatic code generation based on metadata information retrieved from a relational database.

For many people who want to extract information from existing databases, the Javalee DB2Java will be a perfect tool to fit this need. With Javalee DB2Java you can also generate any kind of code or information, based upon the relational database metadata, such as: XML files, Java Bean classes, DAO Java classes and whatever you want to.

Technology

The Javalee DB2Java project was entirely coded using Java Technology. Thus, you will be able to run this tool in any environment with Java installed.

Pre-Requisites

In order to run Javalee DB2Java you must attend to some pre-requisites:

- Have an Operating System running properly;
- Have Java JDK or JRE 1.4 installed;
- Have the “JAVA_HOME” variable set in the environment;
- Be in graphical environment (e.g.: Windows, X Windows, etc.);
- Have access to a relational database (in the local host or through the network).

Behind the scenes

Javalee DB2Java was designed to fit all needs of code generation based on the metadata information from a relational database.

To accomplish that, the tool uses technologies such as: JAXP (Java API for XML Processing), DOM (Document Object Model), XSL (XML Style Sheet Template) and XSLT (XSL Transformation).

All the information extracted is converted to an XML structure and then transformed with a XSL template to generate the outputs. Thus, the user can specify his own XSL (obeying the XML DTD) to generate any kind of code or information.

Originally Supported Relational Database Systems

Javalee DB2Java supports a large number of RBDMS'. I'd say it supports all of existing RDBMS' that provides a JDBC driver type 4.

Initially, Javalee DB2Java comes with the following tested RDBMS' configured:

  • MySQL
  • Oracle 9i and 8i
  • MS SQL Server
  • PostreSQL
  • Firebird

If you want, just follow the headlines to add and configure support for more RDBMS'.

Bugs

I know this is just the very first realease, so, you may face some (or many) bugs.

Just keep let me know what is going on, what problem you had that I'll try to fix it.

License

You can use this software for any purpose, for free. There is no need to pay any fee for it.

The only thing I ask is to give a feed back about the software, telling me how come you like it, rate it if possible, tell me what you expected and suggestions are welcome.

You can use the source code, change it and improve the code, as long as you keep the head comments of the source file, giving me the credits. Of course you can add comments and credits to yourself and anybody else. And, the most important, let me know the changes you've done and the releases you published.

Always make this software available to the public use.

Warranty

There is no warranty in this software.

Run it on your own risk. But I assure you that it has got no code that causes damage to your computer.

Thanks

Special Thanks to Ricardo Lecheta that helped me with good tips about retrieving metadata information with Java. Also thanks to Rafael Steil for helping me with XSL and Estáquio (TaQ) for helping me with Java Swing.

Thanks to GUJ community for giving me some support (www.guj.com.br).

This software is proudly made in Brasil