Hibernate version:
2.1.7
Mapping documents:
Name and version of the database you are using:
SQLServer 2000
The generated SQL (show_sql=true):
Debug level Hibernate log excerpt:
Code:
select
new RatedCdrEvent( rce.EvtId, rce.EvtDttm, rce.EvtCount, rce.EvtUsage, rce.StmId, rce.TskId, rce.SflId, rce.VersionId, rce.RceId, rce.RceUniqueKey, rce.RceOriginalANo, rce.RceOriginalBNo, rce.RceOriginalCNo, rce.RceANo, rce.RceBNo, rce.RceCNo, rce.RceInRutId, rce.RceOutRutId, rce.BscId, rce.RceGroupKey, rce.RceExtra1, rce.RceExtra2, rce.RceExtra3, rce.RceExtra4, rce.RceExtra5, rce.RceExtra6, rce.RceExtra7, rce.RceExtra8, rce.RceExtra9, rce.RceExtra10 ),
new RatedEvent( rev.EvtId, rev.EvtDttm, rev.EvtCount, rev.EvtUsage, rev.StmId, rev.TskId, rev.SflId, rev.VersionId, rev.RevId, rev.RevCode, rev.RevCount, rev.RevUsage, rev.BipId, rev.BpdId, rev.SvcId, rev.TffId, rev.TabId, rev.BndId, rev.TrnId, rev.RevFromEltId, rev.RevToEltId, rev.RevTrnCount, rev.RevAmt, rev.CurId, rev.RevBilledUsage, rev.RevRevenueFl, rev.RevRateModifier )
from RatedEvent as rev, RatedCdrEvent as rce
where rev.EvtId = rce.EvtId and rev.EvtDttm >= :evtFromDttm and rev.EvtDttm <= :evtToDttm and rev.BpdId = :bpdId and rev.RevCode = :revCode and rev.StmId = :stmId
Is this query with two constructors allowed by the syntax. If not, would it be easy to change given a few pointers? It doesn't seem to work at the moment as I'm getting a scalar 114 return types which is the above combined x2 which is odd, which then breaks trying to build the constructor.
Login
FAQ
Search
