JDBC URL String Part Six

 

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

1. SAP – SAP DB – SAP DB
   1. com.sap.dbtech.jdbc.DriverSapDB
   2. jdbc:sapdb://<server>/<database_name>
   3. jdbc:sapdb://localhost/test
   4. ???
2. Xerial – SQLite – SQLite
   1. org.sqlite.JDBC
   2. jdbc:sqlite:<filename.db>
   3. jdbc:sqlite:sample.db
   4. ???
3. SAP – SQL AnyWhere – SQL AnyWhere
   1. Drivers
      1. 9.0.2 - ianywhere.ml.jdbcodbc.IDriver
      2. 10.0.0 / 10.0.1 / 11.0.0 - ianywhere.ml.jdbcodbc.jdbc3.IDriver
      3. 11.0.1 - sybase.jdbc.sqlanywhere.IDriver
      4. 12.0.0 - no longer required for JDBC 4.0
   2. JDBC URLs
      1. 9.0.2 - jdbc:odbc:Driver=Adaptive Server Anywhere 9.0;UID=DBA;PWD=sql;eng=demo
      2. 10.0.0 - jdbc:odbc:Driver=SQL Anywhere 10 Demo;UID=DBA;PWD=sql;eng=demo
      3. 10.0.1 - jdbc:ianywhere:Driver=SQL Anywhere 10;DSN=SQL Anywhere 10 Sample
      4. 11.0.0 - jdbc:ianywhere:Driver=SQL Anywhere 10;DSN= SQL Anywhere 11 Sample
      5. 11.0.1 / 12.0.0 - jdbc:sqlanywhere:uid=DBA;pwd=sql;eng=demo
   3. Examples
      1. 9.0.2 - jdbc:odbc:Driver=Adaptive Server Anywhere 9.0;UID=DBA;PWD=sql;eng=demo
      2. 10.0.0 - jdbc:odbc:Driver=SQL Anywhere 10 Demo;UID=DBA;PWD=sql;eng=demo
      3. 10.0.1 - jdbc:ianywhere:Driver=SQL Anywhere 10;DSN=SQL Anywhere 10 Sample
      4. 11.0.0 - jdbc:ianywhere:Driver=SQL Anywhere 10;DSN= SQL Anywhere 11 Sample
      5. 11.0.1 / 12.0.0 - jdbc:sqlanywhere:uid=DBA;pwd=sql;eng=demo
   4. 2638
4. SmallSQL – SmallSQL – SmallSQL
   1. smallsql.database.SSDriver
   2. jdbc:smallsql:databaseName[?URL attribute=value[URLattribute=value]*]
   3. jdbc:smallsql:MyDb?create=true 
   4. ???
5. Teradata – Teradata – Teradata
   1. com.teradata.jdbc.TeraDriver
   2. JDBC URLs
      1. Type 3 - jdbc:teradata://host:port/DatabaseServerName
      2. Type 4 - jdbc:teradata://DatabaseServerName
   3. Examples
      1. Type 3 - jdbc:teradata://localhost/test
      2. Type 4 – jdbc:teradata://test
   4. ???
6. HP – Vertica – Vertica
   1. com.vertica.Driver
   2. jdbc:vertica://<server>[:<port>]/<databaseName>
   3. jdbc:vertica://127.0.0.1:5433/sample
   4. 5433

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