Formula failed with quoted NamingStrategy

Description

In my project I use specific NamingStrategy (org.hibernate.cfg.NamingStrategy).

Each column name is wrapped by quotas - _dialect.openQuote() + columnName + _dialect.closeQuote().

Then I try to use a @Formula with one of the property:

@Formula("(select sum(s.\"prodCount\") from SensorEntry as s where s.\"job_id\" = \"id\")")
private Long value;

This transforms into:
select sum(s.job_."prodCount") from SensorEntry as s where s.job_."job_id" = job_."id") as formula24_

Which leads to exception:
19:18:37,268 WARN main JDBCExceptionReporter:100 - SQL Error: 0, SQLState: 3F000
19:18:37,269 ERROR main JDBCExceptionReporter:101 - ERROR: schema "s" does not exist
19:18:37,270 ERROR main AbstractFlushingEventListener:324 - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: unable to select generated column values
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.processGeneratedProperties(AbstractEntityPersister.java:3754)
at org.hibernate.persister.entity.AbstractEntityPersister.processInsertGeneratedProperties(AbstractEntityPersister.java:3703)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:89)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

I suppose that this is because quota literals don't escaped correctly by Hibernate.

Environment

Eclipse Helios Spring 3.0.3 Hibernate-annotations 3.4.0 GA

Activity

Show:

Steve Ebersole May 28, 2015 at 5:57 PM

If this were still an issue (and there is no test case, so I cannot verify it is or is not) the proper project to report this under would be HHH.

Rejected

Details

Assignee

Reporter

Bug Testcase Reminder (view)

Bug reports should generally be accompanied by a test case!

Bug Testcase Reminder (edit)

Bug reports should generally be accompanied by a test case!

Participants

Stanislav Zaluzhsky
Steve Ebersole

Affects versions

Priority

Created April 14, 2012 at 6:14 PM
Updated May 28, 2015 at 5:57 PM
Resolved May 28, 2015 at 5:57 PM