Note
	The CADENAS software required to use JDBC connections to the link database is license-bound and subject to a charge. You need an extra license (CNS2009*DATABASE*JDBC)!

	Note
	Advantage of using JDBC drivers: Driver installation and configuration is performed on the server! A driver installation on each client as with ODBC, is not necessary! When using the PARTapplicationServer, the advantage is relativized, as the driver is only set up on the server.

Note

JDBC driver Standard JDBC drivers can be found at libs/all/java/jar. Others must be downloaded from the respective manufacturer (Oracle, Microsoft) and copied to the directory libs/all/java/jar. They are NOT installed by CADENAS. Please download them under one of the following addresses. Oracle drivers: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html Microsoft SQL driver: sqljdbc_12.2\deu\mssql-jdbc-12.2.0.jre8.jar resp. sqljdbc_12.2\deu\mssql-jdbc-12.2.0.jre11.jar https://learn.microsoft.com/de-de/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16 Details can be found under Section 4.7.2, “ Database connection ”.

The configuration file jdbc.cfg stores the database connection data, i.e. server, database and, in particular, the driver class and the URL for the JDBC driver to establish the database connection.

# [PLINKDB]
#   #IP-adress or server name
# Server=
#   #Database name
# ServerDB=
#   #the jdbc driver class
# DriverClass=com.sap.dbtech.jdbc.DriverSapDB
#   #the complete URL for the jdbc driver
# URL=jdbc:sapdb://catia2.cadenas/PLINKDB

#Examples for different databases:
#---------------------------------

#MSSQL with JTDS
#[PLINKDB_MSSQLJDBC]
#Server=136.230.230.214
#ServerDB=DB-test
#DriverClass=net.sourceforge.jtds.jdbc.Driver
#URL=jdbc:jtds:sqlserver://136.230.230.214:1433/PLINKDB

#:HELP;MSSQL with sqljdbc 4.1. You can download the driver from the microsoft homepage. 
 section_75_1154427696031The file sqljdbc41.jar has to be copied into the folder software
 \libs\all\java\jar. The file sqljdbc_auth.dll has to be copied into the directory software\
 libs\x86\32\java\lib and software\libs\x86\64\java\lib
#[PLINKDB_MSSQLJDBC_41]
#Server=servername
#ServerDB=SQLEXPRESS
#DriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
#URL=jdbc:sqlserver://servername:1433;databaseName=plinkdb;integratedSecurity=true

#:HELP;Oracle You can download the driver from https://www.oracle.com/database/technologies
/appdev/jdbc-downloads.html. The jar file (f.e. ojdbc8.jar) has to be copied into the folder 
software\libs\all\java\jar.
#[PLINKDB_ORACLEJDBC]
#DriverClass=oracle.jdbc.driver.OracleDriver
#URL=jdbc:oracle:thin:@servername:1521/PLINKDB

#SAP-DB:
#[PLINKDB_SAPDBJDBC]
#DriverClass=com.sap.dbtech.jdbc.DriverSapDB
#URL=jdbc:sapdb://servername/PLINKDB

#:HELP;MySQL You can download the driver from mysql.com. The jar file (f.e. mysql-connector
 -java-8.0.17.jar) has to be copied into the folder software\libs\all\java\jar.
  
#[PLINKDB_MYSQLJDBC]
#DriverClass=com.mysql.jdbc.Driver
#URL=jdbc:mysql://servername:3306/PLINKDB

#Derby (local)    (Experimental!):
#[PLINKDB_DERBYJDBC]
#DriverClass=org.apache.derby.jdbc.EmbeddedDriver
#URL=jdbc:derby:C:\data\derby\plinkdb

#Derby (net)   (Experimental!):
#[PLINKDB_DERBYJDBC]
#DriverClass=org.apache.derby.jdbc.ClientDriver
#URL=jdbc:derby://localhost:1527/plinkdb

#SQ-Lite (pldbdemo)
[PLDBDEMO_SQLITEJDBC]
#:VALS_S
#:HELP;IP-adress or server name, on which the database is installed
Server=localhost
#:VALS_S
#:HELP;The instance name of the database. Oracle: SID
ServerDB=pldbdemo
#:VALS_S
#:HELP;The jdbc driver class.
DriverClass=SQLite.JDBCDriver
#:VALS_S
#:HELP;The complete URL for the jdbc driver.
Url=jdbc:sqlite:/$CADENAS_USER/sqlite/pldbdemo.db3