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