Log out?

Database (SQL) Transport

The Database (SQL) Transport is used in the eiConsole and eiPlatform to connect to a relational database. As with all the components of the eiConsole, the user is presented with a graphical Interface with easy-to-configure panels.

Database SQL Transport Configuration Options in eiConsole

Transport (Adapter) Configuration Drop-Down List

Basic Database (SQL) Transport Configuration Options

On the Basic configuration tab, you can specify:

Basic Configuration Option in Database SQL Transport by PilotFish

Database (SQL) Transport Basic Configuration Options

Connection Database (SQL) Transport Configuration Options

On the Connection tab, specify connection information for the relational database that you wish to update with the following options:

 SQL Transport Connection Options

Database (SQL) Transport Connection Configuration Options

Advanced Database (SQL) Transport Configuration Option

On the Advanced tab, the following configuration options are available:

SQL Transport Advanced Configuration Options

Database (SQL) Transport Advanced Configuration Options (top half of screen)

Database SQL Transport Advanced Configuration

Database (SQL) Transport Advanced Configuration Options (bottom half of screen)

When the Database SQL Transport is executed, it executes what is called SQLXML. This is an XML syntax that is used to wrap SQL inserts, updates and control structures so that you can execute arbitrarily complex updates or queries against a relational database.

JDBC Properties Database (SQL) Transport Configuration Options

The JDBC Properties tab can be used to specify name/value pairs to the JDBC driver. The availability and behavior of these properties vary between drivers, so referring to a particular driver’s documentation is necessary to utilize specific properties.

JDBC Properties Configuration in SQL Transport

Database (SQL) Transport JDBC Properties Configuration Options

Pooling Database (SQL) Transport Configuration Options

The Polling tab can be used to specify the following options:

Database SQL Transport Pooling Configuration

Database (SQL) Transport Polling Configuration Options

Debug Database (SQL) Transport Configuration Options

The Debug tab can be used to specify:

SQL Database Transport Debug Configuration Options in eiConsole

Database (SQL) Transport Debug Configuration Options

Compatibility Database (SQL) Transport Configuration Options

The Compatibility tab can be used to specify the following option:

JDBC Parameter Typing Option in SQL Database Transport

Database (SQL) Transport Compatibility Configuration Options

When the Database (SQL) Transport is executed, it invokes what is called SQLXML. The details of SQLXML are covered in:

eiConsole SQLXML – Selecting Rows (Interface & Tutorial)
eiConsole SQLXML – Inserting and Updating Rows (Interface & Tutorial)

It should be noted that this is an XML syntax that is used to wrap SQL inserts, updates and control structures such that you can execute arbitrarily complex updates or queries against a relational database.

Transaction Isolation Database (SQL) Transport Configuration Options

The Transaction Isolation tab allows you to specify:

Transaction Isolation Options in PilotFish Middleware

Database (SQL) Transport Transaction Isolation Configuration Options

This is a unique website which will require a more modern browser to work! Please upgrade today!