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