Difference between revisions of "JDBC: Connection URL Format"

From Recital Documentation Wiki
Jump to: navigation, search
 
(3 intermediate revisions by one user not shown)
Line 51: Line 51:
 
==Extended format==
 
==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 86: Line 88:
 
"LOGGING=logging;" +
 
"LOGGING=logging;" +
 
"LOGFILE=logfile;" +
 
"LOGFILE=logfile;" +
"ENCRYPTION=''true/false;" +
+
"ENCRYPTION=true/false;" +
"GATEWAY=odbc:''datasource";
+
"GATEWAY=odbc:datasource";
 
</code>
 
</code>
  
Line 97: 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. Please see the Database Server Installation and Configuration Guide for information on sysodbc.ini files.
+
|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 126: Line 128:
  
  
NOTE: 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.
+
====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.