Database URL Connection Strings

Documentation home

 

Apache Derby (Embedded). 1

Apache Derby (Network). 1

MySQL. 1

MS SQL Server 2

Oracle. 2

DB2. 2

MS Access. 2

Sybase. 3

Postgres. 3

 

See also: Database Connections

 

 

A URL connection string is used by a JDBC driver to make a connection to a database. If your database system is not included in the documentation below, then consult the documentation provided with your JDBC Driver.

Apache Derby (Embedded)

 

          jdbc:derby:database-location;create=false

         

          where:

         

database-location is the file system path name to the directory containing the Derby database, e.g c:\\Databases\\myDatabase

 

create=false is an additional parameter that determines whether to create the database if it does not exist.

e.g jdbc:derby:c:\\Databases\\UFS;create=false

 

Apache Derby (Network)

 

          jdbc:derby://hostname/database-name;create=false

         

          where:

         

hostname is the hostname of the database server

database-name is the name of the database within the database server system

 

create=false is an additional parameter that determines whether to create the database if it does not exist.

 

 

MySQL

 

jdbc:mysql://hostname/myDatabase?autoReconnect=true

 

where:

hostname is the hostname of the MySQL server

myDatabase is the database name

autoReconnect=true is an additional parameter that prevents the database from closing unused connections

 

e.g.      jdbc:mysql://localhost/ufs?autoReconnect=true

 

 

MS SQL Server

 

Please note that use of the Microsoft provided SQL Server JDBC driver is not recommended for use with Verj.io at this time. This documentation refers to the supplied JTDS driver.

 

Using the JTDS driver:

 

jdbc:jtds:sqlserver://hostname:1433/database

 

where:

hostname is the hostname of the SQL Server server system

database is the name of the database

 

e .g.     jdbc:jtds:sqlserver://ebt009:1433/mydb

 

Note: For SQL Server 6.5, parameter TDS=4.2 must be added e.g. jdbc:jtds:sqlserver://ebt009:1433/mydb;TDS=4.2

 

Oracle

 

jdbc:oracle:thin:@hostname:1521:SID

 

where:

hostname is the hostname of the Oracle server

SID is the Oracle system id

 

e.g.     jdbc:oracle:thin:@prod0097:1521:ORAPROD

 

 

DB2

 

jdbc:db2://hostname/database

 

where:

hostname is the hostname of the DB2 server system

database is the name of the database within the database server system

 

 

MS Access

 

Using the Jadozoom driver

 

Note: before connecting to MS Access using the Jadazoom driver, files izmjniado.dll and 11100319.LIC should be copied from the OptionalLibraries/jadozoom folder at the root of the Verj.io installation, and installed as dll files on the target Windows server (Copy the files to C:\Windows\System32 or equivalent, or copy them to C:\Program Files\infozoom). 

 

jdbc:izmado:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=pathname;IzmRoyaltyFree=643223965;IzmJdbcEsc=yes

 

pathname is the full path name to the mdb file containing the MS Access database on the server system

 

For an unsecured database:

 

            jdbc:izmado:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Databases\\northwinds.mdb;IzmJdbcEsc=yes;IzmRoyaltyFree=643223965

            (Note that userid Admin may be required on the datasource definition)

 

For a secured database:

 

jdbc:izmado:Provider=Microsoft.Jet.OLEDB.4.0; Data Source=//ebt008/Shared Area/Northwinds_sec.mdb;jet oledb:system database=//ebt008/Shared Area/secured.mdw;IzmRoyaltyFree=643223965;IzmJdbcEsc=yes

 

 

Sybase

 

Using the supplied JTDS driver.

 

jdbc:jtds:sybase://hostname:4000/database

 

where:

hostname is the hostname of the SQL Server server system

database is the name of the database

 

e .g.     jdbc:jtds:sybase://ebt009:4000/mydb;TDS=4.2

 

Postgres

 

jdbc:postgresql://hostname/database

 

where:

hostname is the hostname of the Postgres server system

database is the name of the database

 

e .g.     jdbc:postgresql://ebt009/mydb