The queries in question have been validated to have rows in the target database (oracle 10g) by
a. setting show_sql=true
b. cutting and pasting the sql generated by hibernate
c. substituting the bind parameter ? with the query value, that is printed directly before the hibernate query is executed.

About half of the queries are returning data properly and the others return 0 rows. No discernible pattern among the working / non working ones.

Before I try to provide lots of details here with the schema, code, etc, and which may be difficult to provide with high precision, does anyone have an "inkling" what may be going on?

I.e. maybe some of you out here have seen this same behavior.

thanks,
steveb