Presto and MashZone Database Compatibility
Presto has an internal database, the Presto Repository. The Integrated MashZone Server for Presto 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 Presto and the Integrated MashZone Server.
Important: | The Presto Repository 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 | Presto | 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 Presto and MashZone also work with databases making database assets visible in Presto 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)
