Sunday, 16 December 2012

JDBC URL String Part Two

 

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

  1. Oracle – Java DB – Java DB
    1. Drivers
      1. Embedded - org.apache.derby.jdbc.EmbeddedDriver
      2. Client/Server - org.apache.derby.jdbc.ClientDriver
    2. jdbc:derby:[subsubprotocol:][databaseName][;attribute=value]*
    3. Examples
      1. Embedded - jdbc:derby:sample
      2. Client/Server – jdbc:derby://localhost:1527/sample
  2. Empress – Empress – Empress
    1. Drivers
      1. JDBC Driver Category 2 - empress.jdbc.empressDriver
      2. JDBC Driver Category 3 - empress.jdbc.clientDriver
    2. JDBC URLs
      1. JDBC Driver Category 2 - jdbc:empress://subname
      2. JDBC Driver Category 3 - jdbc:empress://server:port/subname
  3. EnterpriseDB – EnterpriseDB – EnterpriseDB
    1. com.edb.Driver
    2. jdbc:edb://[host[:port]]/database
    3. jdbc:edb://localhost/edb
  4. FileMaker – FileMaker – SequeLink
    1. com.ddtek.jdbc.sequelink.SequeLinkDriver
    2. jdbc:<subprotocol>:<subname>
    3. jdbc:sequelink://17.184.17.170:2399
    4. 2399 (fixed, can not change)
  5. FireBird – FireBird – Firebird
    1. org.firebirdsql.jdbc.FBDriver
    2. JDBC URLs
      1. jdbc:firebirdsql:host[/port]:<path to db>?<properties>
      2. Native - jdbc:firebirdsql:native:host[/port]:<path to db>?<properties>
      3. Local - jdbc:firebirdsql:local:<absolute path to database>?<properties>
      4. Embedded - jdbc:firebirdsql:embedded:<path to database>?<properties>
      5. Embedded Server - jdbc:firebirdsql:embedded:host[/port]:<path to database>?<properties>
    3. jdbc:firebirdsql:localhost/3050:c:/db/employee.fdb
    4. 3050
  6. EMC – Greenplum – PostgresSQL
    1. org.postgresql.Driver
    2. jdbc:postgresql:[//host[:port]/]databasename
    3. jdbc:postgresql://localhost/testdb
  7. H2 – H2 – H2
    1. org.h2.Driver
    2. JDBC URLs
      1. Embedded
        1. jdbc:h2:~/test 'test' in the user home directory
        2. jdbc:h2:/data/test 'test' in the directory /data
        3. jdbc:h2:test in the current(!) working directory
      2. In-Memory
        1. jdbc:h2:mem:test multiple connections in one process
        2. jdbc:h2:mem: unnamed private; one connection
      3. Server Mode
        1. jdbc:h2:tcp://localhost/~/test user home dir
        2. jdbc:h2:tcp://localhost//data/test absolute dir
    3. Settings
      1. jdbc:h2:..;MODE=MySQL compatibility (or HSQLDB,...)
      2. jdbc:h2:..;TRACE_LEVEL_FILE=3 log to *.trace.db