Changes between Version 1 and Version 2 of Petascope_9.5


Ignore:
Timestamp:
Jul 3, 2017 9:30:37 AM (3 months ago)
Author:
bphamhuu
Comment:

First documentation

Legend:

Unmodified
Added
Removed
Modified
  • Petascope_9.5

    v1 v2  
    1 Test
     1= Description about Petacope version 9.5
     2
     3In Petascope version 9.5, it will use Spring Boot Framework with Hibernate as object relational mapping data model and implemented the Coverage Schema Implementation (CIS version 1.1) for GridCoverage, RectifiedGridCoverage and ReferenceableGridCoverage. This brings 2 big advantages:
     4 * Petascope can be deployed on more Relational Database beside Postgresql like MySQL, Oracle, DB2, HSQLDB, H2,...With the help of Liquibase as data migration tool from petascopedb database in Postgresql to new database name: petascopedb_cis in Postgresql. By default, Postgresql is still the most stable database to support to deploy database for Petascope, but user can switch to other Relational Database easily by changing the configuration in petascope.properties (see [#list_jdbc list of tested JDBC for other Relation Databases]).
     5 * Petasope's features can be implemented quickly with all the supports from Spring Boot Framework, such as: Petascope now can start as an embedded web application (i.e: no need to deploy to Tomcat web container) without the external embedded Jetty server as before by replacing with internal embedded Tomcat.
     6
     7= Change in new petascope.properties configuration file
     8
     9Below is the change for the new petascope.properties in version 9.5 which user need to take care:
     10 * The most important thing is new JDBC database connection to Relational Database which will need to adapt by user's preference. By default, it is used with Postgresql:
     11
     12{{{
     13spring.datasource.url=jdbc:postgresql://localhost:5432/petascopedb_cis
     14spring.datasource.username=petauser
     15spring.datasource.password=petapasswd
     16spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
     17}}}
     18The configurations for old petascopedb in prior version 9.5 is kept without any change:
     19
     20{{{
     21metadata_url=jdbc:postgresql://localhost:5432/petascopedb
     22metadata_user=petauser
     23metadata_pass=petapasswd
     24}}}
     25
     26 * If you are using old Petascope with embedded Jetty, there is one change for the port of embedded server:
     27
     28{{{
     29 from jetty_port=8080 to server.port=8080
     30}}}
     31
     32
     33There will have a need to migrate from old petascopedb to new petascopedb_cis if you are using Rasdaman with java and imported some coverages by WCST_Import. This will be done with a migration script (@TODO: describe the script after the discussion is done).
     34
     35
     36= List of tested JDBC configuration for Relation databases [=#list_jdbc]
     37
     38{{{
     39
     40# Postgresql (created by default)
     41spring.datasource.url=jdbc:postgresql://localhost:5432/petascopedb_cis
     42#spring.datasource.username=petauser
     43#spring.datasource.password=petapasswd
     44#spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
     45
     46# Mysql (username, password from user)
     47#spring.datasource.url=jdbc:mysql://localhost:3306/petascopedb_cis?createDatabaseIfNotExist=true
     48#spring.datasource.username=root
     49#spring.datasource.password=abc!123!ABC!123
     50#spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect
     51
     52# HSQLDB (username, password from user)
     53spring.datasource.url=jdbc:hsqldb:file://home/rasdaman/petascopedb_cis.db
     54spring.datasource.username=sa
     55spring.datasource.password=
     56
     57# H2 (username, password from user)
     58spring.datasource.url=jdbc:h2:file://home/rasdaman/petascopedb_cis.db;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1
     59spring.datasource.username=sa
     60spring.datasource.password=
     61spring.h2.console.enabled=true
     62}}}
     63
     64
     65
     66