CreateNativeQuery ResultSet mapping [message #531509] |
Wed, 05 May 2010 05:40  |
Eclipse User |
|
|
|
Hi,
I have problem running native query. The getSingleResult fills only datum filed and the ks field is always null. No exception is thrown. Can anybody help?
Thanks
Pavel
private Stat getExpediceData(Vykladka vykladka, Date datum)
queryString = "select datum, ks from vykaz v join expedice e on v.idexpedice=e.idexpedice where e.datum = ? and v.idvykladka=?";
Query q = em.createNativeQuery(queryString, Stat.class);
q.setParameter(1, datum, TemporalType.DATE);
q.setParameter(2, vykladka.getIdvykladka());
Stat stat = (Stat) q.getSingleResult();
return stat;
@Entity
public class Stat implements Serializable {
@Id
@Temporal(TemporalType.DATE)
@Column(name = "datum")
private Date datum;
@Column(name = "ks")
private Integer ks;
@Column(name = "remitenda")
private Integer remitenda;
@Column(name = "cas_zavozu")
private String casZavozu;
getters and setters
}
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03824 seconds