JDBC URL String Part Five

 

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

1. Oracle – MySQL – ConnectorJ
   1. com.mysql.jdbc.Driver
   2. jdbc:mysql://<hostname>[,<failoverhost>][:<port>]/<dbname>[?<URL attribute>=<value>]*
   3. jdbc:mysql://localhost:3306/testdb
   4. 3306
2. HP – NeoView – HPT4 
   1. com.hp.t4jdbc.HPT4Driver
   2. jdbc:hpt4jdbc://ip_addr_or_host_name:18650/[:][property=value[;property2=value2]...]
   3. jdbc:hpt4jdbc://primary_IP_addr_on_Neoview_DB:18650/
   4. 18650
3. IBM – Netezza – Netezza
   1. org.netezza.Driver
   2. jdbc:netezza://<server>[:<port>]/<database>
   3. jdbc:netezza://netezzaserver:5480/sample
   4. 5480
4. OpenBase – OpenBase – OpenBase
   1. com.openbase.jdbc.ObDriver
   2. jdbc:openbase://<server>/<databaseName>
   3. jdbc:openbase://localhost/petstore
   4. ???
5. Oracle – Oracle – Oracle
   1. oracle.jdbc.driver.OracleDriver
   2. JDBC URLs
      1. Thin with Service Name - jdbc:oracle:thin:@//<host>:<port>/<service_name>
      2. Thin with SID - jdbc:oracle:thin:@<host>:<port>:<SID>
      3. Thin with TNS - jdbc:oracle:thin:@<TNSName> 
      4. OCI - jdbc:oracle:oci:@<database_name>
   3. Examples
      1. Thin with Service Name - jdbc:oracle:thin:@//192.168.2.1:1521/XE
      2. Thin with SID - jdbc:oracle:thin:192.168.2.1:1521:X01A
      3. Thin with TNS - jdbc:oracle:thin:@GL
      4. OCI - jdbc:oracle:oci:@HR
   4. 1521
6. Pervasive – Pervasive – Pervasive
   1. com.pervasive.jdbc.v2.Driver
   2. jdbc:pervasive://<server>[:<port>]/<datasource>
   3. jdbc:pervasive://127.0.0.1:1583/sys
   4. 1583
7. PostgreSQL – PostgreSQL – PostgreSQL
   1. org.postgresql.Driver
   2. jdbc:postgresql://<server>[:<port>]/<databaseName>
   3. jdbc:postgresql://localhost:5342/pgdb
   4. 5342

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)