JDBC URL String Part Three

 

Please click here to read the introduction of the series of posts and the format being used.

1. InterSystems – Cache – Cache
   1. com.intersys.jdbc.CacheDriver
   2. jdbc:Cache://<server>[:<port>]/<namespace>
   3. jdbc:Cache://127.0.0.1:56772/Samples
   4. 56772
2. IBM – DB2 AS/400 – AS400
   1. com.ibm.as400.access.AS400JDBCDriver
   2. jdbc:as400://system-name/default-schema;properties
   3. jdbc:as400://mysystem.helloworld.com/mylibrary;naming=system;errors=full
   4. 446
3. IBM – DB2 Universal Database – DB2 Universal Database 
   1. Driver
      1. Type 2 & 4 - com.ibm.db2.jcc.DB2Driver
      2. App - COM.ibm.db2.jdbc.app.DB2Driver
      3. Net - COM.ibm.db2.jdbc.net.DB2Driver
   2. JDBC URLs
      1. Type 2 & App - jdbc:db2:<database_name>
      2. Type 4 & Net - jdbc:db2://<host>[:<port>]/<database_name>
   3. Examples
      1. Type 2 & App - jdbc:db2:test
      2. Type 4 & Net - jdbc:db2://127.0.0.1:50000/SAMPLE
   4. 50000 / 446 / 6789
4. FrontBase – FrontBase – FrontBase
   1. com.frontbase.jdbc.FBJDriver
   2. jdbc:FrontBase://<host>[:<port>]/<databaseName>[/var=value]*
   3. jdbc:FrontBase://localhost/sample
   4. ???
5. Apache – Hive – Hive
   1. org.apache.hadoop.hive.jdbc.HiveDriver
   2. jdbc:hive://<server>[:<port>]/default
   3. jdbc:hive://localhost:10000/default 
   4. 10000
6. HSQLDB – HSQLDB – HSQLDB
   1. org.hsqldb.jdbcDriver
   2. JDBC URLs
      1. Server - jdbc:hsqldb:hsql://<server>[:<port>]/<databaseName>
      2. Embedded Memory - jdbc:hsqldb:mem:<databaseName>
      3. Embedded File - jdbc:hsqldb:file:<database-file>
   3. jdbc:hsqldb:hsql://neptune.acme.com:9001
   4. 9001
7. IBM – Informix – Informix
   1. com.informix.jdbc.IfxDriver
   2. jdbc:informix-sqli://<server>[:<port>]/<databaseName>:informixserver=<dbservername>
   3. jdbc:informix-direct://testDB;user=rdtest;password=test
   4. 1533
8. Actian – Ingres – Ingres
   1. com.ingres.jdbc.IngresDriver
   2. jdbc:ingres://<server>:<instance-name>7/<databaseName>
   3. jdbc:ingres://localhost:II7/verde02 
   4. Port (3 chars: the two char Ingres Instance ID and the digit 7, e.g., II7)