the syntax select new MyObject(Integer a).... may be a Bug

was92 · **Posted:** Mon Feb 16, 2004 6:26 am

Hello,

I have a problem concerning HQL querys.
I can't get Integer or Short Object using the syntax "select new ......"

the code is this one:

*********************************************************

public List getListeParametreFCP() throws RunTimeApplicationException {
Session session = newSession("fcp");
List listeTestHibernate = null;
Logger log = Logger.getLogger(this.getClass());
try {
StringBuffer requete = new StringBuffer();

requete.append("select new fr.bdpme.fcp.business.service.util.TestHibernate( ");
requete.append("temescli.nmecli, ");
requete.append("temescli.dfvame");
requete.append(", temescli.ddvame, temescli.lmesdi, ");
requete.append("temescli.sdemaj, temescli.udemaj ) ");
requete.append(" from fr.business.bean.Temescli as temescli ");

listeTestHibernate = session.find(requete.toString());
} catch (HibernateException ex) {
ex.printStackTrace();
throw new RunTimeApplicationException("Impossible de lancer la recherche des TestHibernate");
} finally {

try {
session.close();
} catch (HibernateException ex) {
throw new RunTimeApplicationException("Impossible de fermer la session hibernate");
}
return listeTestHibernate;
}

}

************************************************************

the pseudo Bean object that have the same propertys as my mapping object.

package fr.business.service.util;

import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/** @author Hibernate CodeGenerator */
public class TestHibernate {

/** identifier field */
private Integer nmecli;

/** nullable persistent field */
private java.util.Date dfvame;

/** nullable persistent field */
private java.util.Date ddvame;

/** nullable persistent field */
private String lmesdi;

/** nullable persistent field */
private String sdemaj;

/** nullable persistent field */
private String udemaj;

/** full constructor */
public TestHibernate(java.lang.Integer nmecli, java.util.Date dfvame, java.util.Date ddvame, java.lang.String lmesdi, java.lang.String sdemaj, java.lang.String udemaj) {
this.nmecli = nmecli;
this.dfvame = dfvame;
this.ddvame = ddvame;
this.lmesdi = lmesdi;
this.sdemaj = sdemaj;
this.udemaj = udemaj;
}

/** full constructor*/
public TestHibernate(int nmecli, java.util.Date dfvame, java.util.Date ddvame, java.lang.String lmesdi, java.lang.String sdemaj, java.lang.String udemaj) {

this.nmecli = new Integer(nmecli);

this.dfvame = dfvame;
this.ddvame = ddvame;
this.lmesdi = lmesdi;
this.sdemaj = sdemaj;
this.udemaj = udemaj;
}

/** default constructor */
public TestHibernate() {
}

/** minimal constructor */
public TestHibernate(java.lang.Integer nmecli) {
this.nmecli = nmecli;
}

public java.lang.Integer getNmecli() {
return this.nmecli;
}

public void setNmecli(java.lang.Integer nmecli) {
this.nmecli = nmecli;
}

public java.util.Date getDfvame() {
return this.dfvame;
}

public void setDfvame(java.util.Date dfvame) {
this.dfvame = dfvame;
}

public java.util.Date getDdvame() {
return this.ddvame;
}

public void setDdvame(java.util.Date ddvame) {
this.ddvame = ddvame;
}

public java.lang.String getLmesdi() {
return this.lmesdi;
}

public void setLmesdi(java.lang.String lmesdi) {
this.lmesdi = lmesdi;
}

public String toString() {
return new ToStringBuilder(this)
.append("nmecli", getNmecli())
.toString();
}

public boolean equals(Object other) {
if ( !(other instanceof TestHibernate) ) return false;
TestHibernate castOther = (TestHibernate) other;
return new EqualsBuilder()
.append(this.getNmecli(), castOther.getNmecli())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getNmecli())
.toHashCode();
}

/**
* @return
*/
public String getSdemaj() {
return sdemaj;
}

/**
* @return
*/
public String getUdemaj() {
return udemaj;
}

/**
* @param string
*/
public void setSdemaj(String string) {
sdemaj = string;
}

/**
* @param string
*/
public void setUdemaj(String string) {
udemaj = string;
}

}

**************************************************************
My mapping object

package fr.business.bean;

import java.io.Serializable;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/** @author Hibernate CodeGenerator */
public class Temescli implements Serializable {

/** identifier field */
private Integer nmecli;

/** nullable persistent field */
private java.util.Date dfvame;

/** nullable persistent field */
private java.util.Date ddvame;

/** nullable persistent field */
private String lmesdi;

/** nullable persistent field */
private String sdemaj;

/** nullable persistent field */
private String udemaj;

/** full constructor */
public Temescli(java.lang.Integer nmecli, java.util.Date dfvame, java.util.Date ddvame, java.lang.String lmesdi, java.lang.String sdemaj, java.lang.String udemaj) {
this.nmecli = nmecli;
this.dfvame = dfvame;
this.ddvame = ddvame;
this.lmesdi = lmesdi;
this.sdemaj = sdemaj;
this.udemaj = udemaj;
}

/** default constructor */
public Temescli() {
}

/** minimal constructor */
public Temescli(java.lang.Integer nmecli) {
this.nmecli = nmecli;
}

public java.lang.Integer getNmecli() {
return this.nmecli;
}

public void setNmecli(java.lang.Integer nmecli) {
this.nmecli = nmecli;
}

public java.util.Date getDfvame() {
return this.dfvame;
}

public void setDfvame(java.util.Date dfvame) {
this.dfvame = dfvame;
}

public java.util.Date getDdvame() {
return this.ddvame;
}

public void setDdvame(java.util.Date ddvame) {
this.ddvame = ddvame;
}

public java.lang.String getLmesdi() {
return this.lmesdi;
}

public void setLmesdi(java.lang.String lmesdi) {
this.lmesdi = lmesdi;
}

public String toString() {
return new ToStringBuilder(this)
.append("nmecli", getNmecli())
.toString();
}

public boolean equals(Object other) {
if ( !(other instanceof Temescli) ) return false;
Temescli castOther = (Temescli) other;
return new EqualsBuilder()
.append(this.getNmecli(), castOther.getNmecli())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getNmecli())
.toHashCode();
}

/**
* @return
*/
public String getSdemaj() {
return sdemaj;
}

/**
* @return
*/
public String getUdemaj() {
return udemaj;
}

/**
* @param string
*/
public void setSdemaj(String string) {
sdemaj = string;
}

/**
* @param string
*/
public void setUdemaj(String string) {
udemaj = string;
}

}
*************************************************************

The mapping file:

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

<hibernate-mapping>



<class
name="fr.business.bean.Temescli"
table="TEMESCLI"
>
<id
name="nmecli"
type="java.lang.Integer"
column="NMECLI"
>
<generator class="assigned" />
</id>
<property
name="dfvame"
type="java.sql.Date"
column="DFVAME"
length="10"
/>
<property
name="ddvame"
type="java.sql.Date"
column="DDVAME"
length="10"
/>
<property
name="lmesdi"
type="java.lang.String"
column="LMESDI"
length="240"
/>
<property
name="sdemaj"
type="java.lang.String"
column="SDEMAJ"
length="26"
/>
<property
name="udemaj"
type="java.lang.String"
column="UDEMAJ"
length="8"
/>



</class>
</hibernate-mapping>

************************************************************
If I use the constructor with an int type there's no problem ....
If I use the constructor with Integer I have One ....
The problem is that there 's a lot of nullable values in my Database ...
not only in an ID but in propertys too .....

the stack is here:

java.lang.NoSuchMethodException: <init>
at java.lang.Class.getConstructor0(Native Method)
at java.lang.Class.getConstructor(Class.java(Compiled Code))
at net.sf.hibernate.hql.QueryTranslator.renderSQL(QueryTranslator.java:534)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:152)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:133)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:352)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:330)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1368)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1332)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1322)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1314)
at fr.business.service.util.ServiceTestHibernate.getListeParametreFCP(ServiceTestHibernate.java:59)
at fr.business.service.util.ServiceTestHibernateTest.testGetListeParametreFCP(ServiceTestHibernateTest.java:44)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)
rethrown as net.sf.hibernate.QueryException: could not find constructor for: fr.business.service.util.TestHibernate: <init> [select new fr.business.service.util.TestHibernate( temescli.nmecli, temescli.dfvame, temescli.ddvame, temescli.lmesdi, temescli.sdemaj, temescli.udemaj ) from fr.bdpme.fcp.business.bean.Temescli as temescli ]
at net.sf.hibernate.hql.QueryTranslator.renderSQL(QueryTranslator.java:537)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:152)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:133)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:352)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:330)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1368)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1332)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1322)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1314)
at fr.business.service.util.ServiceTestHibernate.getListeParametreFCP(ServiceTestHibernate.java:59)
at fr.business.service.util.ServiceTestHibernateTest.testGetListeParametreFCP(ServiceTestHibernateTest.java:44)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)
************************************************************

who can help me?

Thanks a lot by advance,

Best regards,

Mehdi

michael · **Posted:** Mon Feb 16, 2004 9:23 am

Are you sure? Please narrow down the example to reproduce only the problem, remove all the other propertys and stuff and post it. This will make it much easier for us to reproduce your problem.

emmanuel · **Posted:** Mon Feb 16, 2004 10:48 am

Try to recompile hibernate with your JDK and give it a shot.

was92 · **Posted:** Mon Feb 16, 2004 12:48 pm

I've done a new example with a new table and i have the same error.
this example is simple ....

here is the code:

************************************************************

Code:

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

<!-- 
    Created by Middlegen Hibernate plugin

    http://boss.bekk.no/boss/middlegen/
    http://hibernate.sourceforge.net/
-->

<class 
    name="fr.bdpme.fcp.business.bean.Test" 
    table="TEST"
>
     <id
        name="num"
        type="java.lang.Integer"
        column="NUM"
    >
        <generator class="assigned" />
    </id>
    <property
        name="column_test"
        type="java.lang.Integer"
        column="COLUMN_TEST"
    />
  
</class>
</hibernate-mapping>

**********************************************************

Code:

package fr.bdpme.fcp.business.bean;

import java.io.Serializable;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/** @author Hibernate CodeGenerator */
public class Test implements Serializable {

    /** identifier field */
    private int num;

    /** nullable persistent field */
    private Integer column_test;

   
    /** full constructor */
    public Test(int num, java.lang.Integer column_test) {
        this.num = num;
        this.column_test = column_test;
      
    }

    /** default constructor */
    public Test() {
    }

    /** minimal constructor */
    public Test(int num) {
        this.num = num;
    }

  

    public String toString() {
        return new ToStringBuilder(this)
            .append("num", getNum())
            .toString();
    }

    public boolean equals(Object other) {
        if ( !(other instanceof Test) ) return false;
        Test castOther = (Test) other;
        return new EqualsBuilder()
            .append(this.getNum(), castOther.getNum())
            .isEquals();
    }

    public int hashCode() {
        return new HashCodeBuilder()
            .append(getNum())
            .toHashCode();
    }


   /**
    * @return
    */
   public Integer getColumn_test() {
      return column_test;
   }

   /**
    * @return
    */
   public int getNum() {
      return num;
   }

   /**
    * @param integer
    */
   public void setColumn_test(Integer integer) {
      column_test = integer;
   }

   /**
    * @param i
    */
   public void setNum(int i) {
      num = i;
   }

}

**********************************************************

Code:

public List getListeTest() throws RunTimeApplicationException {
         Session session = newSession("fcp");
         List   listeTestHibernate = null;
         Logger log = Logger.getLogger(this.getClass());
         try {
            StringBuffer requete = new StringBuffer();

            requete.append("select new fr.bdpme.fcp.business.service.util.MyBean( ");
            requete.append("test.num, test.column_test )");
            requete.append("from fr.bdpme.fcp.business.bean.Test as test ");
      
            listeTestHibernate = session.find(requete.toString());
         } catch (HibernateException ex) {
            ex.printStackTrace();
            throw new RunTimeApplicationException("Impossible de lancer la recherche des TestHibernate");
         } finally {

            try {
               session.close();
            } catch (HibernateException ex) {
               throw new RunTimeApplicationException("Impossible de fermer la session hibernate");
            }
            return listeTestHibernate;
         }
      
      
      }

*************************************************************

Code:

package fr.bdpme.fcp.business.service.util;

/**
 * @author M65131
 *
 * To change the template for this generated type comment go to
 * Window&gt;Preferences&gt;Java&gt;Code Generation&gt;Code and Comments
 */
public class MyBean {
   
   private int number;
   private Integer buggedAttribut ;
   
   
   public MyBean(int number, Integer buggedAttribut){
   this.number = number;
   this.buggedAttribut = buggedAttribut;
   
   }
   /** [i][b]when i put this method between  comments i have an error !!!!!![/b][/i]   public MyBean(int number, int buggedAttribut){
      this.number = number;
      
      //-------- its working with this code but not with the code at the TOP !!!!!!!!!
      this.buggedAttribut = new Integer(buggedAttribut);
   
      }
   **/
   
   /**
    * @return
    */
   public Integer getBuggedAttribut() {
      return buggedAttribut;
   }

   /**
    * @return
    */
   public int getNumber() {
      return number;
   }

   /**
    * @param integer
    */
   public void setBuggedAttribut(Integer integer) {
      buggedAttribut = integer;
   }

   /**
    * @param i
    */
   public void setNumber(int i) {
      number = i;
   }

}

***********************************************************
the stack :

java.lang.NoSuchMethodException: <init>
at java.lang.Class.getConstructor0(Native Method)
at java.lang.Class.getConstructor(Class.java(Compiled Code))
at net.sf.hibernate.hql.QueryTranslator.renderSQL(QueryTranslator.java:534)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:152)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:133)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:352)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:330)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1368)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1332)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1322)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1314)
at fr.bdpme.fcp.business.service.util.ServiceTestHibernate.getListeTest(ServiceTestHibernate.java:96)
at fr.bdpme.fcp.business.service.util.ServiceTestHibernateTest.testGetListeTest(ServiceTestHibernateTest.java:53)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)
rethrown as net.sf.hibernate.QueryException: could not find constructor for: fr.bdpme.fcp.business.service.util.MyBean: <init> [select new fr.bdpme.fcp.business.service.util.MyBean( test.num, test.column_test )from fr.bdpme.fcp.business.bean.Test as test ]
at net.sf.hibernate.hql.QueryTranslator.renderSQL(QueryTranslator.java:537)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:152)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:133)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:352)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:330)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1368)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1332)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1322)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1314)
at fr.bdpme.fcp.business.service.util.ServiceTestHibernate.getListeTest(ServiceTestHibernate.java:96)
at fr.bdpme.fcp.business.service.util.ServiceTestHibernateTest.testGetListeTest(ServiceTestHibernateTest.java:53)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)

***********************************************************

What can I do ??????
I really think that's a bug !!!!!!!

/** when i put this method in MyBean between comments i have an error !!!!!! public MyBean(int number, int buggedAttribut){
this.number = number;

//-------- its working with this code but not with the code at the TOP !!!!!!!!!
this.buggedAttribut = new Integer(buggedAttribut);

}
**/

was92 · **Posted:** Mon Feb 16, 2004 12:52 pm

little error in the mapping ... for num ... modify Integer by int ...

But he probleme is still here !!!!!!!!!

emmanuel · **Posted:** Mon Feb 16, 2004 12:55 pm

Read my post and stop using !!!! you'll break you key.

michael · **Posted:** Mon Feb 16, 2004 1:00 pm

Are you using a recent Version of Hibernate?

michael · **Posted:** Mon Feb 16, 2004 1:15 pm

I think you are using an old version. There is a JIRA entry describing your problem which has been fixed in 2.1 RC6: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-97

was92 · **Posted:** Mon Feb 16, 2004 1:21 pm

It's very quite similar ...I ll try with a new version this night.

thanks by advance,

michael · **Posted:** Mon Feb 16, 2004 1:24 pm

Little suggestion: If you think there is a Bug, trying with a new Version is the first thing you should try. If you can't for some reason, at least do a JIRA search if that supposed Bug has already been fixed or resolved otherwise.