ThinkUI SQL Client Installation

You don't need to be a Java expert in order to install the ThinkUI SQL Client software. However, it would help if you are familiar with Jar files, CLASSPATH, JDBC connection properties for your database, and basic batch/shell scripting.

1. The first step is to install the Java Runtime Environment (JRE).
2. Next download the appropriate JDBC driver (Jar file) for your database and copy it to the lib folder.
3. You'll probably need to rename the JDBC driver Jar file to match the required filename and/or update the batch/shell scripts.
4. You may want to carefully follow the instructions outlined in the README.TXT (the file is located in the distribution zip file).
5. Once you have the software installed, you will need to register to receive your personal license key for the software.

Embedded Derby Database Demo

The following tutorial will illustrate on how to create a new Derby database, create a table, insert a record, and perform some quick code generation. The tutorial helps illustrate how easy it is use code generation to reduce the tedious aspects of software development (such as creating Java Beans and SQL queries).

> View Tutorial (Flash Viewer is required)

Customizing the Provided Template Files

Once you are familiar with the various artifacts that you can generate, you are ready to start customizing the templates to your specific requirements and preferences. You will need to be familiar with the Apache Velocity Engine API as well as the ThinkUI SQL Client API.

> View Tutorial (Text File)

Performing Batch Code Generation

Starting with ThinkUI SQL Client 1.0.8, batch code generation is supported via Apache Ant and custom tasks. The thinkui_sqlclient_ant.jar in the "batch" folder contains the "thinkui.sqlclient.ant.GenerateTask" class that can be used to execute any code generation command.

> View Tutorial (Text File)