[4.6.4] Hibernate warnings(HHH90000022) about deprecated usages

obiba / opal

OBiBa’s core database application for biobanks or epidemiological studies.

http://www.obiba.org/pages/products/opal/

GNU General Public License v3.0

28 stars 22 forks source link

[4.6.4] Hibernate warnings(HHH90000022) about deprecated usages #3813

Closed tuxmaster5000 closed 8 months ago

tuxmaster5000 commented 8 months ago

This issue is unique

[X] I have used the search tool and did not find an issue describing my bug.

Version information

4.6.4

Expected behavior

Not warnings about deprecated calls.

Actual behavior

Lot of warnings in the log file: 2023-10-18 08:41:39,165 [qtp217062446-5485] WARN org.hibernate.orm.deprecation - HHH90000022: Hibernate's legacy org.hibernate.Criteria API is deprecated; use the JPA javax.persistence.criteria.CriteriaQuery instead

Reproduction steps

There is no "standard way" to reproduce it. It will shown randomly in the log.

Operating System (OS)

Linux

Browser

FireFox

Contact info

No response

ymarcon commented 8 months ago

We do not recommend using the Hibernate based SQL schema, use "Tabular SQL" schema instead. Hibernate is hard to maintain and this SQL schema has poor performance.

tuxmaster5000 commented 8 months ago

Ok, that can be, but how to convert the existing "Opal SQL" to "Tabular SQL" schema? I don't see any convert function.

ymarcon commented 8 months ago

There is no "conversion" per say, you can use the project backup/restore feature instead. Or copy the tables into another project.

tuxmaster5000 commented 8 months ago

I will forward this to the scientists for testing.

sofiasiamp commented 8 months ago

Hi, and thank you for your help! I tried to do the "conversion": with project backup/restore:

Created a new folder in the file system called "backup"
Backed up the data from the project that used OpalSQL into the folder "backup".
Opened the backup folder and inside there are two folders: "files" with the data dictionary and dataset and "tables" with a data.csv and a table.json file, meaning that the back up was successful.
I created a new project (using Tabular SQL) and tried to use the restore function with the backup folder I had created, but both folders files and tables look empty, even though they are not. Therefore, I can't proceed with the restore.

with copy: When attempting to copy a table from one project to another, it works. I can see all values and variables. The only issue is that I get an error in the Tasks tab:

sofiasiamp commented 8 months ago

I now tested it with Opal Python Client and this method works!