Element "RelDBConnection"

RelDBConnection element is used to define JDBC connections in global configuration. The connections defined with this element can later be used by the other elements of the components in the pages.

Properties
 

JNDI Datasource Name (Accept MScript)

If your J2EE environment is configured to provide JNDI datasources you can give the name of the JNDI datasource name in this property and ignore JDBC Driver, Database URL properties.

If you specify the this property and also JDBC Driver and Database URL then RelDB component will first try to get a connection using the JNDI Datasource name; It it fails it will try to get the connection from the Driver Manager using the JDBC Driver and the Database URL.

JDBC Driver (Accept MScript)

Specify the name of the driver here. Most of the databases have native JDBC drivers. The ones that do not have a native JDBC driver can still be accessed using a JDBC ODBC bridge.

The standard JDBC ODBC driver and native JDBC drivers for Apache Derby, MS SQL Server, Postgre SQL and DB2 databases are shipped with MoreMotion Application Studio.

To introduce a new JDBC driver, place its jar file under directory:
 {INSTALL_DIR}lib\cpn\mor\RelDB\drivers

If you want that the driver name and the database url values can be defined by selection from the property combo boxes make necessary definitions in file.
 {INSTALL_DIR}lib\cpn\mor\RelDB\RelDBConnection.mmel

MySQL JDBC Driver

The JDBC driver (Connector/J JDBC) suitable with the MySQL database version you're using can be downloaded from the MySQL web site.

Example:

Download the mysql-connector-java-5.0.8.zip file from the address http://dev.mysql.com/downloads/connector/j/5.0.html and place it under the
{INSTALL_DIR}lib\cpn\mor\RelDB\drivers directory.

 
Oracle JDBC Driver

First of all you need to obtain the Oracle JDBC Driver file classes??.jar. You can either download it from the Oracle web site or you can copy it from the Oracle installation if you have any.

Usually this file exists under {ORACLE_INSTALL_DIR}\*\jdbc\lib directory.

Again place the Oracle JDBC driver file into {INSTALL_DIR}lib\cpn\mor\RelDB\drivers directory.

Database URL (Accepts MScript)

The database URL template that is compatible with the JDBC driver. You should change the database name and server computer name (or IP address) as necessary

Jar Files

The jar files or the driver. Choose the option that has the same number as the Driver and Database URL.

User Name (Accepts MScript)

The user name that has authority to connect to the database.

Password (Accepts MScript)

Login password for the user. The password entered into this property is immediately encrypted in order make it unreadable.

Auto Commit (Accepts MScript)

Flag to set auto commit to on (true) of off (false).

First SQL (Accepts MScript)

The first SQL statement to be executed as soon as the connection is established.

Last SQL (Accepts MScript)

The last SQL statement to be executed before the connection is closed.