Monday, 17 December 2012

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