Code Of The Day

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