DbSchema is connecting to Ingres using JDBC Drivers.
What are JDBC Drivers?
JDBC drivers are Java library files with the extension '.jar', used by Java applications to connect to the database.
Usually they are provided by the same company which developed the database software.
DbSchema is an Ingres Client which already includes
the Ingres JDBC driver. DbSchema can configure the Ingres JDBC URL and test the connectivity.
What is the JDBC URL?
The URL is a string (text) with a specific format containing information about the host where the database is running, the port, username, database name, etc.
The URL format is specific to each driver.
Any wrong character in the URL may make the database connectivity fail.
Therefore we recommend installing DbSchema and try to get connected, and you will find the JDBC URL in the connection dialog.
Ingres JDBC Driver
- Required File(s): iijdbc.jar
- Java Driver Class: com.ingres.jdbc.IngresDriver
- URL: jdbc:ingres://HOST:PARAM/DB;user=USER;password=PASSWORD;
To this URL you can add further connection parameters ( timestamp, date format or money format ).
For this use the manual URL configuration in the DbSchema Connection Dialog.
Sample: ;TZ=EUROPE-CENTRAL;DATE_FMT=GERMAN;DECIMAL=.;MNY_FMT=L:$
- Website: Ingres
Download Ingres JDBC Driver
The driver files are compressed in a zip file.
for any issues with the driver, you can write to us.