EGL Reference Guide for iSeries
The build descriptor option sqlValidationConnectionURL specifies a
URL for connecting to the database that EGL uses to validate SQL statements at
generation time. Database access is through JDBC.
No default is available for the URL, and the format varies by driver:
- For IBM DB2 APP DRIVER for Windows, the URL is as follows--
jdbc:db2:dbName
- dbName
- Database name
- For the Oracle JDBC thin client-side driver, the URL varies by database
location. If the database is local to your machine, the URL is as
follows--
jdbc:oracle:thin:dbName
If the database is on a remote server, the URL is as follows--
jdbc:oracle:thin:@host:port:dbName
- host
- Host name of the database server
- port
- Port number
- dbName
- Database name
- For the IBM Informix JDBC driver, the URL is as follows (with the lines
combined into one)--
jdbc:informix-sqli://host:port
/dbName:informixserver=servername;
user=userName;password=passWord
- host
- Name of the machine on which the database server resides
- port
- Port number
- dbName
- Database name
- serverName
- Name of the database server
- userName
- Informix user ID
- passWord
- Password associated with the user ID
- For other drivers, refer to the documentation for the driver.
Related reference
Build descriptor options
Informix and EGL
sqlDB
sqlID
sqlPassword
sqlJDBCDriverClass
validateSQLStatements
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.