MashZone NextGen and MashZone Database Compatibility
MashZone NextGen has an internal database, the MashZone NextGen Repository. The Integrated MashZone Server for MashZone NextGen also has an internal database. Both of these repositories are installed in separate Derby databases that are configured as embedded databases running in the same JVM as MashZone NextGen and the Integrated MashZone Server.
Important: | TheMashZone NextGenRepository and MashZone Repository are initially installed in a Derby database suitable only for trial purposes. For proof-of-concept, development or production uses, move both these repositories to a robust and compatible solution. |
These repositories are compatible with the following databases and drivers:
Database / Driver | MashZone NextGen | MashZone |
Apache Derby 10.5.3 (embedded) derby-embedded-10.5.3.jar | | |
Microsoft SQL Server 2008 (10.00.2531) jtds-1.3.1.jar | | |
Microsoft SQL Server 2012 (11.0.2012) jtds-1.3.1.jar | | |
MySQL 5 mysql-connector-java-5.1.6-bin.jar | | |
MySQL 5.6.1 mysql-connector-java-5.1.6-bin.jar | | |
Oracle 11g (11.1.0.6) ojdbc16.jar Note: | Scripts are compatible with the Oracle SQL Plus client. |
| | |
Oracle 12c (12.1.0.6) ojdbc16.jar Note: | Scripts are compatible with the Oracle SQL Plus client. |
| | |
PostgreSQL 9.0 postgresql-9.0-801.jdbc3.jar | | |
PostgreSQL 9.3.1 postgresql-9.2-1002.jdbc4.jar | | |
Both MashZone NextGen and MashZone also work with databases making database assets visible in MashZone NextGen as mashable information sources or MashZone feeds. Database mashables have been tested with:
DB2 9.7.400.501 (
db2jcc.jar)
Microsoft SQL Server 2008 (
jtds-1.2.5.jar)
MySQL 5.x (
mysql-connector-java-5.1.6-bin.jar)
Oracle 11g (
ojdbc14.jar)
PostgreSQL 9 (
postgresql-9.0-801.jdbc3.jar)
