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