# upgrade spring boot from 3.2.11 to 3.4.1,
**URL:** https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859
**Category:** Hibernate ORM
**Created:** [January 8, 2025, 2:18pm UTC](https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859 "2025-01-08T14:18:01Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Densagou](https://discourse.hibernate.org/u/Densagou)
#### Post date: [January 8, 2025, 2:18pm UTC](https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859/1 "2025-01-08T14:18:01Z")
I am upgrade my project from 3.2.11 to 3.4.1, but my hql update request is transform to update select and throw and hql syntax error in Sql statement "update [\*](select …). can you help me to understang this isssue. this my update request i use in createQuery : "update Account a set "
```auto
+ "a.lastDefBalance = null,"
+ "a.lastDefExtractNum = null,"
+ "a.lastPrevAccountNum = null,"
+ "a.lastDefAccountNum = null,"
+ "a.lastDefWithMovsJC = null,"
+ "a.lastDefJC = null,"
+ "a.bic11RefPerJC = null,"
+ "a.lastPrevItgtDatetime = null,"
+ "a.lastDefItgtDatetime = null,"
+ "a.lastDefRcptDatetime = null,"
+ "a.lastDefERRcptDatetime = null,"
+ "a.lastDefIntegratedRcptDatetime = null,"
+ "a.nextJC = null,"
+ " a.thalerStatus = null where a.id = :id" and return of update request: AccountRepositoryTest.resetAccountDataContinuityByBic11:168 » InvalidDataAccessResourceUsage could not prepare statement [Erreur de syntaxe dans l'instruction SQL "update [*](select a1_0.LAST_DEF_BALANCE c0,null c1,a1_0.LAST_DEF_EXTRACTNUM c2,null c3,a1_0.LAST_PREV_ACCOUNTNUM c4,null c5,a1_0.LAST_DEF_ACCOUNTNUM c6,null c7,a1_0.LAST_DEF_MOVS_JC c8,null c9,a1_0.LAST_DEF_JC c10,null c11,a1_0.BIC11REF_PERJC c12,null c13,a1_0.LAST_PREV_ITGT c14,null c15,a1_0.LAST_DEF_ITGT c16,null c17,a1_0.LAST_DEF_RCPT c18,null c19,a1_0.LAST_DEF_ER_RCPT c20,null c21,a1_0.LAST_DEF_ITGT_RCPT c22,null c23,a1_0.NEXT_JC c24,null c25,a1_0.THALER_STATUS c26,null c27 from ACCOUNT a1_0 join BANK b1_0 on b1_0.ID_THALER_BANK=a1_0.ID_THALER_BANK where b1_0.BIC=? and b1_0.BRANCH_CODE=?) t set t.c0=t.c1,t.c2=t.c3,t.c4=t.c5,t.c6=t.c7,t.c8=t.c9,t.c10=t.c11,t.c12=t.c13,t.c14=t.c15,t.c16=t.c17,t.c18=t.c19,t.c20=t.c21,t.c22=t.c23,t.c24=t.c25,t.c26=t.c27"; attendu "identifier"
```
Syntax error in SQL statement “update [\*](select a1\_0.LAST\_DEF\_BALANCE c0,null c1,a1\_0.LAST\_DEF\_EXTRACTNUM c2,null c3,a1\_0.LAST\_PREV\_ACCOUNTNUM c4,null c5,a1\_0.LAST\_DEF\_ACCOUNTNUM c6,null c7,a1\_0.LAST\_DEF\_MOVS\_JC c8,null c9,a1\_0.LAST\_DEF\_JC c10,null c11,a1\_0.BIC11REF\_PERJC c12,null c13,a1\_0.LAST\_PREV\_ITGT c14,null c15,a1\_0.LAST\_DEF\_ITGT c16,null c17,a1\_0.LAST\_DEF\_RCPT c18,null c19,a1\_0.LAST\_DEF\_ER\_RCPT c20,null c21,a1\_0.LAST\_DEF\_ITGT\_RCPT c22,null c23,a1\_0.NEXT\_JC c24,null c25,a1\_0.THALER\_STATUS c26,null c27 from ACCOUNT a1\_0 join BANK b1\_0 on b1\_0.ID\_THALER\_BANK=a1\_0.ID\_THALER\_BANK where b1\_0.BIC=? and b1\_0.BRANCH\_CODE=?) t set t.c0=t.c1,t.c2=t.c3,t.c4=t.c5,t.c6=t.c7,t.c8=t.c9,t.c10=t.c11,t.c12=t.c13,t.c14=t.c15,t.c16=t.c17,t.c18=t.c19,t.c20=t.c21,t.c22=t.c23,t.c24=t.c25,t.c26=t.c27”; expected “identifier”; SQL statement:
---
### Author:  [@beikov](https://discourse.hibernate.org/u/beikov)
#### Post date: [January 8, 2025, 2:18pm UTC](https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859/2 "2025-01-08T14:18:36Z")
What database and database version are you using?
---
### Author:  [@Densagou](https://discourse.hibernate.org/u/Densagou)
#### Post date: [January 8, 2025, 2:20pm UTC](https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859/3 "2025-01-08T14:20:28Z")
i use oracle database version 19.23.0.0
---
### Author:  [@beikov](https://discourse.hibernate.org/u/beikov)
#### Post date: [January 8, 2025, 4:30pm UTC](https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859/4 "2025-01-08T16:30:04Z")
Maybe @loiclefevre knows what might go wrong here. I thought that all versions of Oracle support updates to inline views.
---
### Author:  [@Densagou](https://discourse.hibernate.org/u/Densagou)
#### Post date: [January 9, 2025, 9:39am UTC](https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859/5 "2025-01-09T09:39:58Z")
Hi, please do you have an answer or idea on my issue?
---
### Author:  [@loiclefevre](https://discourse.hibernate.org/u/loiclefevre)
#### Post date: [January 28, 2025, 7:55am UTC](https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859/6 "2025-01-28T07:55:42Z")
> [@Densagou](#):
>
> update [\*](SELECT …
Hi,
maybe this `[*]` just after `update` keyword is the culprit?
---
### Author:  [@beikov](https://discourse.hibernate.org/u/beikov)
#### Post date: [February 10, 2025, 12:51pm UTC](https://discourse.hibernate.org/t/upgrade-spring-boot-from-3-2-11-to-3-4-1/10859/7 "2025-02-10T12:51:12Z")
The `[*]` is the position in the SQL that contains unexpected characters according to the database server SQL grammar AFAIU. It simply seems that using inline views in update statements doesn’t work on Oracle 19.23.0.0. Any idea about what the problem might be there @loiclefevre?