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 One

 

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

1. 4D – 4D – 4D
   1. com.fourd.jdbc.DriverImpl
   2. jdbc:4d:ip-address
   3. jdbc:4d:127.0.0.1
2. Software AG – Adabas D – Adabas D
   1. de.sag.jdbc.adabasd.ADriver
   2. jdbc:adabasd://server-node[:port]/server-db
   3. jdbc:adabasd://localhost/mydb
3. Apache – Derby – Derby
   1. org.apache.derby.jdbc.EmbeddedDriver
   2. jdbc:derby:[subsubprotocol:][databaseName][;attribute=value]*
   3. jdbc:derby:sample
4. Teradata – Aster nCluster – Aster nCluster
   1. com.asterdata.ncluster.Driver
   2. jdbc:ncluster://{ip or name of server}:2406/{database name}
   3. jdbc:ncluster://localhost:2406/mydb
   4. 2406
5. Altibase – Altibase – Altibase
   1. Altibase.jdbc.driver.AltibaseDriver
   2. jdbc:Altibase://server_ip:server_port/dbname
   3. jdbc:Altibase://127.0.0.1:20300/mydb
6. CSQL – CSQL – CSQL
   1. csql.jdbc.JdbcSqlDriver
   2. JDBC URLs
      1. jdbc:csql
         Connect to database without network.
      2. jdbc: adapter
         Connect to database through adapter without network for any operation in target database
      3. jdbc:gateway
         Connect to database through gateway without network
      4. jdbc:csql://<Host Name>:<Port>/csql
         Connect to database with network
      5. jdbc:adapter://<Host Name>:<port>/csql
         Connect to database through adapter with network for any operation on target database
      6. jdbc:gateway://<Host Name>:<port>/csql
         Connect to database through gateway with network
7. CUBRID – CUBRID – CUBRID
   1. cubrid.jdbc.driver.CUBRIDDriver
   2. jdbc:cubrid:<host>:<port>:<db-name>:[user-id]:[password]:[?<property> [& <property>]]
   3. jdbc:CUBRID:192.168.0.1:33000:db1:::
   4. 33000
8. Daffodil – Daffodil DB – Daffodil DB
   1. Drivers
      1. in.co.daffodil.db.rmi.RmiDaffodilDBDriver
      2. in.co.daffodil.db.jdbc.DaffodilDBDriver
   2. JDBC URLs
      1. Server - jdbc:daffodilDB://<server>[:<port>]/<databaseName>
      2. Embedded - jdbc:daffodilDB_embedded:<databaseName>
   3. Examples
      1. Server – jdbc:daffodilDB://localhost:3456/mydb
      2. Embedded – jdbc:daffodilDB_embedded:mydb
   4. 3456