result set problems

[peter cooke]

Hello Hoping someone can shed some light.


I have the following prepared statment:

 "SELECT svc_clasif_typ, svc_dept_typ, svc_bus_unit_typ FROM
svc_classif_typ WHERE svc_clasif_alt_nam IN (?) ORDER BY svc_dept_typ,
svc_bus_unit_typ, svc_clasif_typ"

When I execute

 ResultSet resultSet= pstmt.executeQuery(); 

it returns 4 rows in the result set. Manually running the query in command line returns 3 rows. I have never experienced a situation where one query returned a different # of rows from the other.


Any explanation for this behavior or suggestions on how to determine cause.

[edited to add line breaks so screen doesn't scroll right]
[ July 20, 2006: Message edited by: Jeanne Boyarsky ]

[Jeanne Boyarsky]

Peter,
I once saw that when I didn't close the ResultSet. Presumably due to a problem with the driver.