[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7248) Column names specified by @JoinColumn(name="testColumnId") lowercased
Column names specified by @JoinColumn(name="testColumnId") lowercased
----------------------------------------------------------------------
Key: HHH-7248
URL: https://hibernate.onjira.com/browse/HHH-7248
Project: Hibernate ORM
Issue Type: Bug
Components: annotations
Affects Versions: 4.1.2, 3.6.8
Reporter: timoffei
Even though i use ejb3namingstrategy, at runtime, column names specified by
@javax.persistence.JoinColumn(name="testColumnId")
are lowercased as "testcolumnid".
In hibernate 3.6.4 it runs successfully generating sql code as:
select top 25 testem0_.testColumnId as testZ9_62_, testem0_.testColumn2Id as testT14_62_
from Testems testem0_
whereas 3.6.7 generates code as:
WITH query AS (select ROW_NUMBER() OVER (order by testem0_.id asc) as
__hibernate_row_nr__, testem0_.testcolumnid as test9_62_, testem0_.testcolumn2id as
testT14_62_ from Testems testem0_ ) SELECT * FROM query WHERE __hibernate_row_nr__ BETWEEN
? AND ?
Which fails:
WARN 04.14 04:34:03 org.hibernate.util.JDBCExceptionReporter - SQL Error: 207, SQLState:
42S22
ERROR 04.14 04:34:03 org.hibernate.util.JDBCExceptionReporter - Invalid column name
'testcolumnid'.
WARN 04.14 04:34:03 org.hibernate.util.JDBCExceptionReporter - SQL Error: 207, SQLState:
42S22
ERROR 04.14 04:34:03 org.hibernate.util.JDBCExceptionReporter - Invalid column name
'testcolumn2id'.
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2536)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.loader.Loader.list(Loader.java:2271)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
Caused by: java.sql.SQLException: Invalid column name 'testcolumnid'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
~[jtds-1.2.2.jar:1.2.2]
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
~[jtds-1.2.2.jar:1.2.2]
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
~[jtds-1.2.2.jar:1.2.2]
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
~[jtds-1.2.2.jar:1.2.2]
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
~[jtds-1.2.2.jar:1.2.2]
at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
~[jtds-1.2.2.jar:1.2.2]
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
~[c3p0-0.9.1.jar:0.9.1]
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2533)
~[hibernate-core-3.6.7.Final.jar:3.6.7.Final]
... 89 common frames omitted
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira