<org.hibernate.util.JDBCExceptionReporter> <000000> <Invalid column
name> Exception in Named Query
--------------------------------------------------------------------------------------------------
Key: HHH-2348
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2348
Project: Hibernate3
Type: Bug
Components: query-sql
Environment: Hibernate 3, Oracle9
Reporter: Srikant Panda
I am trying to use "getNamedQuery". When I run the SQL, as shown by putting the
property "hibernate.show_sql" in config file, The SQL Runs perfectly fine. but
in Hibernate it is throwing an exception of "invalid Column", What is annoying
is , It worked fine when I was not using named query.
below is the copy of my hibernate.cfg.xml
==============================
<?xml version='1.0' encoding='UTF-8'?
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"
<!-- Generated by MyEclipse Hibernate Tools. --
<hibernate-configuration
<session-factory
<property
name="connection.username">pdbread</property
<property name="connection.url"
jdbc:oracle:thin:@chi1dds1:1521:pdbdev
</property
<property
name="dialect"
org.hibernate.dialect.Oracle9Dialect
</property
<property
name="myeclipse.connection.profile">PDBDEV</property
<property
name="connection.password">owner</property
<property name="hibernate.show_sql">true</property
<property name="connection.driver_class"
oracle.jdbc.driver.OracleDriver
</property
<mapping
resource="com/uscellular/shared/services/hibernate/Organization.hbm.xml" /
</session-factory
</hibernate-configuration
========================
The Organization.hbm.xml file
=====================
<?xml version="1.0"?
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
--
<hibernate-mapping
<class name="com.uscellular.shared.services.hibernate.Organization"
table="ORGANIZATION" schema="PDBREAD"
<id name="organizationKey" type="java.lang.Long"
<column name="ORGANIZATION_KEY"
precision="10" scale="0" /
<generator class="assigned" /
</id
<property name="region"
type="java.lang.String"
<column
name="REGION" length="30" /
</property
<property
name="clusterDesc" type="java.lang.String"
<column name="CLUSTER_DESC"
length="30" /
</property
<property name="submarketId"
type="java.lang.String"
<column
name="SUBMARKET_ID" length="3" /
</property
<property
name="submarketDesc" type="java.lang.String"
<column name="SUBMARKET_DESC"
length="30" /
</property
<property name="marketStatus"
type="java.lang.String"
<column
name="MARKET_STATUS" length="1" /
</property
<property
name="dataCenter" type="java.lang.String"
<column name="DATA_CENTER" length="3" /
</property
<property name="roamingAdminFee" type="java.lang.Double"
<column name="ROAMING_ADMIN_FEE"
precision="9" /
</property
<property name="networkSurcharge"
type="java.lang.Double"
<column
name="NETWORK_SURCHARGE" precision="9" /
</property
<property
name="state911Fee" type="java.lang.Double"
<column name="STATE_911_FEE"
precision="9" /
</property
<property name="state911FeeType"
type="java.lang.String"
<column
name="STATE_911_FEE_TYPE" length="3" /
</property
<property
name="additionalComments" type="java.lang.String"
<column name="ADDITIONAL_COMMENTS"
length="2000" /
</property
<property name="caresModificationDate"
type="java.util.Date"
<column
name="CARES_MODIFICATION_DATE" length="7" /
</property
<property name="modificationDate" type="java.util.Date"
<column name="MODIFICATION_DATE"
length="7" /
</property
<property name="modificationUser"
type="java.lang.String"
<column
name="MODIFICATION_USER" length="10" /
</property
<property
name="approvalDate" type="java.util.Date"
<column name="APPROVAL_DATE" length="7" /
</property
<property name="approvalUser" type="java.lang.String"
<column name="APPROVAL_USER"
length="10" /
</property
<property name="lastReleaseDate"
type="java.util.Date"
<column
name="LAST_RELEASE_DATE" length="7" /
</property
<property
name="clusterId" type="java.lang.Long"
<column name="CLUSTER_ID" precision="10" scale="0"
not-null="true" /
</property
</class
<sql-query name="GetAllOrganization"
<return alias="Organization"
class="com.uscellular.shared.services.hibernate.Organization"
<return-property name="ORGANIZATION_KEY"
column="organizationKey"/
<return-property name="REGION" column="region"/
<return-property name="CLUSTER_DESC"
column="clusterDesc"/
<return-property
name="SUBMARKET_ID" column="submarketId"/
<return-property name="SUBMARKET_DESC" column="submarketDesc"/
<return-property name="MARKET_STATUS"
column="marketStatus"/
<return-property
name="DATA_CENTER" column="dataCenter"/
<return-property name="ROAMING_ADMIN_FEE"
column="roamingAdminFee"/
<return-property name="NETWORK_SURCHARGE"
column="networkSurcharge"/
<return-property name="STATE_911_FEE" column="state911Fee"/
<return-property name="STATE_911_FEE_TYPE"
column="state911FeeType"/
<return-property name="ADDITIONAL_COMMENTS"
column="additionalComments"/
<return-property name="CARES_MODIFICATION_DATE"
column="caresModificationDate"/
<return-property name="MODIFICATION_DATE"
column="modificationDate"/
<return-property name="MODIFICATION_USER"
column="modificationUser"/
<return-property name="APPROVAL_DATE" column="approvalDate"/
<return-property name="APPROVAL_USER"
column="approvalUser"/
<return-property
name="LAST_RELEASE_DATE" column="lastReleaseDate"/
<return-property name="CLUSTER_ID"
column="clusterId"/
</return
select organization_key AS organizationKey, region AS region,
cluster_desc AS clusterDesc, submarket_id AS submarketId, submarket_desc AS submarketDesc,
market_status AS marketStatus, data_center AS dataCenter, nvl(roaming_admin_fee,0) AS
roamingAdminFee, nvl(network_surcharge,0) AS networkSurcharge, nvl(state_911_fee,0) AS
state911Fee, state_911_fee_type AS state911FeeType, additional_comments AS
additionalComments, cares_modification_date AS caresModificationDate, modification_date AS
modificationDate, modification_user AS modificationUser, approval_date AS approvalDate,
approval_user AS approvalUser, last_release_date AS lastReleaseDate, cluster_id AS
clusterId from organization
</sql-query
</hibernate-mapping
===========================
when I make a call like this
>>>
public Organization[] getAll() {
List<Organization> retList;
Organization[] org= null;
try {
org.hibernate.Session s = getSession();
retList = s.getNamedQuery("GetAllOrganization").list();
org = new Organization[retList.size()];
retList.toArray(org);
} catch (RuntimeException re) {
log.error("get failed", re);
throw re;
}
return org;
}
>
>>>
I get an Exception as below
Hibernate: select organization_key AS organizationKey, region AS region, cluster_desc AS
clusterDesc, submarket_id AS submarketId, submarket_desc AS submarketDesc, market_status
AS marketStatus, data_center AS dataCenter, nvl(roaming_admin_fee,0) AS roamingAdminFee,
nvl(network_surcharge,0) AS networkSurcharge, nvl(state_911_fee,0) AS state911Fee,
state_911_fee_type AS state911FeeType, additional_comments AS additionalComments,
cares_modification_date AS caresModificationDate, modification_date AS modificationDate,
modification_user AS modificationUser, approval_date AS approvalDate, approval_user AS
approvalUser, last_release_date AS lastReleaseDate, cluster_id AS clusterId from
organization
<Jan 9, 2007 12:04:00 AM CST> <Warning>
<org.hibernate.util.JDBCExceptionReporter> <000000> <SQL Error: 17006,
SQLState: null
<Jan 9, 2007 12:04:00 AM CST>
<Error> <org.hibernate.util.JDBCExceptionReporter> <000000> <Invalid
column name
<Jan 9, 2007 12:04:00 AM CST>
<Error> <com.uscellular.shared.services.hibernate.OrganizationDAO>
<000000> <get failed
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1518)
at org.hibernate.loader.Loader.list(Loader.java:1498)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:103)
Truncated. see log file for complete stacktrace
java.sql.SQLException: Invalid column name
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3291)
at
oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1914)
Truncated. see log file for complete stacktrace
org.hibernate.exception.SQLGrammarException: could not execute
query
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1518)
at org.hibernate.loader.Loader.list(Loader.java:1498)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:103)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1340)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:151)
at
com.uscellular.shared.services.hibernate.OrganizationDAO.getAll(OrganizationDAO.java:68)
Any help in this is appreciated, I am wondering, why this could be a problem, ( because of
any mistake in my configuration or .hbm.xml file ) or something else. when the sql is
perfectly running file
I have tried to remove the 'AS' clause in SQL - did not work
I tried to put like ' ORGANIZATION_KEY AS Organization.organizationKey ' = did not
work
I tried to put ' From Organization org ' alias in table name - did not work
I have tried putting the Oracle schema.table name in the query - Did not work.
please help !!!!!!!!!!!!!!!!!! have already spent a week worth of time on this issue
already.
Thanks
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira