[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-331) Problem with create Query

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Fri, 12 Sep 2003 9:30 PM
       Body:
There is an example exactly like this in the test suite. So you'll have to submit actual code, so I can reproduce this.
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-331


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-331
    Summary: Problem with create Query
       Type: Bug

     Status: Unassigned
   Priority: Critical

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.1

   Assignee: 
   Reporter: Osvaldo Andres Cifuentes

    Created: Fri, 12 Sep 2003 5:26 PM
    Updated: Fri, 12 Sep 2003 5:26 PM
Environment: windows 2000 server spanish,xdoclet,jboss 3.2.1,jdk 1.4.2,oracle 9i Enterprise Edition

Description:
I'm using Session createQuery from Hibernate 2.0.1, the source look like this:

List tipos = new ArrayList();
for(int lu=0;lu<ti.length;lu++)
	tipos.add(ti[lu]);
Query q = sess.createQuery("from Cliente cliente where cliente.identificacionPK.tipoIdentidad in (:tiposIdentidad) and cliente.identificacionPK.identidad like (:identidad)");
q.setParameterList("tiposIdentidad", tipos);
q.setString("identidad", i+"%");
List client=q.list();

with this code i put the query on a list

for (int k=1;k<=client.size();k++){
	Cliente cli=(Cliente)client.get(k);
	log.debug(cli.getNombres());
}


			
the Hibernate generated SQL source is OK. (I already tasted)

But when I look the client list, i can see that the first data is overwriting the others, The same
numbers of times than must have the query.
For example:

*The expected result:

id   name
__________
1	a
2	b
3	c
4	d
5	e
6	f
7	g


*The actual result:

id   name
__________
1	a
1	a
1	a
1	a
1	a
1	a
1	a

I hope any one can help me, I'll be very thankful


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira