MySQL database |
MySQL Database connection URL
dataSource.url=jdbc:mysql://<MySQL_HOST>:<MySQL_PORT>/<MySQL_DATABASE_NAME_FOR_ACTIVITYTIMELINE> dataSource.url=jdbc:mysql://127.0.0.1:3306/timeline?autoReconnect=true&autoreconnect=true&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8 |
MySQL Database username
dataSource.username=at_user |
MySQL Database password
dataSource.password=at_password |
Other properties
dataSource.pooled=true dataSource.driverClassName=com.mysql.jdbc.Driver dataSource.dbCreate=update # MySql 5.5, 5.6, 5.7: dataSource.dialect=com.timeline.hibernate.ActivityTimelineMySQLDialect # MySql 8.0+: # dataSource.dialect=com.timeline.hibernate.ActivityTimelineMySQL8Dialect |
Restart ActivityTimeline afterwards.
If you would like to migrate existing data from H2 database to MySQL, then you would need to use an external tools to migrate the database data like SQuirreL SQL with SQuirreL DB Copy Plugin (first you need to install SQuirreL SQL and on top of that the SQuirreL DB Copy Plugin). Also, you may need to start ActivityTimeline on an empty external database (schema) first for ActivityTimeline to create all required tables and relations. H2 database files are located at activitytimeline/bin/atdb folder. IMPORTANT: Upgrade to MySQL v8.0+ MySQL 8.0 and above have "lead", "rank" and few other words reserved and cannot be used as column names. As a result it is required to perform a specific procedure to upgrade MySQL to v8.0.
You should alter the MySQL 5.6/5.7 ActivityTimeline database schema before the upgrade to MySQL 8.0:
|
PostgreSQL database |
# PostgreSQL Database connection URL
dataSource.url=jdbc:postgresql://localhost:5432/timeline?autoReconnect=true&autoreconnect=true&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
# PostgreSQL Database username
dataSource.username=at_user
# PostgreSQL Database password
dataSource.password=at_password
# Other properties
dataSource.pooled=true
dataSource.driverClassName=org.postgresql.Driver
dataSource.dbCreate=update
.
If you would like to migrate existing data from H2 database to PostgreSQL, then you would need to use an external tools to migrate the database data like SQuirreL SQL with SQuirreL DB Copy Plugin (first you need to install SQuirreL SQL and on top of that the SQuirreL DB Copy Plugin). Also, you may need to start ActivityTimeline on an empty external database (schema) first for ActivityTimeline to create all required tables and relations. |
MS SQL Server database |
# MS SQL Server Database connection URL
# Structure: dataSource.url=jdbc:jtds:sqlserver://;serverName=<MSSQL_HOST>;portNumber=<MSSQL_PORT>;databaseName=<MSSQL_DATABASE_NAME_FOR_ACTIVITYTIMELINE>;integratedsecurity=false;socketTimeout=60000
dataSource.url=jdbc:sqlserver://;serverName=localhost;portNumber=1433;databaseName=timeline;integratedsecurity=false;socketTimeout=60000
# MSSQL Database username
dataSource.username=at_user
# MSSQL Database password
dataSource.password=at_password
# Other properties
dataSource.pooled=true
dataSource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
dataSource.dialect=com.timeline.hibernate.ActivityTimelineMSSqlServerDialect
dataSource.dbCreate=update
# -------------------------------------------------
# Or Alternative jTDS MSSQL driver
# Alternative MSSQL Database connection URL - jTDS driver
# Structure: dataSource.url=jdbc:jtds:sqlserver://<MSSQL_HOST>:<MSSQL_PORT>;databaseName=<MSSQL_DATABASE_NAME_FOR_ACTIVITYTIMELINE>
dataSource.url=jdbc:jtds:sqlserver://localhost:1433;databaseName=timeline
# MSSQL Database username
dataSource.username=at_user
# MSSQL Database password
dataSource.password=at_password
# Other properties
dataSource.pooled=true
dataSource.driverClassName=net.sourceforge.jtds.jdbc.Driver
dataSource.dialect=org.hibernate.dialect.SQLServerDialect
dataSource.dbCreate=update
If you would like to migrate existing data from H2 database to MSSQL, then you would need to use an external tools to migrate the database data like SQuirreL SQL with SQuirreL DB Copy Plugin (first you need to install SQuirreL SQL and on top of that the SQuirreL DB Copy Plugin). Also, you may need to start ActivityTimeline on an empty external database (schema) first for ActivityTimeline to create all required tables and relations. Also, please make sure all migrated table names are in lowercase letters e.g. "person", not "PERSON". All table names in UPPERCASE letters should be renamed to lowercase letters. |
Oracle database |
# Oracle Database connection URL
# Structure: dataSource.url=jdbc:oracle:thin:@//<ORACLE_DB_HOST>:<ORACLE_DB_PORT>/<SERVICE_NAME_FOR_ACTIVITYTIMELINE>
#dataSource.url=jdbc:oracle:thin:@//localhost:1521/timeline
# Oracle Database username
#dataSource.username=at_user
# Oracle Database password
#dataSource.password=at_password
# Other properties
#dataSource.pooled=true
#dataSource.driverClassName=oracle.jdbc.driver.OracleDriver
#dataSource.dialect=com.timeline.hibernate.ActivityTimelineOracleDialect
#dataSource.dbCreate=update
#dataSource.properties.validationQuery=SELECT 1 FROM DUAL
If you would like to migrate existing data from H2 database to Oracle DB, then you would need to use an external tools to migrate the database data like Oracle SQL Developer, SQuirreL SQL with SQuirreL DB Copy Plugin (first you need to install SQuirreL SQL and on top of that the SQuirreL DB Copy Plugin). Also, you may need to start ActivityTimeline on an empty external database (schema) first for ActivityTimeline to create all required tables and relations. It is required to enable "Extended Data Types" in Oracle DB for VARCHAR2 type to support up to 32767 bytes: https://docs.oracle.com/en/database/oracle/oracle-database/18/spuss/enabling-the-new-extended-data-type-capability.html Important Note for Oracle DB v12.2.0 and above switch: it is required to rename several entities before the migration for Oracle DB correct work:
Important Note for Oracle DB v12.1.0 switch: it is required to rename several additional entities before the migration for Oracle DB correct work:
dataSource.oracleLegacyMode=1
|