added the dbms to fix failing tests #485
GitHub Actions / orcid-persistence Unit Tests
failed
Jun 3, 2024 in 1s
orcid-persistence Unit Tests ❌
✅ TEST-org.orcid.persistence.dao.AddressDaoTest.xml
5 tests were completed in 20s with 5 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.AddressDaoTest | 5✅ | 20s |
✅ org.orcid.persistence.dao.AddressDaoTest
✅ persistTest
✅ findTest
✅ findByOrcidTest
✅ removeAllTest
✅ mergeTest
✅ TEST-org.orcid.persistence.dao.BackupCodesDaoTest.xml
2 tests were completed in 2s with 2 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.BackupCodesDaoTest | 2✅ | 2s |
✅ org.orcid.persistence.dao.BackupCodesDaoTest
✅ persistTest
✅ mergeTest
✅ TEST-org.orcid.persistence.dao.BiographyDaoTest.xml
4 tests were completed in 2s with 4 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.BiographyDaoTest | 4✅ | 2s |
✅ org.orcid.persistence.dao.BiographyDaoTest
✅ persistTest
✅ testfindByOrcid
✅ mergeTest
✅ testUpdate
✅ TEST-org.orcid.persistence.dao.ClientDetailsDaoTest.xml
1 tests were completed in 2s with 1 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ClientDetailsDaoTest | 1✅ | 2s |
✅ org.orcid.persistence.dao.ClientDetailsDaoTest
✅ testUpdateLastModifiedBulk
✅ TEST-org.orcid.persistence.dao.ClientSecretDaoTest.xml
3 tests were completed in 2s with 3 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ClientSecretDaoTest | 3✅ | 2s |
✅ org.orcid.persistence.dao.ClientSecretDaoTest
✅ testGetNonPrimaryKeys
✅ testLimitedNonPrimaryKeys
✅ testRemoveWithCustomCondition
✅ TEST-org.orcid.persistence.dao.EmailDaoTest.xml
10 tests were completed in 2s with 10 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.EmailDaoTest | 10✅ | 2s |
✅ org.orcid.persistence.dao.EmailDaoTest
✅ testFindOrcidByVerifiedEmail
✅ persistTest
✅ testIsAutoDeprecateEnableForEmail
✅ testRemoveEmail
✅ testVerifyCaseSensitive
✅ testEmailExists
✅ testRemoveEmailCaseSensitive
✅ mergeTest
✅ testVerify
✅ testFindPrimaryEmail
✅ TEST-org.orcid.persistence.dao.EmailFrequencyDaoTest.xml
8 tests were completed in 2s with 8 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.EmailFrequencyDaoTest | 8✅ | 2s |
✅ org.orcid.persistence.dao.EmailFrequencyDaoTest
✅ persistTest
✅ updateSendQuarterlyTipsTest
✅ findTest
✅ findByOrcidTest
✅ updateSendChangeNotificationsTest
✅ updateSendAdministrativeChangeNotificationsTest
✅ mergeTest
✅ updateSendMemberUpdateRequestsTest
✅ TEST-org.orcid.persistence.dao.EventDaoTest.xml
3 tests were completed in 2s with 3 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.EventDaoTest | 3✅ | 2s |
✅ org.orcid.persistence.dao.EventDaoTest
✅ deletePapiEventsByDate
✅ testWriteEvent
✅ deleteEventsByDate
✅ TEST-org.orcid.persistence.dao.EventStatsDaoTest.xml
2 tests were completed in 433ms with 2 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.EventStatsDaoTest | 2✅ | 433ms |
✅ org.orcid.persistence.dao.EventStatsDaoTest
✅ createEventStats
✅ createPapiEventStats
✅ TEST-org.orcid.persistence.dao.ExternalIdentifierDaoTest.xml
7 tests were completed in 2s with 7 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ExternalIdentifierDaoTest | 7✅ | 2s |
✅ org.orcid.persistence.dao.ExternalIdentifierDaoTest
✅ testGetExternalIdentifiers
✅ testGetExternalIdentifiersUsingVisibility
✅ persistTest
✅ testGetExternalIdentifier
✅ testGetExternalIdentifierThatDontBelongToThatUser
✅ removeAllTest
✅ mergeTest
✅ TEST-org.orcid.persistence.dao.FindMyStuffDaoTest.xml
5 tests were completed in 2s with 5 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.FindMyStuffDaoTest | 5✅ | 2s |
✅ org.orcid.persistence.dao.FindMyStuffDaoTest
✅ findTest
✅ updateTest
✅ markActioned
✅ markOptOut
✅ createTest
✅ TEST-org.orcid.persistence.dao.IdentifierTypeDaoTest.xml
2 tests were completed in 1s with 2 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.IdentifierTypeDaoTest | 2✅ | 1s |
✅ org.orcid.persistence.dao.IdentifierTypeDaoTest
✅ test1AddUpdateFetchID
✅ test4FetchIDList
✅ TEST-org.orcid.persistence.dao.InvalidRecordDataChangeDaoTest.xml
22 tests were completed in 4s with 22 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.InvalidRecordDataChangeDaoTest | 22✅ | 4s |
✅ org.orcid.persistence.dao.InvalidRecordDataChangeDaoTest
✅ invalidValueDescendingTest
✅ havePreviousTest
✅ fetchAllAscendantTest
✅ invalidValueAscendingTest
✅ haveNextTest
✅ fetchAllDescendantTest
✅ fetchPageSize1Test
✅ fetchPageSize2Test
✅ fetchPageSize3Test
✅ fetchPageSize4Test
✅ fetchPageSize5Test
✅ fetchPageSize6Test
✅ fetchPageSize7Test
✅ fetchPageSize8Test
✅ fetchPageSize9Test
✅ fetchPageSize10Test
✅ fetchPageSize11Test
✅ fetchPageSize12Test
✅ fetchPageSize13Test
✅ fetchPageSize14Test
✅ fetchPageSize15Test
✅ fetchPageSize16Test
✅ TEST-org.orcid.persistence.dao.NotificationDao_NoDBPrefillTest.xml
3 tests were completed in 2s with 3 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.NotificationDao_NoDBPrefillTest | 3✅ | 2s |
✅ org.orcid.persistence.dao.NotificationDao_NoDBPrefillTest
✅ testTipsNotifications
✅ testServiceAnnouncementNotifications
✅ testFindRecordsWithUnsentNotifications
✅ TEST-org.orcid.persistence.dao.NotificationDaoTest.xml
12 tests were completed in 2s with 12 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.NotificationDaoTest | 12✅ | 2s |
✅ org.orcid.persistence.dao.NotificationDaoTest
✅ archiveOffsetNotificationsTest
✅ testFindCustomNotification
✅ findNotificationsToDeleteByOffsetTest
✅ testFindLatestByOrcid
✅ persistTest
✅ testTipsNotifications
✅ testFindNotificationsToSendLegacy
✅ testFindPermissionByOrcidAndClient
✅ testFindPermissionNotification
✅ testFindNotificationsToSend
✅ testServiceAnnouncementNotifications
✅ mergeTest
✅ TEST-org.orcid.persistence.dao.OrcidOauth2AuthoriziationCodeDetailDaoTest.xml
1 tests were completed in 2s with 1 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.OrcidOauth2AuthoriziationCodeDetailDaoTest | 1✅ | 2s |
✅ org.orcid.persistence.dao.OrcidOauth2AuthoriziationCodeDetailDaoTest
✅ isPersistentTokenTest
✅ TEST-org.orcid.persistence.dao.OrcidOauth2TokenDetailDaoTest.xml
18 tests were completed in 2s with 18 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.OrcidOauth2TokenDetailDaoTest | 18✅ | 2s |
✅ org.orcid.persistence.dao.OrcidOauth2TokenDetailDaoTest
✅ disableAccessTokenTest
✅ updateScopesTest
✅ findByUserNameTest
✅ disableClientAccessTokensByUserOrcidTest
✅ findByAuthenticationKeyTest
✅ hasTokenTest
✅ findByRefreshTokenValueTest
✅ disableAccessTokenByIdTest
✅ findNonDisabledByTokenValueTest
✅ findByTokenValueTest
✅ findByClientIdTest
✅ disableAccessTokenByCodeAndClientTest
✅ disableAccessTokenByRefreshTokenTest
✅ tokenRevokedByMemberMustNotOverwriteRevokeReasonIfRevokedByUser
✅ findAvailableScopesByUserAndClientIdTest
✅ revokeAccessTokenTest
✅ findByClientIdAndUserNameTest
✅ disableAccessTokenByUserOrcidTest
❌ TEST-org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.xml
4 tests were completed in 2s with 1 passed, 3 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.OrgAffiliationRelationDaoTest | 1✅ | 3❌ | 2s |
❌ org.orcid.persistence.dao.OrgAffiliationRelationDaoTest
❌ persistTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ hasPublicAffiliationsTest
❌ removeAllTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ mergeTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ TEST-org.orcid.persistence.dao.OrgDisambiguatedDaoTest.xml
4 tests were completed in 2s with 1 passed, 3 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.OrgDisambiguatedDaoTest | 1✅ | 3❌ | 2s |
❌ org.orcid.persistence.dao.OrgDisambiguatedDaoTest
❌ persistTest
org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [insert into org_disambiguated (date_created, last_modified, city, country, indexing_status, last_indexed_date, locations_json, name, names_json, org_type, popularity, region, source_id, source_parent_id, source_type, source_url, status, url, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testFindDisambuguatedOrgsWithIncorrectPopularity
❌ testFindBySourceIdAndSourceType
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ mergeTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ TEST-org.orcid.persistence.dao.OrgImportLogDaoTest.xml
2 tests were completed in 12ms with 2 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.OrgImportLogDaoTest | 2✅ | 12ms |
✅ org.orcid.persistence.dao.OrgImportLogDaoTest
✅ testGetNextImportSourceName
✅ testGetNextImportSourceNameNoResult
✅ TEST-org.orcid.persistence.dao.OtherNameDaoTest.xml
7 tests were completed in 2s with 7 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.OtherNameDaoTest | 7✅ | 2s |
✅ org.orcid.persistence.dao.OtherNameDaoTest
✅ testGetInvalidOtherName
✅ persistTest
✅ testGetOtherName
✅ testUpdateOtherName
✅ removeAllTest
✅ testfindOtherNameByOrcid
✅ mergeTest
❌ TEST-org.orcid.persistence.dao.PeerReviewDaoTest.xml
4 tests were completed in 2s with 1 passed, 3 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.PeerReviewDaoTest | 1✅ | 3❌ | 2s |
❌ org.orcid.persistence.dao.PeerReviewDaoTest
❌ persistTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ removeAllTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ hasPublicPeerReviewsTest
❌ mergeTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ TEST-org.orcid.persistence.dao.ProfileDaoTest.xml
17 tests were completed in 2s with 17 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ProfileDaoTest | 17✅ | 2s |
✅ org.orcid.persistence.dao.ProfileDaoTest
✅ testAutoDeprecateProfile
✅ testFindUnclaimedNeedingReminder
✅ findEmailsToSendAddWorksFirstAttemptEmail
✅ testUpdateDefaultVisibility
✅ testFindAll
✅ testUpdateIndexingStatus
✅ testFindUnclaimedNotIndexedAfterWaitPeriod
✅ testfindById
✅ testDeprecateProfile
✅ testOrcidsFindByIndexingStatus
✅ testGetClaimedStatusByEmail
✅ testInsertWithPrimaryInstitutions
✅ testOrcidExists
✅ testInsert
✅ testGetConfirmedProfileCount
✅ testInsertWithInstitutionDepartments
✅ testDisable2FA
❌ TEST-org.orcid.persistence.dao.ProfileFundingDaoTest.xml
4 tests were completed in 2s with 1 passed, 3 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ProfileFundingDaoTest | 1✅ | 3❌ | 2s |
❌ org.orcid.persistence.dao.ProfileFundingDaoTest
❌ persistTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ removeAllTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ hasPublicFundingTest
❌ mergeTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ TEST-org.orcid.persistence.dao.ProfileHistoryEventDaoTest.xml
2 tests were completed in 2s with 2 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ProfileHistoryEventDaoTest | 2✅ | 2s |
✅ org.orcid.persistence.dao.ProfileHistoryEventDaoTest
✅ persistTest
✅ mergeTest
✅ TEST-org.orcid.persistence.dao.ProfileKeywordDaoTest.xml
6 tests were completed in 2s with 6 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ProfileKeywordDaoTest | 6✅ | 2s |
✅ org.orcid.persistence.dao.ProfileKeywordDaoTest
✅ testfindProfileKeywords
✅ testAddProfileKeyword
✅ persistTest
✅ removeAllTest
✅ testDeleteProfileKeyword
✅ mergeTest
✅ TEST-org.orcid.persistence.dao.RecordNameDaoTest.xml
6 tests were completed in 2s with 6 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.RecordNameDaoTest | 6✅ | 2s |
✅ org.orcid.persistence.dao.RecordNameDaoTest
✅ testfindByCreditName
✅ persistTest
✅ testfindByOrcid
✅ testExists
✅ mergeTest
✅ testUpdate
✅ TEST-org.orcid.persistence.dao.ResearcherUrlDaoTest.xml
7 tests were completed in 2s with 7 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ResearcherUrlDaoTest | 7✅ | 2s |
✅ org.orcid.persistence.dao.ResearcherUrlDaoTest
✅ testDeleteResearcherUrl
✅ persistTest
✅ testAddResearcherUrl
✅ removeAllTest
✅ testfindResearcherUrls
✅ testfindResearcherUrl
✅ mergeTest
❌ TEST-org.orcid.persistence.dao.ResearchResourceDaoTest.xml
6 tests were completed in 2s with 1 passed, 5 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.ResearchResourceDaoTest | 1✅ | 5❌ | 2s |
❌ org.orcid.persistence.dao.ResearchResourceDaoTest
❌ persistTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testRead
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ testHasPublicResearchResources
❌ testWriteRI
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ testWriteRR
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
❌ mergeTest
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
✅ TEST-org.orcid.persistence.dao.SpamDaoTest.xml
7 tests were completed in 2s with 7 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.SpamDaoTest | 7✅ | 2s |
✅ org.orcid.persistence.dao.SpamDaoTest
✅ persistTest
✅ testfindByOrcid
✅ testWriteSpam
✅ testUpdateSpamCount
✅ testRemoveSpam
✅ testExists
✅ mergeTest
✅ TEST-org.orcid.persistence.dao.WebhookDaoTest.xml
5 tests were completed in 2s with 5 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.WebhookDaoTest | 5✅ | 2s |
✅ org.orcid.persistence.dao.WebhookDaoTest
✅ testFindWebhooksReadyToProcess
✅ testMergeFindAndRemove
✅ testCountWebhooksReadyToProcess
✅ mergeTest
✅ testFindWebhooksReadyToProcessWhenIsNotReadyForRetry
✅ TEST-org.orcid.persistence.dao.WorkDaoTest.xml
5 tests were completed in 2s with 5 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.dao.WorkDaoTest | 5✅ | 2s |
✅ org.orcid.persistence.dao.WorkDaoTest
✅ persistTest
✅ getWorksByOrcidIdTest
✅ removeAllWorksTest
✅ mergeTest
✅ testHasPublicWorks
✅ TEST-org.orcid.persistence.jpa.entities.FuzzyDateTest.xml
1 tests were completed in 1ms with 1 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.jpa.entities.FuzzyDateTest | 1✅ | 1ms |
✅ org.orcid.persistence.jpa.entities.FuzzyDateTest
✅ testFuzzyDateComparison
✅ TEST-org.orcid.persistence.jpa.entities.WorkEntityTest.xml
2 tests were completed in 0ms with 2 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| org.orcid.persistence.jpa.entities.WorkEntityTest | 2✅ | 0ms |
✅ org.orcid.persistence.jpa.entities.WorkEntityTest
✅ testChronologicallyOrderWorkEntityTest
✅ testWorkEntityComparison
Annotations
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.OrgAffiliationRelationDaoTest ► persistTest
Failed test found in:
TEST-org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.persistTest(OrgAffiliationRelationDaoTest.java:99)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.persistTest(OrgAffiliationRelationDaoTest.java:99)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.persistTest(OrgAffiliationRelationDaoTest.java:99)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.persistTest(OrgAffiliationRelationDaoTest.java:99)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.OrgAffiliationRelationDaoTest ► removeAllTest
Failed test found in:
TEST-org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.removeAllTest(OrgAffiliationRelationDaoTest.java:48)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.removeAllTest(OrgAffiliationRelationDaoTest.java:48)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.removeAllTest(OrgAffiliationRelationDaoTest.java:48)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.removeAllTest(OrgAffiliationRelationDaoTest.java:48)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.OrgAffiliationRelationDaoTest ► mergeTest
Failed test found in:
TEST-org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.mergeTest(OrgAffiliationRelationDaoTest.java:72)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.mergeTest(OrgAffiliationRelationDaoTest.java:72)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.mergeTest(OrgAffiliationRelationDaoTest.java:72)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgAffiliationRelationDaoTest.mergeTest(OrgAffiliationRelationDaoTest.java:72)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.OrgDisambiguatedDaoTest ► persistTest
Failed test found in:
TEST-org.orcid.persistence.dao.OrgDisambiguatedDaoTest.xml
Error:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [insert into org_disambiguated (date_created, last_modified, city, country, indexing_status, last_indexed_date, locations_json, name, names_json, org_type, popularity, region, source_id, source_parent_id, source_type, source_url, status, url, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [insert into org_disambiguated (date_created, last_modified, city, country, indexing_status, last_indexed_date, locations_json, name, names_json, org_type, popularity, region, source_id, source_parent_id, source_type, source_url, status, url, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.persistTest(OrgDisambiguatedDaoTest.java:98)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.persistTest(OrgDisambiguatedDaoTest.java:98)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LOCATIONS_JSON
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.persistTest(OrgDisambiguatedDaoTest.java:98)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: LOCATIONS_JSON
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.persistTest(OrgDisambiguatedDaoTest.java:98)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.OrgDisambiguatedDaoTest ► testFindBySourceIdAndSourceType
Failed test found in:
TEST-org.orcid.persistence.dao.OrgDisambiguatedDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.testFindBySourceIdAndSourceType(OrgDisambiguatedDaoTest.java:68)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.testFindBySourceIdAndSourceType(OrgDisambiguatedDaoTest.java:68)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI0_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.testFindBySourceIdAndSourceType(OrgDisambiguatedDaoTest.java:68)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI0_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.testFindBySourceIdAndSourceType(OrgDisambiguatedDaoTest.java:68)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.OrgDisambiguatedDaoTest ► mergeTest
Failed test found in:
TEST-org.orcid.persistence.dao.OrgDisambiguatedDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.mergeTest(OrgDisambiguatedDaoTest.java:78)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.mergeTest(OrgDisambiguatedDaoTest.java:78)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI0_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.mergeTest(OrgDisambiguatedDaoTest.java:78)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI0_.LOCATIONS_JSON
at org.orcid.persistence.dao.OrgDisambiguatedDaoTest.mergeTest(OrgDisambiguatedDaoTest.java:78)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.PeerReviewDaoTest ► persistTest
Failed test found in:
TEST-org.orcid.persistence.dao.PeerReviewDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.PeerReviewDaoTest.persistTest(PeerReviewDaoTest.java:102)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.PeerReviewDaoTest.persistTest(PeerReviewDaoTest.java:102)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.PeerReviewDaoTest.persistTest(PeerReviewDaoTest.java:102)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.PeerReviewDaoTest.persistTest(PeerReviewDaoTest.java:102)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.PeerReviewDaoTest ► removeAllTest
Failed test found in:
TEST-org.orcid.persistence.dao.PeerReviewDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.PeerReviewDaoTest.removeAllTest(PeerReviewDaoTest.java:48)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.PeerReviewDaoTest.removeAllTest(PeerReviewDaoTest.java:48)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
at org.orcid.persistence.dao.PeerReviewDaoTest.removeAllTest(PeerReviewDaoTest.java:48)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
at org.orcid.persistence.dao.PeerReviewDaoTest.removeAllTest(PeerReviewDaoTest.java:48)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.PeerReviewDaoTest ► mergeTest
Failed test found in:
TEST-org.orcid.persistence.dao.PeerReviewDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.PeerReviewDaoTest.mergeTest(PeerReviewDaoTest.java:73)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.PeerReviewDaoTest.mergeTest(PeerReviewDaoTest.java:73)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.PeerReviewDaoTest.mergeTest(PeerReviewDaoTest.java:73)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.PeerReviewDaoTest.mergeTest(PeerReviewDaoTest.java:73)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.ProfileFundingDaoTest ► persistTest
Failed test found in:
TEST-org.orcid.persistence.dao.ProfileFundingDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.ProfileFundingDaoTest.persistTest(ProfileFundingDaoTest.java:100)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.ProfileFundingDaoTest.persistTest(ProfileFundingDaoTest.java:100)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.ProfileFundingDaoTest.persistTest(ProfileFundingDaoTest.java:100)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI2_.LOCATIONS_JSON
at org.orcid.persistence.dao.ProfileFundingDaoTest.persistTest(ProfileFundingDaoTest.java:100)
github-actions / orcid-persistence Unit Tests
org.orcid.persistence.dao.ProfileFundingDaoTest ► removeAllTest
Failed test found in:
TEST-org.orcid.persistence.dao.ProfileFundingDaoTest.xml
Error:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Raw output
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.ProfileFundingDaoTest.removeAllTest(ProfileFundingDaoTest.java:48)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at org.orcid.persistence.dao.ProfileFundingDaoTest.removeAllTest(ProfileFundingDaoTest.java:48)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
at org.orcid.persistence.dao.ProfileFundingDaoTest.removeAllTest(ProfileFundingDaoTest.java:48)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: ORGDISAMBI1_.LOCATIONS_JSON
at org.orcid.persistence.dao.ProfileFundingDaoTest.removeAllTest(ProfileFundingDaoTest.java:48)
Loading