Monday, 17 December 2012

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