Saturday, 15 December 2012

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