EntityManager returns wrong number of results

[dornus]

I have the following query.
When I run it, it returns 1 row.

When I copy and paste the IDENTICAL query into MySql it returns 2 rows.

What is going on???

public void test(String ids, int userId){
 System.out.println(
 "select * from My_Table o " +
 " where o.userId = "+userId+
 " and o.id in ( "+ids+" ) "
 );

 final Query q = em.createNativeQuery(
 "select * from My_Table o " +
 "where o.userId = :userId "+
 "and o.id in ( :ids ) ", My_Table.class
 );
 q.setParameter("ids", ids);
 q.setParameter("userId", userId);

 List<My_Table> results = q.getResultList();
 System.out.println("Size: "+results.size());
}

Running the method above I get

 INFO [STDOUT] select * from My_Table o where o.userId = 4 and o.id in ( 5,2 )
 INFO [STDOUT] Size: 1



Copy and pasting that query directly into MySql results in 2 rows

[dornus]

And my setup is
- EJB RC3
- 4.0.3AS
- MySql 5.0.15
- Connector/J 3.1.11
- Java 1.5.0_05
- WinXP SP2

[dornus]

Nevermind, I just saw it. I cannot use

and o.id in (:ids)

I'd have to manually insert it similar to

and o.id in ("+ids+")

Too bad the first way doesn't work.

[epbernard]

ids should be a List, not a String

[dornus]

Excellent! That works perfectly.

Thanks!