| Re: [cargotracker-dev] HyperSQL DB and H2 testing |
_______________________________________________Yes, totally fine to remove the comment.
You can definitely use this branch for Liberty: https://github.com/eclipse-ee4j/cargotracker/tree/liberty-experimental. We have a similar one for WildFly for similar reasons.
I appreciate all your work!
On 6/21/2022 5:55 PM, Chanun Ong wrote:
Hi Reza,
I actually noticed that the comment was causing the issue with HSQLDB, so removing the "-- It's OK for this to fail if the record already exists." comment ended up resolving the error message. Do you think submitting a PR to remove the comment so that HSQLDB can run the app makes sense?
With regards to the future steps with OL, I was wondering if you would be comfortable making a branch dedicated to OL that's independent from the master branch since I do have a working version with OL (pending the SSE issue). I'd be able to push my updates to that branch without interfering with the rest of the project as a temporary fix until the migration to EE 9 happens. Let me know what you think.
Best,
Chanun
On Tue, Jun 21, 2022 at 1:09 PM Reza Rahman <reza_rahman@xxxxxxxxx> wrote:
_______________________________________________Have you figured out what the exact issue is with HSQLDB? If the initial data load does not work correctly, the application will fail with a race condition when put into a cluster.
As I mentioned, checking in code that is primarily an un-initutive workaround to support Open Liberty (or any other runtime for that matter) is not something we can do. Any other reasonable solution that works with Payara and a cluster is fine. The reason the initial data load is there is that the application needs a row to do a pessimistic lock on, it does not lock on a table as far as I am aware.
On 6/21/2022 12:20 PM, Chanun Ong wrote:
Hi Reza,
Just wanted to get back to you about some database-related experiments to find an alternate solution to the initial-data.sql issue. I was able to get H2 DB to work, but the last working version of H2 with OL that was compatible with batch jobs was 1.4.200. H2 2.x+ no longer works without a custom DDL, so I tried to use HyperSQL DB instead. I ended up encountering a similar problem to Derby, just with a different error code:
[INFO] [WARNING ] CWWJP9991W: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException
[INFO] Internal Exception: java.sql.SQLSyntaxErrorException: unexpected end of statement in statement [-- It's OK for this to fail if the record already exists.]
[INFO] Error Code: -5590
[INFO] Call: -- It's OK for this to fail if the record already exists.
[INFO] Query: DataModifyQuery(sql="-- It's OK for this to fail if the record already exists.")
The app is otherwise fully functional using Derby, HyperSQL DB, and H2 (version 1.4.200). Let me know if you have a preferred route to take with regards to this (pull request for the initial-data.sql, changing the Java code, using a specific database, etc.)
Best,
Chanun OngUniversity of California, BerkeleyElectrical Engineering & Computer Science, B.S.Class of 2022
cargotracker-dev mailing list
cargotracker-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://dev.eclipse.org/mailman/listinfo/cargotracker-dev
_______________________________________________ cargotracker-dev mailing list cargotracker-dev@xxxxxxxxxxx To unsubscribe from this list, visit https://dev.eclipse.org/mailman/listinfo/cargotracker-dev
cargotracker-dev mailing list
cargotracker-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://dev.eclipse.org/mailman/listinfo/cargotracker-dev