After installation, your database driver is ready for use.
For configuring the OpenLink Generic JDBC Driver, use the following parameters in the Connection URL:
Driver Name: opljdbc3.jar, megathin3.jar
Driver Class Name: openlink.jdbc3.Driver
Connection URL: jdbc:openlink://:[portnumber] [/UID] [/PWD] [/READONLY] [/SVT]
[/APPLICATION] [/FBS|FETCHBUFFERSIZE] [/ENCRYPTED] [/CHARSET] [/UNICODE]
[/DLF] [/DATABASE] [/OPTIONS] [/DRIVER]
Description of Parameters:
Hostname: Network Alias or IP address of the machine running the OpenLink Request Broker instance.
Port Number: TCP port on which the Request Broker listens.
/UID: Database username.
/PWD: Database password.
/READONLY: Read-write or read-only session mode.
/SVT: A valid domain alias from the [Domain Aliases] section of the OpenLink server component's oplrqb.ini file. Default domain aliases represent the type of database agent to which the application intends to connect.
/APPLICATION: The Application name to enable connectivity when restrictive server-side rules screen by application name.
/FBS (or /FETCHBUFFERSIZE): The Fetch Buffer Size representing the number of rows to return during one fetch operation.
/ENCRYPTED: Sets the Encrypted flag for outgoing packets. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
/CHARSET: Specifies the charset of remote databases. Default value is read from System.getProperty("file.encoding").
/UNICODE: Instantiates unicode. The unicode connection isn't used by default. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
/DLF: Pushes large, binary objects to the end of the resultset. Smaller data types are retrieved first, enhancing performance. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
/DATABASE: Actual database name within a particular database environment.
/OPTIONS: Optional parameter to pass specialized database native client connection parameters.
/DRIVER: The Driver name contained in curly brackets ({}). Used for DSN-Less connections to remote ODBC Drivers.
Examples of Connection URLs:
jdbc:openlink://localhost:5000/SVT=Ingres II/DATABASE=iidbdb/UID=ingres/PWD=ingres
jdbc:openlink://192.128.13.119:5000/SVT=Oracle 8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger
jdbc:openlink://saturn:5000/SVT=Progress 91D/DATABASE=isports/OPTIONS=-S isports -N tcp -H saturn
jdbc:openlink://localhost:5000/SVT=SQLServer 2000/DATABASE=Northwind/UID=sa/OPTIONS=-S SATURN
Attributes | Values |
---|
description
| - After installation, your database driver is ready for use.
For configuring the OpenLink Generic JDBC Driver, use the following parameters in the Connection URL:
Driver Name: opljdbc3.jar, megathin3.jar
Driver Class Name: openlink.jdbc3.Driver
Connection URL: jdbc:openlink://<Hostname>:[portnumber] [/UID] [/PWD] [/READONLY] [/SVT]
[/APPLICATION] [/FBS|FETCHBUFFERSIZE] [/ENCRYPTED] [/CHARSET] [/UNICODE]
[/DLF] [/DATABASE] [/OPTIONS] [/DRIVER]
Description of Parameters:
Hostname: Network Alias or IP address of the machine running the OpenLink Request Broker instance.
Port Number: TCP port on which the Request Broker listens.
/UID: Database username.
/PWD: Database password.
/READONLY: Read-write or read-only session mode.
/SVT: A valid domain alias from the [Domain Aliases] section of the OpenLink server component's oplrqb.ini file. Default domain aliases represent the type of database agent to which the application intends to connect.
/APPLICATION: The Application name to enable connectivity when restrictive server-side rules screen by application name.
/FBS (or /FETCHBUFFERSIZE): The Fetch Buffer Size representing the number of rows to return during one fetch operation.
/ENCRYPTED: Sets the Encrypted flag for outgoing packets. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
/CHARSET: Specifies the charset of remote databases. Default value is read from System.getProperty("file.encoding").
/UNICODE: Instantiates unicode. The unicode connection isn't used by default. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
/DLF: Pushes large, binary objects to the end of the resultset. Smaller data types are retrieved first, enhancing performance. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
/DATABASE: Actual database name within a particular database environment.
/OPTIONS: Optional parameter to pass specialized database native client connection parameters.
/DRIVER: The Driver name contained in curly brackets ({}). Used for DSN-Less connections to remote ODBC Drivers.
Examples of Connection URLs:
jdbc:openlink://localhost:5000/SVT=Ingres II/DATABASE=iidbdb/UID=ingres/PWD=ingres
jdbc:openlink://192.128.13.119:5000/SVT=Oracle 8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger
jdbc:openlink://saturn:5000/SVT=Progress 91D/DATABASE=isports/OPTIONS=-S isports -N tcp -H saturn
jdbc:openlink://localhost:5000/SVT=SQLServer 2000/DATABASE=Northwind/UID=sa/OPTIONS=-S SATURN
|
described by
| |
title
| |
type
| |
position
| |
is topic
of | |
is schema:step
of | |
Faceted Search & Find service v1.17_git122 as of Jan 03 2023
OpenLink Virtuoso version 08.03.3330 as of Apr 5 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 23 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software