Note
	The use of JDBC connections to the link database CADENAS software is license bound and requires a fee. You need an extra license (CNS2009*DATABASE*JDBC)!

	Note
	Advantage of the 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 a PARTapplicationServer, the advantage an advantage is relative, because the driver has only to be installed on the server.

Note

JDBC driver Standard JDBC driver can be found under libs/all/java/jar. Others have to be downloaded directly at the respective supplier (Oracle, Microsoft) and the copied into the directory libs/all/java/jar.They are not installed by CADENAS. Please download them under one of the following addresses. Oracle driver: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html Microsoft SQL driver: sqljdbc_12.2\deu\mssql-jdbc-12.2.0.jre8.jar bzw. 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 on this can be found under Section 4.7.2, “ Database connection ”.

The configuration file jdbc.cfg saves the database connection data, meaning that server, database and in particulrard.h. Server, database and in particular the driver class and the URL for the JDBC driver to establish the 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