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 Four

 

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

1. Embarcadero – InterBase – InterBase
   1. interbase.interclient.Driver
   2. JDBC URLs
      1. Absolute Path - jdbc:InterBase://servername//absolutePathToDatabase.ib
      2. Relative Path - jdbc:InterBase://servername/relativePathToDatabase.ib
   3. jdbc:InterBase://loopback/c:/interbas/examples/jupiter.ib
      1. Notice ‘loopback’ is used for local connections
   4. N/A
2. Microsoft – MS SQL Server – jTDS
   1. net.sourceforge.jtds.jdbc.Driver
   2. jdbc:jtds:sqlserver://<host>:<port>/<database_name>
   3. jdbc:jtds:sqlserver://127.0.0.1:1433/test
   4. 1433
3. Microsoft – MS SQL Server – MS SQL
   1. com.microsoft.sqlserver.jdbc.SQLServerDriver
   2. jdbc:sqlserver://<server_name>:<port>
   3. jdbc:sqlserver://neptune.acme.com:1433
   4. 1433
4. SAP – Sybase – jTDS
   1. net.sourceforge.jtds.jdbc.Driver
   2. jdbc:jtds:sybase://<host>[:<port>][/<database_name>]
   3. jdbc:jtds:sybase://127.0.0.1:5000/SAMPLE
   4. 7100 or 5000
5. SAP – Sybase – Sybase
   1. com.sybase.jdbc2.jdbc.SybDriver
   2. jdbc:sybase:Tds:<host>:<port>
   3. jdbc:sybase:Tds:127.0.0.1:7100
   4. 7100 or 5000
6. DynamoDB – LucidDB – LucidDB
   1. org.luciddb.jdbc.LucidDbClientDriver
   2. jdbc:luciddb:http://<server>[:<port>]
   3. jdbc:luciddb:http://localhost:8034
   4. 8034
7. SAP – MaxDB – MaxDB
   1. com.sap.dbtech.jdbc.DriverSapDB
   2. jdbc:sapdb://<server>[:<port>]/<databaseName>
   3. jdbc:sapdb://localhost:7210/sample
   4. 7210
8. Mckoi – Mckoi – Mackoi
   1. com.mckoi.JDBCDriver
   2. jdbc:mckoi://<server>[:<port>][/<schema>]/
   3. jdbc:mckoi://localhost:9157/test
   4. 9157
9. Mimer – Mimer – Mimer
   1. com.mimer.jdbc.Driver
   2. jdbc:mimer://<server>[:<port>]/<database>
   3. jdbc:mimer://localhost:1360/ExampleDB
   4. 1360
10. MonetDB – MonetDB – MonetDB
    1. nl.cwi.monetdb.jdbc.MonetDriver
    2. jdbc:monetdb://<server>[:<port>]/<database>
    3. jdbc:monetdb://monetdbserver:50000/test
    4. 50000