Difference between revisions of "JDBC: Connection URL Format"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (6 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ==Standard format== | |
| − | + | ||
| − | + | ||
| − | + | ||
<code lang="java"> | <code lang="java"> | ||
| Line 27: | Line 24: | ||
| − | + | ==Alternative standard format== | |
<code lang="java"> | <code lang="java"> | ||
| Line 52: | Line 49: | ||
| − | + | ==Extended format== | |
| − | The extended format provides logging and encryption capabilities. If ENCRYPTION is set to 'true', the username and password information is transmitted in DES3 encrypted format. The extended format also provides gateway connectivity to the following data sources. Please note this may require the purchase of additional license options. | + | The extended format provides logging and encryption capabilities. If ENCRYPTION is set to 'true', the username and password information is transmitted in DES3 encrypted format. |
| + | |||
| + | The extended format also provides gateway connectivity to the following data sources. Please note this may require the purchase of additional license options. | ||
* ODBC data sources | * ODBC data sources | ||
| Line 89: | Line 88: | ||
"LOGGING=logging;" + | "LOGGING=logging;" + | ||
"LOGFILE=logfile;" + | "LOGFILE=logfile;" + | ||
| − | "ENCRYPTION= | + | "ENCRYPTION=true/false;" + |
| − | "GATEWAY=odbc: | + | "GATEWAY=odbc:datasource"; |
</code> | </code> | ||
| Line 100: | Line 99: | ||
'?' connects to the local machine. | '?' connects to the local machine. | ||
|- | |- | ||
| − | |directory||The startup directory on the server. To access tables in other directories and associate single index files with their table, a sysodbc.ini file is required | + | |directory||The startup directory on the server. To access tables in other directories and associate single index files with their table, a [[Configuration Files|sysodbc.ini]] file is required. |
|- | |- | ||
|username||Database Server Login username. | |username||Database Server Login username. | ||
| Line 128: | Line 127: | ||
|} | |} | ||
| − | + | ||
| + | ====Encryption==== | ||
| + | If ENCRYPTION is set to true, the corresponding Database Server must be configured to expect encrypted username and password information. Please see [[DB_ENCRYPTION]] for more information. | ||
Latest revision as of 15:16, 26 March 2009
Standard format
String url = "jdbc:Recital:" + "SERVERNAME=servername;" + "DIRECTORY=directory;" + "USERNAME=username;" + "PASSWORD=password";
| Parameter | Description |
|---|---|
| servername | The IP address of the Database Server. '?' connects to the local machine. |
| directory | The startup directory on the server. NOTE: For Windows paths the '\' should be doubled e.g. C:\\Program Files\\Recital\\UAS\\data\\southwind |
| username | Database Server Login username. |
| password | Database Server Login password. |
Alternative standard format
String url = "jdbc:Recital:" + "SERVERNAME=servername;" + "DATABASE=database;" + "USERNAME=username;" + "PASSWORD=password";
| Parameter | Description |
|---|---|
| servername | The IP address of the Database Server. '?' connects to the local machine. |
| database | The database on the server. Databases in Recital are implemented as directories containing files that correspond to the tables in the database. The directory is a sub-directory of the Recital data directory. The environment variable / symbol DB_DATADIR points to the current Recital data directory. The database catalog can contain information about a table's associated index files (single .ndx files and tagged .dbx files). It also contains path information, which allows tables in other directories to be accessed. |
| username | Database Server Login username. |
| password | Database Server Login password. |
Extended format
The extended format provides logging and encryption capabilities. If ENCRYPTION is set to 'true', the username and password information is transmitted in DES3 encrypted format.
The extended format also provides gateway connectivity to the following data sources. Please note this may require the purchase of additional license options.
- ODBC data sources
- Oracle
- Informix
- Ingres
- Remote Recital
- MySQL
- PostgreSQL
String url = "jdbc:Recital:" + "SERVERNAME= servername;" + "DIRECTORY=directory;" + "USERNAME= username;" + "PASSWORD= password;" + "LOGGING=logging;" + "LOGFILE=logfile;" + "ENCRYPTION=true/false;" + "GATEWAY=type@node:dbms_username/dbms_password-database.protocol";
or
String url = "jdbc:Recital:" + "SERVERNAME= servername;" + "DIRECTORY=directory;" + "USERNAME=username;" + "PASSWORD=password;" + "LOGGING=logging;" + "LOGFILE=logfile;" + "ENCRYPTION=true/false;" + "GATEWAY=odbc:datasource";
| Parameter | Description |
|---|---|
| servername | The IP address of the Database Server.
'?' connects to the local machine. |
| directory | The startup directory on the server. To access tables in other directories and associate single index files with their table, a sysodbc.ini file is required. |
| username | Database Server Login username. |
| password | Database Server Login password. |
| logging | Set to true or false to turn logging on or off. |
| logfile | The name of the file to log to. |
| gateway | Gateway definition. |
| datasource | ODBC datasource (DSN). |
| type | Gateway type: ora; inf; ing; odb; rec; mys; pos |
| node | The IP address (or hostname) of the data server. |
| dbms_username | The username for the data source, e.g. if connecting to Oracle, this must be the name of a valid Oracle user. |
| dbms_password | The password for the dbms_username above. |
| database | The database to connect to. |
| protocol | The network protocol, decnet (DECNET) or tcpip (TCP/IP). If the protocol is not specified, TCP/IP is assumed on Unix/Linux and DECNET on OpenVMS. |
Encryption
If ENCRYPTION is set to true, the corresponding Database Server must be configured to expect encrypted username and password information. Please see DB_ENCRYPTION for more information.
