Sunday, 16 December 2012

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)