[ http://opensource.atlassian.com/projects/hibernate/browse/HBX-699?page=comments#action_23546 ]
Max Rydahl Andersen commented on HBX-699:
-----------------------------------------
are you sure you are using the hibernate that is bundled with the tools ?
I had to change the queryparametertype handling in the core, so either use the bundled hibernate (to be safe) or
use a build from Hibernate 3.2.x to make this work.
> Incorrect code generation for query-param elements
> --------------------------------------------------
>
> Key: HBX-699
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-699
> Project: Hibernate Tools
> Type: Bug
> Components: hbm2java
> Versions: 3.2beta6
> Environment: Hibernate 3/MySql 5.X
> Reporter: Jak Mang
>
>
> Query params in xml mapping files generate incorrect code for integers and possibly other scalers. In the case below,
> I have tried "int", "integer", "Integer" and "java.lang.Integer" and "Ljava.lang.Integer;" for the type of parameter "region".
> <query name="com.tgcusa.idmgr.ProgramId.findProgramId">
> <query-param name="region" type="integer"/>
> <query-param name="epgser" type="string"/>
> <query-param name="epgepi" type="string"/>
> <![CDATA[
> select pid.tgcsh, pid.tgcser, pid.tgcepi from com.tgcusa.idmgr.ProgramId
> as pid where pid.region == :region and pid.epgser == :epgser and
> pid.epgepi = :epgepi
> ]]>
> </query>
> The code generator always produces:
> public List findTgcSerForEpgSer(int region, java.lang.String tepgser)
> {
> Query query =
> sessionFactory.getCurrentSession().getNamedQuery("com.tgcusa.idmgr.ProgramId.findTgcSerForEpgSer");
> query.setParameter("region", region);
> query.setParameter("tepgser", tepgser);
> return query.list();
> }
> Which has the compilation error:
> [javac] Found 2 semantic errors compiling "/sandbox/mainline/srcroot/sw/tgcs
> vc/lib/java/src/com/tgcusa/idmgr/ProgramIdHome.java":
> [javac] 171. query.setParameter("region", region);
> [javac] ^----------------------------------^
> [javac] *** Semantic Error: No applicable overload for a method with signatu
> re "setParameter(java.lang.String, int)" was found in type "org.hibernate.Query"
> . Perhaps you wanted the overloaded version "org.hibernate.Query setParameter(ja
> va.lang.String $1, java.lang.Object $2) throws org.hibernate.HibernateException;
> " instead?
> It seems that:
> 1) There is ambiguity about the type "integer". I have seen it generate java.lang.Integer in other code.
> 2) for "int", a query.setParameter should support int.
> 3) for an Integer object, the setParameter call is ok, but the the method parameter shoud be Integer not int.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
|
