Invalid Column Name

[pankaj semwal]

I am giving the following exception when i call this

S

tring name = getSession()
      .getNamedQuery("person")
      .setParameter("CMP", "H")
	  .setParameter("CORP", "A10AA")
	  .setParameter("DLR", "W3203")
	  .setParameter("CLM", "A00056")
	  .setParameter("PART", "4333137010").uniqueResult().toString();

2011/06/05 16:43:29 ERROR exceptionOccured(Slf4jSpyLogDelegator.java:103) - 3. ResultSet.getString(BRCD_CMPN_NO)
java.sql.SQLException: Invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:6348)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1557)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1549)
at net.sf.log4jdbc.ResultSetSpy.getString(ResultSetSpy.java:1773)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
at org.hibernate.type.StringType.get(StringType.java:41)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>

	<class name="hmil.com.barcode.model.BarCodeEntry" table="REBRCD_TB" >
		<composite-id>		 
			<key-property name="BRCD_CMPN_NO"    type="java.lang.String" ></key-property>	
			<key-property name="BRCD_CORP_NO"  type="java.lang.String" ></key-property>
		    <key-property  name="BRCD_DLR_NO"   type="java.lang.String"     ></key-property>
		    <key-property  name="BRCD_WCLM_NO"   type="java.lang.String"     ></key-property>
		    <key-property  name="BRCD_PART_NO"   type="java.lang.String"     ></key-property>
		</composite-id>
				  	
		 <property name="BRCD_BARCODE_VALUE" column="BRCD_BARCODE_VALUE" type="java.lang.String"  not-null="true" />
		 <property name="BRCD_STAT" column="BRCD_STAT "	type="java.lang.String"  />
		 <property name="BRCD_REMARK" column="BRCD_REMARK "	type="java.lang.String"  />
		 <property name="BRCD_CRTE_TIME" column="BRCD_CRTE_TIME "	type="java.sql.Timestamp"  />
		 <property name="BRCD_CRTE_EMP_NO" column="BRCD_CRTE_EMP_NO "	type="java.lang.String"  />
		 <property name="BRCD_UPDT_TIME" column="BRCD_UPDT_TIME "	type="java.sql.Timestamp"  />
		 <property name="BRCD_UPDT_EMP_NO" column="BRCD_UPDT_EMP_NO "	type="java.lang.String"  />
		
	 
            <loader query-ref="person"/>        
          
	</class>
	
	     
        <sql-query name="person"  >   
         <return   class="hmil.com.barcode.model.BarCodeEntry"   /> 
         select FNC_GET_PARTNAME(:CMP,:CORP,:DLR,:CLM,:PART)   from dual
        </sql-query>
        
</hibernate-mapping>

Please tell me where i am wrong.

[in Mkumar]

Hey,

As per exception "java.sql.SQLException: Invalid column name", as of now i can suggest please verify the name of the databased fields available in the mapping file with database and pojo class.

I believe field name is mismatching some where in the mapping file/pojo with DB.

-Manoj