The JDBC method getConnection(xxx) is used to make a connection to the JDBC data source. Several different getConnection() methods exist in JDBC. The URL remains constant in both of the methods, as this is where the driver- specific information is placed. The URL is concatenated with the following attributes:
Driver Identifier
For CONNX JDBC, the format is as follows:
jdbc:connx:
Database Identifier
For CONNX JDBC, this represents the symbolic name for the CDD registered
via the DSNRegistry tool. The format is as follows:
DD=Symbolic Name for Data Source
TCP/IP Address of Server
This is the TCP/IP address or host name of the server (or the CONNX
Router if a CONNX Router is required by your configuration). The format
is as follows:
GATEWAY=TCPIP address or hostname
of Server/Router
PORT (optional argument)
The CONNX JDBC server is bound to a specific port. The default is 7500,
but the server can be invoked with a different port. The client and
server must be in sync; if the server has a different port number,
then the URL must represent this by including the PORT option. The
format is as follows :
PORT=7510
SSL (optional argument)
If the JDBC server is configured for SSL connections, then the java
client must specify "ssl=true" in the connection string.
The format is as follows:
SSL=true
The example below demonstrates a getConnection call for CONNX based on the following criteria:
Server named Sparky
JDBC
Data Source called Payroll
connectionObj = DriverManager.getConnection
("jdbc:connx:DD=Payroll;Gateway=Sparky",
username, password);
ADADBIDLIST
(optional argument)
Allows dynamic rebinding of adabas DBIDs in the CONNX data dictionary.
This is useful if you have multiple Adabas databases with
identical structures, but different data. At connection time,
you can redirect one or more databases in the CDD to different adabas
DBIDs. It is the responsibility of the user to ensure that the
structure is the same between the database, otherwise error will occur
during query processing.
ADADBIDLIST=(<logicalCDDDatabaseName>:<new DBID>,<logicalCDDDatabaseName>:<new
DBID>,…)
Example: String
connString = "jdbc:connx:DSN=demo4adabas;GATEWAY=localhost;port=7502;USER=xxx;PASSWORD=xxx;ADADBIDLIST=(adatest:2,adalocal:1)";
Where adatest and adalocal are database cylinder names in the CDD for
the DSN demo4adabas.
Additionally - support for multiple JDBC Servers and/or Data servers has been added to the CDD server name fields and the JDBC connection string.
<servername>[:<port>][!<servername>[:<port>]][!<servername>[:<port>]]...
Note: Each instance of <servername>[:<port>] is spearated by an exclaimation (!) mark.
For example - if you have two JDBC servers set up for redundancy - one on a server called PRIMARY, listening on port 7323
and another server called SECONDARY, listening on port 8754, the gateway server name would be:
PRIMARY:7323!SECONDARY:8754
When a list of servers is provided - CONNX will initially pick one at random. If the connection fails for that server, it will then serially loop through
all the servers from that point forward, wrapping back around to the beginning if necessary, until all options are exhausted, or a successful connection is established.
Type the above criteria on the command line in your system or within the Java program code.
