Pessoal nao consegui encontrar o topico que eu escrevi anteriormente !!!!
Eu estou com problemas de obter os dados de uma query em Hibernate, pois a query me retorna 3 linhas da base de dados, mas quando imprimo os atributos do bean, me mostra os mesmos dados 3 vezes.
Deveria mostrar tres linhas com dados diferentes.
o codigo da Query eh este:
package imss.gob.mx.factory;
import org.hibernate.Session;
import org.hibernate.Query;
import org.hibernate.Transaction;
import java.util.List;
import java.util.Iterator;
import imss.gob.mx.bean.GlcoArgu;
public class Querys {
public void getGlcoArgu(String vs_ide_pro, String vs_ide_pcc, int vn_key_usu)
{
Session sessao = HibernateUtility.getSession();
Transaction tx = sessao.beginTransaction();
String sql = "select g FROM GlcoArgu as g WHERE g.ARG_IDEPRO = :vs_ide_pro "+
" AND g.ARG_IDEPCC = :vs_ide_pcc "+
" AND g.ARG_KEYUSU = :vn_key_usu ";
Query select = sessao.createQuery(sql);
select.setString("vs_ide_pro", "CRRE");
select.setString("vs_ide_pcc", "99407519");
select.setInteger("vn_key_usu",8828865);
List objetos = select.list();
System.out.println(objetos);
tx.commit();
System.out.println("Querys debug11");
Iterator it = objetos.iterator();
while(it.hasNext())
{
GlcoArgu glcoargu = (GlcoArgu)it.next();
System.out.println("ARG_KEYCAM: "+glcoargu.getARG_KEYCAM());
System.out.println("ARG_PVALOR: "+glcoargu.getARG_PVALOR());
System.out.println("ARG_DESCAM: "+glcoargu.getARG_DESCAM());
}
sessao.close();
}
}
O Bean que estou usando eh este:
package imss.gob.mx.bean;
import java.util.*;
/**
* GlcoArgu generated by hbm2java
*/
public class GlcoArgu implements java.io.Serializable {
// Fields
private String ARG_IDEPRO;
private String ARG_IDEPCC;
private Integer ARG_KEYUSU;
private Date ARG_FECINI;
private String ARG_HORINI;
private String ARG_PVALOR;
private String ARG_KEYCAM;
private String ARG_DESCAM;
static final long serialVersionUID = 1L;
// Constructors
/** default constructor */
public GlcoArgu() {
}
/** constructor with id */
public GlcoArgu(Integer ARG_KEYUSU) {
this.ARG_KEYUSU = ARG_KEYUSU;
}
/**
*
*/
public String getARG_IDEPRO() {
return this.ARG_IDEPRO;
}
public void setARG_IDEPRO(String ARG_IDEPRO) {
this.ARG_IDEPRO = ARG_IDEPRO;
}
/**
*
*/
public String getARG_IDEPCC() {
return this.ARG_IDEPCC;
}
public void setARG_IDEPCC(String ARG_IDEPCC) {
this.ARG_IDEPCC = ARG_IDEPCC;
}
/**
*
*/
public Integer getARG_KEYUSU() {
return this.ARG_KEYUSU;
}
public void setARG_KEYUSU(Integer ARG_KEYUSU) {
this.ARG_KEYUSU = ARG_KEYUSU;
}
/**
*
*/
public Date getARG_FECINI() {
return this.ARG_FECINI;
}
public void setARG_FECINI(Date ARG_FECINI) {
this.ARG_FECINI = ARG_FECINI;
}
/**
*
*/
public String getARG_HORINI() {
return this.ARG_HORINI;
}
public void setARG_HORINI(String ARG_HORINI) {
this.ARG_HORINI = ARG_HORINI;
}
/**
*
*/
public String getARG_PVALOR() {
return this.ARG_PVALOR;
}
public void setARG_PVALOR(String ARG_PVALOR) {
this.ARG_PVALOR = ARG_PVALOR;
}
/**
*
*/
public String getARG_KEYCAM() {
return this.ARG_KEYCAM;
}
public void setARG_KEYCAM(String ARG_KEYCAM) {
this.ARG_KEYCAM = ARG_KEYCAM;
}
/**
*
*/
public String getARG_DESCAM() {
return this.ARG_DESCAM;
}
public void setARG_DESCAM(String ARG_DESCAM) {
this.ARG_DESCAM = ARG_DESCAM;
}
}
<?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="imss.gob.mx.bean.GlcoArgu" table="GlcoArgu">
<id name="ARG_KEYUSU" type="java.lang.Integer" unsaved-value="null">
<column name="ARG_KEYUSU" />
<generator class="assigned" />
</id>
<property name="ARG_IDEPRO" type="java.lang.String">
<column name="ARG_IDEPRO" />
</property>
<property name="ARG_IDEPCC" type="java.lang.String">
<column name="ARG_IDEPCC" />
</property>
<property name="ARG_KEYUSU" type="java.lang.Integer" update="false" insert="false">
<column name="ARG_KEYUSU" />
</property>
<property name="ARG_FECINI" type="java.util.Date">
<column name="ARG_FECINI" />
</property>
<property name="ARG_HORINI" type="java.lang.String">
<column name="ARG_HORINI" />
</property>
<property name="ARG_PVALOR" type="java.lang.String">
<column name="ARG_PVALOR" />
</property>
<property name="ARG_KEYCAM" type="java.lang.String">
<column name="ARG_KEYCAM" />
</property>
<property name="ARG_DESCAM" type="java.lang.String">
<column name="ARG_DESCAM" />
</property>
</class>
</hibernate-mapping>
