JDBC URL String Part Seven

 

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

1. Oracle – PointBase – PointBase
   1. Drivers
      1. Universal - com.pointbase.jdbc.jdbcUniversalDriver
      2. Net - com.pointbase.net.netJDBCDriver
   2. JDBC URLs
      1. Server - jdbc:pointbase:server://<host>/<database_name>
      2. Embedded – jdbc:pointbase:embedded:<database_name>
   3. Examples
      1. Server - jdbc:pointbase:server//127.0.0.1/PBPUBLIC
      2. Embedded - jdbc:pointbase:embedded:sample
   4. ???
2. Oracle – PointBase Micro – PointBase ME
   1. com.pointbase.me.jdbc.jdbcDriver
   2. jdbc:pointbase:micro:<db_name>
   3. jdbc:pointbase:micro:medb
   4. ???
3. ??? – DaffodilDB Embedded – DaffodilDB
   1. in.co.daffodil.db.jdbc.DaffodilDBDriver
   2. jdbc:daffodilDB_embedded:<database>
   3. jdbc:daffodilDB_embedded:LPX
   4. ???
4. ??? – DaffodilDB Server – DaffodilDB
   1. in.co.daffodil.db.rmi.RmiDaffodilDBDriver
   2. jdbc:daffodilDB://<host>:<port3456>/<database>
   3. jdbc:daffodilDB://localhost:3456/testdb
   4. 3456

JDBC URL String Part Three

 

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

1. InterSystems – Cache – Cache
   1. com.intersys.jdbc.CacheDriver
   2. jdbc:Cache://<server>[:<port>]/<namespace>
   3. jdbc:Cache://127.0.0.1:56772/Samples
   4. 56772
2. IBM – DB2 AS/400 – AS400
   1. com.ibm.as400.access.AS400JDBCDriver
   2. jdbc:as400://system-name/default-schema;properties
   3. jdbc:as400://mysystem.helloworld.com/mylibrary;naming=system;errors=full
   4. 446
3. IBM – DB2 Universal Database – DB2 Universal Database 
   1. Driver
      1. Type 2 & 4 - com.ibm.db2.jcc.DB2Driver
      2. App - COM.ibm.db2.jdbc.app.DB2Driver
      3. Net - COM.ibm.db2.jdbc.net.DB2Driver
   2. JDBC URLs
      1. Type 2 & App - jdbc:db2:<database_name>
      2. Type 4 & Net - jdbc:db2://<host>[:<port>]/<database_name>
   3. Examples
      1. Type 2 & App - jdbc:db2:test
      2. Type 4 & Net - jdbc:db2://127.0.0.1:50000/SAMPLE
   4. 50000 / 446 / 6789
4. FrontBase – FrontBase – FrontBase
   1. com.frontbase.jdbc.FBJDriver
   2. jdbc:FrontBase://<host>[:<port>]/<databaseName>[/var=value]*
   3. jdbc:FrontBase://localhost/sample
   4. ???
5. Apache – Hive – Hive
   1. org.apache.hadoop.hive.jdbc.HiveDriver
   2. jdbc:hive://<server>[:<port>]/default
   3. jdbc:hive://localhost:10000/default 
   4. 10000
6. HSQLDB – HSQLDB – HSQLDB
   1. org.hsqldb.jdbcDriver
   2. JDBC URLs
      1. Server - jdbc:hsqldb:hsql://<server>[:<port>]/<databaseName>
      2. Embedded Memory - jdbc:hsqldb:mem:<databaseName>
      3. Embedded File - jdbc:hsqldb:file:<database-file>
   3. jdbc:hsqldb:hsql://neptune.acme.com:9001
   4. 9001
7. IBM – Informix – Informix
   1. com.informix.jdbc.IfxDriver
   2. jdbc:informix-sqli://<server>[:<port>]/<databaseName>:informixserver=<dbservername>
   3. jdbc:informix-direct://testDB;user=rdtest;password=test
   4. 1533
8. Actian – Ingres – Ingres
   1. com.ingres.jdbc.IngresDriver
   2. jdbc:ingres://<server>:<instance-name>7/<databaseName>
   3. jdbc:ingres://localhost:II7/verde02 
   4. Port (3 chars: the two char Ingres Instance ID and the digit 7, e.g., II7)

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