Query:
SQLQuery qry = HibernateUtil.currentSession().createSQLQuery(" select ordrPosType as ord from STOrderTO STO where "
+"STO.ordrStat in ( 1,2,3,15,16,29,41) "
+"and STO.instrumentId=4276");
qry.addScalar("ord",Hibernate.STRING);
result = qry.list();
mapping 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">
<hibernate-mapping>
<!--
Auto-generated mapping file from
the hibernate.org cfg2hbm engine
-->
<class name="com.tcs.pdn.to.order.STOrderTO" table="ST_ORDER" >
<id name="ordrId" type="integer">
<column name="ORDR_ID" precision="9" scale="0" not-null="true"/>
</id>
<property name="instrumentId" type="integer">
<column name="INSTRMNT_ID" precision="8" scale="0" />
</property>
<property name="ordrStat" type="integer">
<column name="ORDR_STAT" precision="2" scale="0" not-null="true" />
</property>
<property name="ordrPosType" type="integer">
<column name="ORDR_POS_TYPE" precision="4" scale="0" not-null="true" />
</property>
</class>
</hibernate-mapping>
java class:
package com.tcs.pdn.to.order;
import com.tcs.pdn.to.common.PDNBaseTO;
public class STOrderTO extends PDNBaseTO {
private Integer ordrId;
private Integer instrumentId;
private Integer ordrStat;
private Integer ordrPosType;
/** default constructor */
public STOrderTO() {
}
/**
* @return Returns the instrumentId.
*/
public Integer getInstrumentId() {
return instrumentId;
}
/**
* @param instrumentId The instrumentId to set.
*/
public void setInstrumentId(Integer instrumentId) {
this.instrumentId = instrumentId;
}
/**
* @return Returns the ordrId.
*/
public Integer getOrdrId() {
return ordrId;
}
/**
* @param ordrId The ordrId to set.
*/
public void setOrdrId(Integer ordrId) {
this.ordrId = ordrId;
}
/**
* @return Returns the ordrPosType.
*/
public Integer getOrdrPosType() {
return ordrPosType;
}
/**
* @param ordrPosType The ordrPosType to set.
*/
public void setOrdrPosType(Integer ordrPosType) {
this.ordrPosType = ordrPosType;
}
/**
* @return Returns the ordrStat.
*/
public Integer getOrdrStat() {
return ordrStat;
}
/**
* @param ordrStat The ordrStat to set.
*/
public void setOrdrStat(Integer ordrStat) {
this.ordrStat = ordrStat;
}
}
Login
FAQ
Search
