Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


ID: 15561, JDatabase Wizard

by Jacques Leplat Email: Anonymous


Java SWING app. Allows the user to navigate their dbms and specify which entities to generate Java JDBC source code for.
Download Details
FTP  download also available 0 bytes
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For JBuilder, Version 1.0  to 1.0 12 downloads
Copyright: All rights reserved


Size: 0 bytes
Updated on Thu, 01 Feb 2001 09:24:49 GMT
Originally uploaded on Thu, 01 Feb 2001 09:24:49 GMT
Description
Writing Java applications usually involves database connectivity. The database connectivity requires some kind of object relational mapping layer to be coded. This coding process is time consuming, repetitive, error prone and can require some complex programming when dealing with certain datatypes.

The JDatabase Wizard is a user friendly application which allows developers to quickly specify, generate and revise the object relational mapping layer for the application, so freeing them to concentrate on the application's specifics.

Features:

The application is completely written in Java, using SWING as the graphical interface.

The user interface is easy to understand and use right away.

The application is dynamic. The Wizard only gets schema information when necessary. In this way the Wizard can be much more responsive: there are no long waiting times for the Wizard to download a complete database schema.

The Wizard provides high degree of control over the generated classes. This is achieved by allowing individual database columns to be earmarked for SQL Select, Insert or Update.

Database Tables, Views and Stored Procedures are supported by the Wizard.

Multiple queries for one database entity can be encapsulated within the same generated class. The "Where" and "Order By" SQL clauses are entered by the user of the Wizard, matching select, update or delete methods are generated by the Wizard for the Java programmer to use. This also allows the user of the Wizard to enter DBMS specific SQL syntax, if required.

Multiple classes can be generated for the same entity. Some classes can be made to encapsulate only a selected number of columns from a table or view, another class can encapsulate the entire database entity's set of columns.

The full version uses project files. In doing so it is possible to come back and make changes, then regenerate the code instantly. It is also possible to change existing entries in the Wizard, and then regenerate the code, without ever connecting to the database.

Datatype conversions are handled by the Wizard. LONGVARCHAR for example is internally manipulated as a CharacterStream and converted to a String for easier coding. It is also possible to earmark specific columns of one type as of another type. For example, if a database column is stored as a VARCHAR and the underlying data is integral, the wizard can perform the data conversions.

Configurable JDBC type mapping. In some cases a JDBC driver exposes a database type as an Object, when in fact it can be accessed using getString() or such like. The Wizard allows "default type maps" to be configured to generate just the right code for each database type. The type mappings are stored in the project file.

Versions:

The Wizard is available in three versions:

Evaluation Version: the product contains no support for project files.

Full Evaluation Version: the product allows project files to be created and opened for a limited period. After expiry, the product behaves like the evaluation version.

Full Version: support for project files is enabled, the product does not expire.

For more information, see http://www.j3ltd.com/wizard/overview.htm

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC04