[JIRA] (HHH-13918) [AlwaysEncrypted] Insert in join tables with @ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE })
by Romain Wilbert (JIRA)
Romain Wilbert ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e835df... ) *updated* an issue
Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGUwNzEyMDM1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13918?atlOrigin=eyJpIjoiMGUwNz... ) HHH-13918 ( https://hibernate.atlassian.net/browse/HHH-13918?atlOrigin=eyJpIjoiMGUwNz... ) [AlwaysEncrypted] Insert in join tables with @ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE }) ( https://hibernate.atlassian.net/browse/HHH-13918?atlOrigin=eyJpIjoiMGUwNz... )
Change By: Romain Wilbert ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e835df... )
Hi \ !
I have configured my app with mssql-jdbc driver and always encrypted turned on.
I have an entity with a @ManyToMany association as described :
{code:java}
@ManyToMany(cascade = { CascadeType. PERSIST, CascadeType. MERGE })
@JoinTable(name = " account_manage account_authority ", joinColumns = @JoinColumn(name = "ACC_ID"), inverseJoinColumns = @JoinColumn(name = " MAN_CODE AUTH_NAME "))
@JsonIgnore
private List Set < Manage Authority > manageCodes authorities = new ArrayList HashSet <>();
{code}
I configured hibernate with
{code:java}
hibernate.use_nationalized_character_data = true
{code}
When I try to save my entity, insert is done in the join table but I get an error :
{code:java}
14:35:12.101 [http-nio-8080-exec-1] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 402, SQLState: S0002
14:35:12.102 [http-nio-8080-exec-1] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - The data types nvarchar and nvarchar(17) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'cpa-dev-02-db') are incompatible in the equal to operator.
14:35:12.109 [http-nio-8080-exec-1] INFO o.h.e.i.DefaultLoadEventListener - HHH000327: Error performing load command : org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
{code}
Do i have to fix length for every field because i use always encrypted ?
( https://hibernate.atlassian.net/browse/HHH-13918#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13918#add-comment?atlOrigin=ey... )
Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100123- sha1:a8fd8fd )
4 years, 9 months
[JIRA] (HHH-13919) [AlwaysEncrypted] Insert in join tables with @ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE })
by Romain Wilbert (JIRA)
Romain Wilbert ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e835df... ) *created* an issue
Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDUzZDAwYTUz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13919?atlOrigin=eyJpIjoiZDUzZD... ) HHH-13919 ( https://hibernate.atlassian.net/browse/HHH-13919?atlOrigin=eyJpIjoiZDUzZD... ) [AlwaysEncrypted] Insert in join tables with @ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE }) ( https://hibernate.atlassian.net/browse/HHH-13919?atlOrigin=eyJpIjoiZDUzZD... )
Issue Type: Bug Affects Versions: 5.3.14 Assignee: Unassigned Components: hibernate-entitymanager Created: 31/Mar/2020 08:37 AM Priority: Major Reporter: Romain Wilbert ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e835df... )
Hi !
I have configured my app with mssql-jdbc driver and always encrypted turned on.
I have an entity with a @ManyToMany association as described :
@ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE })
@JoinTable(name = "account_manage" , joinColumns = @JoinColumn(name = "ACC_ID" ), inverseJoinColumns = @JoinColumn(name = "MAN_CODE" ))
@JsonIgnore
private List<Manage> manageCodes = new ArrayList<>();
I configured hibernate with
hibernate.use_nationalized_character_data = true
When I try to save my entity, insert is done in the join table but I get an error :
14:35:12.101 [http-nio-8080-exec-1] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 402, SQLState: S0002
14:35:12.102 [http-nio-8080-exec-1] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - The data types nvarchar and nvarchar(17) encrypted with (encryption_type = 'DETERMINISTIC' , encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256' , column_encryption_key_name = 'CEK_Auto1' , column_encryption_key_database_name = 'cpa-dev-02-db' ) are incompatible in the equal to operator.
14:35:12.109 [http-nio-8080-exec-1] INFO o.h.e.i.DefaultLoadEventListener - HHH000327: Error performing load command : org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Do i have to fix length for every field because i use always encrypted ?
( https://hibernate.atlassian.net/browse/HHH-13919#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13919#add-comment?atlOrigin=ey... )
Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100123- sha1:a8fd8fd )
4 years, 9 months
[JIRA] (HHH-13918) [AlwaysEncrypted] Insert in join tables with @ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE })
by Romain Wilbert (JIRA)
Romain Wilbert ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e835df... ) *created* an issue
Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDdmMzQzZDg3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13918?atlOrigin=eyJpIjoiMDdmMz... ) HHH-13918 ( https://hibernate.atlassian.net/browse/HHH-13918?atlOrigin=eyJpIjoiMDdmMz... ) [AlwaysEncrypted] Insert in join tables with @ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE }) ( https://hibernate.atlassian.net/browse/HHH-13918?atlOrigin=eyJpIjoiMDdmMz... )
Issue Type: Bug Affects Versions: 5.3.14 Assignee: Unassigned Components: hibernate-entitymanager Created: 31/Mar/2020 08:37 AM Priority: Major Reporter: Romain Wilbert ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e835df... )
Hi !
I have configured my app with mssql-jdbc driver and always encrypted turned on.
I have an entity with a @ManyToMany association as described :
@ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE })
@JoinTable(name = "account_manage" , joinColumns = @JoinColumn(name = "ACC_ID" ), inverseJoinColumns = @JoinColumn(name = "MAN_CODE" ))
@JsonIgnore
private List<Manage> manageCodes = new ArrayList<>();
I configured hibernate with
hibernate.use_nationalized_character_data = true
When I try to save my entity, insert is done in the join table but I get an error :
14:35:12.101 [http-nio-8080-exec-1] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 402, SQLState: S0002
14:35:12.102 [http-nio-8080-exec-1] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - The data types nvarchar and nvarchar(17) encrypted with (encryption_type = 'DETERMINISTIC' , encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256' , column_encryption_key_name = 'CEK_Auto1' , column_encryption_key_database_name = 'cpa-dev-02-db' ) are incompatible in the equal to operator.
14:35:12.109 [http-nio-8080-exec-1] INFO o.h.e.i.DefaultLoadEventListener - HHH000327: Error performing load command : org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Do i have to fix length for every field because i use always encrypted ?
( https://hibernate.atlassian.net/browse/HHH-13918#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13918#add-comment?atlOrigin=ey... )
Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100123- sha1:a8fd8fd )
4 years, 9 months