[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3035) could not read column value from result set: MEDFAC1_14_0_; Invalid column name SQL Error: 17006, SQLState: null

[Rachit (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=33076#action_33076 ] 

Rachit commented on HHH-3035:
-----------------------------

Hi,

 I too have stuck on the issue. I am @SqlResultSetMapping annotation to achieve the same. If somebody has a quick fix other than retrieving all columns,  reply me.

-Thanks

Rachit

> could not read column value from result set: MEDFAC1_14_0_; Invalid column name SQL Error: 17006, SQLState: null
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: HHH-3035
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3035
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core, query-criteria, query-hql, query-sql
>    Affects Versions: 3.2.2
>         Environment: JDK5 , Hibernate Junit Test case,WIndows XP
>            Reporter: sanjeev singh
>
> The following is my section of hibernate mapping file.
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE hibernate-mapping PUBLIC
> 	"-//Hibernate/Hibernate mapping DTD 3.0//EN"
> 	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
> <hibernate-mapping package="gov.njdhss.hippocrates.ems.valueobjects">
> 	<class name="HeprEmsMedfacFacilityVO" table="HEPR_MEDFAC">
> 		<id name="medfacId" column="MEDFAC_ID" type="java.lang.Long">
> 			<generator class="sequence">
> 				<param name="sequence">HEPR_MEDFAC_SEQ</param>
> 			</generator>
> 		</id>
> 		<property name="medfacName" type="java.lang.String"
> 			column="MEDFAC_NAME" update="true" insert="true">
> 		</property>
> 		<property name="facCode" type="java.lang.String"
> 			column="FAC_CODE" update="true" insert="true">
> 		</property>
> 	</class>
> 	
> 	<sql-query name="allfacility">
> 		<return alias="facilities" class="HeprEmsMedfacFacilityVO" >
> 		<return-property name="medfacName" column="MEDFAC_NAME"/>
> 		</return>
> 		<![CDATA[
> 		select facilities.MEDFAC_NAME AS medfacName
> 		from  HEPR_MEDFAC facilities
> 		]]> 
> 	</sql-query>
> </hibernate-mapping>
> I am trying to execute the query using the following client code:
>   public List getAllFacility() {
> 	List listAllFacilities = null;
> 	listAllFacilities = getHibernateTemplate().findByNamedQuery(
> 		"allfacility");
> 	return listAllFacilities;
>     }
> The following is the error:
> Hibernate: 
>     select
>         facilities.MEDFAC_NAME AS medfacName   
>     from
>         HEPR_MEDFAC facilities
> - could not read column value from result set: MEDFAC1_14_0_; Invalid column name
> - SQL Error: 17006, SQLState: null
> - Invalid column name
> - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
> - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
> Any idea if it is a bug or there is any error in my code.

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira