I have the following hibernate code that queries a table and brings back
rows. Hibernate brings back the proper number of rows (3), but each object
(row) is identical - the first one.
StringBuffer query = new StringBuffer();
query.append("from cr in class
com.comcast.cable.dmc.itd.cct.persistence.ChangeRequestDetail ");
query.append("where (cr.msoId=? and cr.headendId=?) ");
query.append("or (cr.msoId=0) or (cr.headendId=0) ");
query.append("order by cr.msoName");
ses = HibernateSession.currentSession();
// create arrays of variables to bind and types
Object[] vars = new Object[] { msoId, headendId };
Type[] types = new Type[] { Hibernate.LONG, Hibernate.LONG };
crList = (List) ses.find(query.toString(), vars, types);
When I run this query in Oracle's sqlplus, I get 3 unique rows:
MSO_DESC HEADEND_NAME FORM_DESC
------------------------------ ------------------------------
----------------
AT&T AMERICAN CANYON, CA HSCRF
AT&T AMERICAN CANYON, CA CMCF
AT&T AMERICAN CANYON, CA CMCF
Here's the identical objects from my test:
[junit] DEBUG [main]
ChangeRequestDAOHibernateTest.testGetChangeRequests(81) | [com.comcast.cabl
e.dmc.itd.cct.persistence.ChangeRequestDetail
[junit] msoName=AT&T
[junit] headendName=AMERICAN CANYON, CA
[junit] crStatusId=160
[junit] crStatus=Warning
[junit] formId=700
[junit] formName=HSCRF
[junit] sheetId=800
[junit] sheetName=HSCRF_SIGNAL
[junit] statusId=160
[junit] status=Warning
[junit] , com.comcast.cable.dmc.itd.cct.persistence.ChangeRequestDetail
[junit] msoName=AT&T
[junit] headendName=AMERICAN CANYON, CA
[junit] crStatusId=160
[junit] crStatus=Warning
[junit] formId=700
[junit] formName=HSCRF
[junit] sheetId=800
[junit] sheetName=HSCRF_SIGNAL
[junit] statusId=160
[junit] status=Warning
[junit] , com.comcast.cable.dmc.itd.cct.persistence.ChangeRequestDetail
[junit] msoName=AT&T
[junit] headendName=AMERICAN CANYON, CA
[junit] crStatusId=160
[junit] crStatus=Warning
[junit] formId=700
[junit] formName=HSCRF
[junit] sheetId=800
[junit] sheetName=HSCRF_SIGNAL
[junit] statusId=160
[junit] status=Warning
[junit] ]
Thanks,
Matt
-------------------------------------------------------
This SF.NET email is sponsored by: Take your first step towards giving
your online business a competitive advantage. Test-drive a Thawte SSL
certificate - our easy online guide will show you how. Click here to get
started: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0027en
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
