SQL Database

Provides detailed information for the SQL Database External Resource.

General Properties

This section defines the general properties for this External Resource:
Property Description
Name Defines the name of the external resource.
Type Specifies the type of external resource.
Supported Types Specifies the type of JDBC connection.

BEA DB2 Driver Properties

The BEA DB2 Driver supports the IBM DB2 versions 8.x and 9.x.

The following properties must be configured for a BEA DB2 driver under the Basic tab:
Property Description
Host Specifies the database server host.
Port Specifies the port of the database host.
User Defines user ID you want to use to connect to the database. This user must already exist in DB2 and have permissions to create the schema and tables used to store information.
Password Specifies password for the user.
Database Specifies the database you wish to connect to.
Schema Specifies the database schema to use. (optional)
URL Defines the URL for the database entry.
The following properties must be configured for a BEA DB2 driver under the Properties tab:
Property Description
   
   
The following properties must be configured for a BEA DB2 driver under the Runtime tab:
Property Description
Maximum Pool Size  
Maximum Connections Per User  
Connection Idle Time (minutes)  
Minimum Pool Size  
Maximum Opened Cursors  

BEA Informix Driver Properties

The BEA Informix database driver supports versions 9.2, 9.3, 9.4, and 10.

The following properties must be configured for a BEA Informix driver under the Basic tab:
Property Description
Host  
Port  
User  
Password  
Database  
Server  
URL  
The following properties must be configured for a BEA Informix driver under the Advanced tab:
Property Description
Root dbspace name  
The following properties must be configured for a BEA Informix driver under the Properties tab:
Property Description
   
The following properties must be configured for a BEA DB2 Driver under the Runtime tab:
Property Description
Maximum Pool Size  
Maximum Connections Per User  
Connection Idle Time (minutes)  
Minimum Pool Size  
Maximum Opened Cursors  

BEA SQL Server Driver Properties

The BEA SQL Server driver supports SQL Server version 2005.

The following properties must be configured for a BEA SQL Server driver under the Basic tab:
Property Description
Host  
Port  
User  
Password  
Database  
URL  
The following properties must be configured for a BEA SQL Server driver under the Properties tab:
Property Description
   
   
The following properties must be configured for a BEA SQL Server driver under the Runtime tab:
Property Description
Maximum Pool Size  
Maximum Connections Per User  
Connection Idle Time (minutes)  
Minimum Pool Size  
Maximum Opened Cursors  

BEA Oracle Driver Properties

The BEA Oracle database driver supports versions 9.2 and 10.

The following properties must be configured for a BEA Oracle driver under the Basic tab:
Property Description
Host  
Port  
User  
Password  
SID  
Schema (optional)  
URL  
The following properties must be configured for a BEA Oracle driver under the Advanced tab:
Property Description
Tablespace  
Temporary Tablespace  
Profile  
The following properties must be configured for a BEA Informix driver under the Properties tab:
Property Description
   
The following properties must be configured for a BEA DB2 Driver under the Runtime tab:
Property Description
Maximum Pool Size  
Maximum Connections Per User  
Connection Idle Time (minutes)  
Minimum Pool Size  
Maximum Opened Cursors  

BEA Sybase Driver Properties

The BEA Sybase Driver supports Sybase versions 11.x, 12.x and 15.

The following properties must be configured for a BEA DB2 driver under the Basic tab:
Property Description
Host  
Port  
User  
Password  
Database  
Device  
Allocation Size  
URL  
The following properties must be configured for a BEA DB2 driver under the Properties tab:
Property Description
   
   
The following properties must be configured for a BEA DB2 driver under the Runtime tab:
Property Description
Maximum Pool Size  
Maximum Connections Per User  
Connection Idle Time (minutes)  
Minimum Pool Size  
Maximum Opened Cursors  

BEA DB2 AS/400 JDBC Properties

The following properties must be configured for a BEA DB2 AS/400 JDBC driver under the Basic tab:
Property Description
Host  
Port  
User  
Password  
Database  
Schema  
URL  
The following properties must be configured for a BEA DB2 driver under the Properties tab:
Property Description
   
   
The following properties must be configured for a BEA DB2 driver under the Runtime tab:
Property Description
Maximum Pool Size  
Maximum Connections Per User  
Connection Idle Time (minutes)  
Minimum Pool Size  
Maximum Opened Cursors  

BEA DB2 OS390 Properties

The BEA DB2 Driver supports the IBM DB2 versions 8.x and 9.x.

The following properties must be configured for a BEA DB2 driver under the Basic tab:
Property Description
User  
Password  
Database  
Schema  
URL  
The following properties must be configured for a BEA DB2 OS390 driver under the Properties tab:
Property Description
   
   
The following properties must be configured for a BEA DB2 OS390 driver under the Runtime tab:
Property Description
Maximum Pool Size  
Maximum Connections Per User  
Connection Idle Time (minutes)  
Minimum Pool Size  
Maximum Opened Cursors  

Generic JDBC Version 1 Properties

The following properties must be configured for a Remote JDBC Connection under the Basic tab:
Property Description
JDBC Driver  
URL  
User  
Password  
The following properties must be configured for a Remote JDBC Connection under the Runtime tab:
Property Description
Maximum Pool Size  
Maximum Connections Per User  
Connection Idle Time (minutes)  
Minimum Pool Size  

Remote JDBC Properties

The following properties must be configured for a Remote JDBC Connection:
Property Description
Database Type  
J2EE  
Lookup Name  
Parent topic: External Resource Reference