We're updating the issue view to help you get more done. 

QuotedIdentifierTest fails with ORA-04043 on Oracle12c

Description

org.hibernate.id.QuotedIdentifierTest

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 11:48:09,985 DEBUG SQL:94 - create table "table" ( "index" number(10,0) generated as identity, "from" varchar2(255 char), "timestamp" number(19,0), primary key ("index") ) Hibernate: create table "table" ( "index" number(10,0) generated as identity, "from" varchar2(255 char), "timestamp" number(19,0), primary key ("index") ) .... .... 11:48:10,049 DEBUG SQL:94 - insert into "table" ("from", "timestamp") values (?, ?) Hibernate: insert into "table" ("from", "timestamp") values (?, ?) 11:48:10,051 WARN SqlExceptionHelper:137 - SQL Error: 4043, SQLState: 42000 11:48:10,051 ERROR SqlExceptionHelper:142 - ORA-04043: object "TABLE" does not exist

I'm not sure how accurate the logging is, but when I try these queries in standalone SQL client, both work.

I tried changing table name to uppercase but it doesn't work. Also I tried to set physical naming strategy but with no success.

Environment

Oracle12c

Status

Assignee

Andrea Boriero

Reporter

Martin Šimka

Fix versions

Labels

backPortable

Backport?

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.3.3

Priority

Major