Global Preferences - Database Connection

This chapter is composed of :

1. Introduction
2. JDBC
   1. Database Type
   2. Database Driver
   3. Default Value
   4. Check Database Driver
   5. JDBC Level
   6. Reverse
3. Classpath
   1. Add Jar
   2. Add Folder
   3. Add Variable
   1. SOYATEC_DATABASE_HOME
   2. Bundled JDBC Drivers
   4. Edit Variable
   5. Up - Down
   6. Remove

1. Introduction

The Connection Preferences allows the developer to set Connection global settings.

These settings will be inherited to each new Database Connection wizard page.

2. JDBC

2.1. Database Type

The Database Type selector allows you to choose Database predefined drivers.

The Database Type selection sets a predefined Database Driver and a JDBC Level.

2.2. Database Driver

The Database Driver is an updatable field, this allows any modification to fit your particular needs.

2.3. Default Value

The Default value resets the Database Driver to its predefined value.

2.4. Check Database Driver

The Check Database Driver button tests the Eclipse Platform capability to load this particular JDBC Driver.

In the case of a Check failure, the DatabaseConsole gives you a short explanation about the failure reason :

2.5. JDBC Level

The JDBC Level allows you to choose a JDBC predefined Level.

This value is used with the OJB Code Generator.

2.6. Reverse

Each new Database Connection will attempt to reverse the Meta Data of a particular Database with the Reverse checked box.

3. Classpath

With this preference you can define where your JDBC drivers are stored.

3.1. Add Jar

The Add Jar button opens a *.jar or *.zip selector.

3.2. Add Folder

The Add Folder button opens a folder selector.

3.3. Add Variable

With the Add Variable you can choose among the predefined Eclipse Platform JDT Variables.

3.3.1. SOYATEC_DATABASE_HOME

The SOYATEC_DATABASE_HOME is pre-set to the EclipseDatabase root plugin.

The EclipseDatabase plugin has some known JDBC Drivers.

Extend the SOYATEC_DATABASE_HOME variable :

3.3.2. Bundled JDBC Drivers

At the local file system level you can check the contents of each driver's directory.

You will see that some additional files like the changelogs or the licence are provided :

The use of this variable has a consequence in team work.

The connection file will store this variable.

If you share your Database files with a team system, by using the SOYATEC_DATABASE_HOME variable set to the predefined drivers, your connection file will be platform independent.

3.4. Edit Variable

With the Edit Variable button you can modify a variable content.

3.5. Up - Down

The Up or Down button lets you organize your classloader sequence.

3.6. Remove

With the Remove button, you can delete a classpath entry.