View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005637 | SymmetricDS Pro | Improvement | public | 2022-12-15 20:34 | 2023-10-03 23:00 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.0 | Fixed in Version | 3.15.0 | ||
| Summary | 0005637: Set SET MODE LEGACY in db.init.sql for H2 databases in engines, remove DB_CLOSE_ON_EXIT from db URL if AUTO_SERVER also set | ||||
| Description | For each H2 data source, the db.url property in the engines file needs to have only one of DB_CLOSE_ON_EXIT and AUTO_SERVER set. If both are set, remove DB_CLOSE_ON_EXIT. For each H2 data source, let's set the SET MODE LEGACY on the db.init.sql property in the engines file to minimize the possibility that we are using functionality that was removed for H2 version 2. | ||||
| Tags | dialect: h2, install | ||||
| related to | 0005546 | closed | SymmetricDS | Add conversion tool for upgrading from H2 1.x to H2 2.x |
|
SymmetricDS: 3.15 aa564a65 2022-12-15 20:38:18 Details Diff |
0005637: Set SET MODE LEGACY in db.init.sql for H2 databases in engines, remove DB_CLOSE_ON_EXIT from db URL if AUTO_SERVER also set |
Affected Issues 0005637 |
|
| mod - symmetric-assemble/gradle.properties | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/util/BasicDataSourceFactory.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-12-15 20:34 | pmarzullo | New Issue | |
| 2022-12-15 20:34 | pmarzullo | Status | new => assigned |
| 2022-12-15 20:34 | pmarzullo | Assigned To | => pmarzullo |
| 2022-12-15 20:34 | pmarzullo | Tag Attached: dialect: h2 | |
| 2022-12-15 20:34 | pmarzullo | Tag Attached: install | |
| 2022-12-15 20:35 | pmarzullo | Summary | Set SET MODE LEGACY in db.init.sql for H2 databases in engines, remove DB_CLOSE_ON_EXIT from db URL is AUTO_SERVER also set => Set SET MODE LEGACY in db.init.sql for H2 databases in engines, remove DB_CLOSE_ON_EXIT from db URL if AUTO_SERVER also set |
| 2022-12-15 20:41 | pmarzullo | Status | assigned => resolved |
| 2022-12-15 20:41 | pmarzullo | Resolution | open => fixed |
| 2022-12-15 20:41 | pmarzullo | Fixed in Version | => 3.15.0 |
| 2022-12-16 15:19 | elong | Relationship added | related to 0005546 |
| 2023-10-01 23:46 | admin | Status | resolved => closed |
| 2023-10-03 23:00 | pmarzullo | Changeset attached | => SymmetricDS 3.15 aa564a65 |