Hello,

I'm using JBoss 4.0.5.

I want to try to use the powerful feature of EJB QL to specify a constructor within the SELECT clause.
I have try this :

List fctResults = em.createQuery("SELECT" +
" new stesud.salaries.common.signa.Matricule(" +
" c300.tra_matric)" +
" FROM ..." +
" WHERE ..." +
" ORDER BY ...")
.setParameter("...",...)
.getResultList();

the column c300.tra_matric is a String.

But it always returns this error :
javax.ejb.EJBTransactionRolledbackException: java.lang.IllegalArgumentException: org.hibernate.QueryException: could not instantiate: stesud.salaries.common.signa.Matricule

I have try with "new Matricule(...)" only but as the class is not on the same package it returns this error (which is normal) :
javax.ejb.EJBTransactionRolledbackException: java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: Unable to locate class [Matricule] [SELECT new Matricule( ...

So, why it could not be instantiate ???

Thanks for your help.

Olivier

Could you post the code for the class you are trying to instantiate and tell us what type of column is c300.tra_matric?
This is probably due to a couple of probable causes:

1. The class is not available to hibernate's classpath
2. The class is abstract
3. The none of the class's constructors takes the argument types you are passing, e.g. tra_matric is a date and the constructor only takes an integer
4. None of the class's constructors are accessible
5. And, just for completeness cause I am sure you have checked and double checked it, the class's name is misspelled

Good Luck