-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 
  Previous topic | Next topic 
Author Message
Paul Newport
 Post subject: NonUniqueObjectException for object read once in session
PostPosted: Mon Oct 04, 2004 4:13 pm 
Senior
Senior

Joined: Tue Aug 03, 2004 2:11 pm
Posts: 142
Location: Somerset
Hibernate version: 2.1.6

First of all sorry about not posting any mapping files etc - my excuse is that our work firewall rules stop me posting to the forum (go figure).

I'm using Spring Hibernate Data Access Objects. In a web front end (struts) a new object is created and persisted away to the database using aforementioned DAOs. The DAO is called from within a session bean, so the hibernate session is scoped to the transaction associated with the EJB call, and I can see the session open and close along with the transactions within the log files.

After the object has been persisted, a JMS message is sent from the front end to a message driven bean, which does a load of long winded, but not time critical processing (i.e. batch work).

On the JMS is the unique identifier (i.e. surrogate key) of the object/record created in the front end. Within the MDB, the Spring Hibernate DAO is used to load up the record into the object, fields on the object are changed, and then saveOrUpdate is called to save away the changed data.

At this point (on the update), I get a NonUniqueObjectException. As far as I can tell (and myself and a colleague have looked at the code very closely over 2 days), there are no other objects within the session scoped by the MDB transaction, so we are at a loss as to why we get the above exception.

Based on the above overview, does anything stand out as being glaringly obvious ?

If need be I can obtain the code and mapping files and post them here.

_________________
On the information super B road

Top
 Profile  
 
Paul Newport
 Post subject:
PostPosted: Wed Oct 06, 2004 4:56 am 
Senior
Senior

Joined: Tue Aug 03, 2004 2:11 pm
Posts: 142
Location: Somerset
Here's the hibernate debug and stack trace. As you can see the SecuredProperty object for id 1000221 is only read once in the session

[06/10/04 09:51:31:895 BST] 7026d309 SystemOut O 2004-10-06 09:51:31,895 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.automaticprocessing.jms.MessageTrafficCopBean - Get Application from ApplicationProcessingMessage jms Queue null
2004-10-06 09:51:32,067 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.automaticprocessing.jms.MessageTrafficCopBean - Finding application
2004-10-06 09:51:32,223 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.dataaccess.BrokerDataAccessObject - Hierarchy filtering app match: select * from applicat ap where appId = ? and ap.userStamp in (select userid from user_hierarchy where childId in (1,2,3,4,5,6,12,14,7,8,9,15,13,16,17))
2004-10-06 09:51:32,504 [MessageListenerThreadPool : 0] ERROR net.targetgroup.broker.automaticprocessing.jms.MessageTrafficCopBean - net.targetgroup.broker.services.ItemNotFoundException: Unable to find application 960
Namespace name: localhost/nodes/localhost/servers/server1
[06/10/04 09:52:12:926 BST] 7026d309 SystemOut O 2004-10-06 09:52:12,926 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.automaticprocessing.jms.MessageTrafficCopBean - Get Application from ApplicationProcessingMessage jms Queue null
2004-10-06 09:52:13,098 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.automaticprocessing.jms.MessageTrafficCopBean - Finding application
2004-10-06 09:52:13,379 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.dataaccess.BrokerDataAccessObject - Hierarchy filtering app match: select * from applicat ap where appId = ? and ap.userStamp in (select userid from user_hierarchy where childId in (1,2,3,4,5,6,12,14,7,8,9,15,13,16,17))
2004-10-06 09:52:13,614 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.SecuredPropertyDAOHibernate - LOADING SECURITY for app: 906
2004-10-06 09:52:13,614 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - opened session
2004-10-06 09:52:13,661 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - find: from SecuredProperty a where a.applicationID = ? and a.type = 'SECURED'
2004-10-06 09:52:13,661 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.engine.QueryParameters - parameters: [906]
2004-10-06 09:52:13,661 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.engine.QueryParameters - named parameters: {}
2004-10-06 09:52:13,692 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.hql.QueryTranslator - compiling query
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - flushing session
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Flushing entities and processing referenced collections
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Processing unreferenced collections
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Scheduling collection removes/(re)creates/updates
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Dont need to execute flush
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.hql.QueryTranslator - HQL: from net.targetgroup.broker.application.SecuredProperty a where a.applicationID = ? and a.type = 'SECURED'
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.hql.QueryTranslator - SQL: select securedpro0_.SECURITYID as SECURITYID, securedpro0_.TYPE as TYPE, securedpro0_.PURCHDATE as PURCHDATE, securedpro0_.PURCHPRICE as PURCHPRICE, securedpro0_.CURVALUE as CURVALUE, securedpro0_.MORTBAL as MORTBAL, securedpro0_.MORTLENDR as MORTLENDR, securedpro0_.MORTREPAY as MORTREPAY, securedpro0_.OTHERBAL as OTHERBAL, securedpro0_.PAYMENTFREQUENCY as PAYMENT10_, securedpro0_.MORTTERM as MORTTERM, securedpro0_.PROPTYPE as PROPTYPE, securedpro0_.RMLEASETRM as RMLEASETRM, securedpro0_.COUNCDPER as COUNCDPER, securedpro0_.COUNCDAMT as COUNCDAMT, securedpro0_.COUNCIL as COUNCIL, securedpro0_.TENURE as TENURE, securedpro0_.PARTLET as PARTLET, securedpro0_.COMMERCIAL as COMMERCIAL, securedpro0_.USERSTAMP as USERSTAMP, securedpro0_.DATEBUILT as DATEBUILT, securedpro0_.DATETIME as DATETIME, securedpro0_.CONSTRUCT as CONSTRUCT, securedpro0_.JOINTOWNED as JOINTOWNED, securedpro0_.BEDROOMS as BEDROOMS, securedpro0_.RECEPTIONS as RECEPTIONS, securedpro0_.BATHROOMS as BATHROOMS, securedpro0_.GARAGES as GARAGES, securedpro0_.FEATURES as FEATURES, securedpro0_.SHAREOWNSC as SHAREOWNSC, securedpro0_.NOSTOREYS as NOSTOREYS, securedpro0_.PPI as PPI, securedpro0_.FLEXIBLE as FLEXIBLE, securedpro0_.DSSASSISTEDFLAG as DSSASSI34_, securedpro0_.HIGHESTPAYMENT as HIGHEST35_, securedpro0_.TOBESOLDFLAG as TOBESOL36_, securedpro0_.SELLINGPRICE as SELLING37_, securedpro0_.ESTIMATEDVALUE as ESTIMAT38_, securedpro0_.VALUATION1 as VALUATION1, securedpro0_.KITCHENS as KITCHENS, securedpro0_.WC as WC, securedpro0_.ACRES as ACRES, securedpro0_.SERVICECHARGE as SERVICE43_, securedpro0_.GROUNDRENT as GROUNDRENT, securedpro0_.NHBCFLAG as NHBCFLAG, securedpro0_.ARCHITECTCERTFLAG as ARCHITE46_, securedpro0_.THIRTYDAYOCCUPANCY as THIRTYD47_, securedpro0_.SECONDPROPERTYFLAG as SECONDP48_, securedpro0_.PROPERTYLETFLAG as PROPERT49_, securedpro0_.CURRENTMONTHLYRENT as CURRENT50_, securedpro0_.POTENTIALMNTHRENT as POTENTI51_, securedpro0_.TOBELETFLAG as TOBELET52_, securedpro0_.TENANCYSTARTDATE as TENANCY53_, securedpro0_.TENANCYTERM as TENANCY54_, securedpro0_.IMPREQUIREDFLAG as IMPREQU55_, securedpro0_.IMPREQUIREDEST as IMPREQU56_, securedpro0_.SUBSIDENCEDETAILS as SUBSIDE57_, securedpro0_.ELECTRICITYFLAG as ELECTRI58_, securedpro0_.WATERFLAG as WATERFLAG, securedpro0_.GASFLAG as GASFLAG, securedpro0_.DRAINAGEFLAG as DRAINAG61_, securedpro0_.OTHERSERVICES as OTHERSE62_, securedpro0_.AGRIRESTRICTFLAG as AGRIRES63_, securedpro0_.EXMODFLAG as EXMODFLAG, securedpro0_.EXPOLICEFLAG as EXPOLIC65_, securedpro0_.EXLOCALAUTHFLAG as EXLOCAL66_, securedpro0_.EXHOUSINGASSFLAG as EXHOUSI67_, securedpro0_.COMMERCIALPURPOSE as COMMERC68_, securedpro0_.PURCHFROMRELFLAG as PURCHFR69_, securedpro0_.RELATIVEDETAILS as RELATIV70_, securedpro0_.VALUATIONTYPE as VALUATI71_, securedpro0_.ANTCOMPLETEDATE as ANTCOMP72_, securedpro0_.ACTCOMPLETEDATE as ACTCOMP73_, securedpro0_.ACCESS as ACCESS, securedpro0_.REBUILDCST as REBUILDCST, securedpro0_.MORTRATE as MORTRATE, securedpro0_.MORTTYPE as MORTTYPE, securedpro0_.REPVEHICLE as REPVEHICLE, securedpro0_.MATUREDATE as MATUREDATE, securedpro0_.MATUREVALUE as MATUREV80_, securedpro0_.INTTYPE as INTTYPE, securedpro0_.PARTYTOMORTGAGE as PARTYTO82_, securedpro0_.ACTIVE as ACTIVE, securedpro0_.APPID as APPID, securedpro0_.CUSTID as CUSTID, securedpro0_.ADDRID as ADDRID from SECURITY securedpro0_ where (securedpro0_.APPID=? )and(securedpro0_.TYPE='SECURED' )
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.SQL - select securedpro0_.SECURITYID as SECURITYID, securedpro0_.TYPE as TYPE, securedpro0_.PURCHDATE as PURCHDATE, securedpro0_.PURCHPRICE as PURCHPRICE, securedpro0_.CURVALUE as CURVALUE, securedpro0_.MORTBAL as MORTBAL, securedpro0_.MORTLENDR as MORTLENDR, securedpro0_.MORTREPAY as MORTREPAY, securedpro0_.OTHERBAL as OTHERBAL, securedpro0_.PAYMENTFREQUENCY as PAYMENT10_, securedpro0_.MORTTERM as MORTTERM, securedpro0_.PROPTYPE as PROPTYPE, securedpro0_.RMLEASETRM as RMLEASETRM, securedpro0_.COUNCDPER as COUNCDPER, securedpro0_.COUNCDAMT as COUNCDAMT, securedpro0_.COUNCIL as COUNCIL, securedpro0_.TENURE as TENURE, securedpro0_.PARTLET as PARTLET, securedpro0_.COMMERCIAL as COMMERCIAL, securedpro0_.USERSTAMP as USERSTAMP, securedpro0_.DATEBUILT as DATEBUILT, securedpro0_.DATETIME as DATETIME, securedpro0_.CONSTRUCT as CONSTRUCT, securedpro0_.JOINTOWNED as JOINTOWNED, securedpro0_.BEDROOMS as BEDROOMS, securedpro0_.RECEPTIONS as RECEPTIONS, securedpro0_.BATHROOMS as BATHROOMS, securedpro0_.GARAGES as GARAGES, securedpro0_.FEATURES as FEATURES, securedpro0_.SHAREOWNSC as SHAREOWNSC, securedpro0_.NOSTOREYS as NOSTOREYS, securedpro0_.PPI as PPI, securedpro0_.FLEXIBLE as FLEXIBLE, securedpro0_.DSSASSISTEDFLAG as DSSASSI34_, securedpro0_.HIGHESTPAYMENT as HIGHEST35_, securedpro0_.TOBESOLDFLAG as TOBESOL36_, securedpro0_.SELLINGPRICE as SELLING37_, securedpro0_.ESTIMATEDVALUE as ESTIMAT38_, securedpro0_.VALUATION1 as VALUATION1, securedpro0_.KITCHENS as KITCHENS, securedpro0_.WC as WC, securedpro0_.ACRES as ACRES, securedpro0_.SERVICECHARGE as SERVICE43_, securedpro0_.GROUNDRENT as GROUNDRENT, securedpro0_.NHBCFLAG as NHBCFLAG, securedpro0_.ARCHITECTCERTFLAG as ARCHITE46_, securedpro0_.THIRTYDAYOCCUPANCY as THIRTYD47_, securedpro0_.SECONDPROPERTYFLAG as SECONDP48_, securedpro0_.PROPERTYLETFLAG as PROPERT49_, securedpro0_.CURRENTMONTHLYRENT as CURRENT50_, securedpro0_.POTENTIALMNTHRENT as POTENTI51_, securedpro0_.TOBELETFLAG as TOBELET52_, securedpro0_.TENANCYSTARTDATE as TENANCY53_, securedpro0_.TENANCYTERM as TENANCY54_, securedpro0_.IMPREQUIREDFLAG as IMPREQU55_, securedpro0_.IMPREQUIREDEST as IMPREQU56_, securedpro0_.SUBSIDENCEDETAILS as SUBSIDE57_, securedpro0_.ELECTRICITYFLAG as ELECTRI58_, securedpro0_.WATERFLAG as WATERFLAG, securedpro0_.GASFLAG as GASFLAG, securedpro0_.DRAINAGEFLAG as DRAINAG61_, securedpro0_.OTHERSERVICES as OTHERSE62_, securedpro0_.AGRIRESTRICTFLAG as AGRIRES63_, securedpro0_.EXMODFLAG as EXMODFLAG, securedpro0_.EXPOLICEFLAG as EXPOLIC65_, securedpro0_.EXLOCALAUTHFLAG as EXLOCAL66_, securedpro0_.EXHOUSINGASSFLAG as EXHOUSI67_, securedpro0_.COMMERCIALPURPOSE as COMMERC68_, securedpro0_.PURCHFROMRELFLAG as PURCHFR69_, securedpro0_.RELATIVEDETAILS as RELATIV70_, securedpro0_.VALUATIONTYPE as VALUATI71_, securedpro0_.ANTCOMPLETEDATE as ANTCOMP72_, securedpro0_.ACTCOMPLETEDATE as ACTCOMP73_, securedpro0_.ACCESS as ACCESS, securedpro0_.REBUILDCST as REBUILDCST, securedpro0_.MORTRATE as MORTRATE, securedpro0_.MORTTYPE as MORTTYPE, securedpro0_.REPVEHICLE as REPVEHICLE, securedpro0_.MATUREDATE as MATUREDATE, securedpro0_.MATUREVALUE as MATUREV80_, securedpro0_.INTTYPE as INTTYPE, securedpro0_.PARTYTOMORTGAGE as PARTYTO82_, securedpro0_.ACTIVE as ACTIVE, securedpro0_.APPID as APPID, securedpro0_.CUSTID as CUSTID, securedpro0_.ADDRID as ADDRID from SECURITY securedpro0_ where (securedpro0_.APPID=? )and(securedpro0_.TYPE='SECURED' )
2004-10-06 09:52:13,739 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
2004-10-06 09:52:13,911 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - binding '906' to parameter: 1
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - processing result set
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - returning '1000221' as column: SECURITYID
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - result row: 1000221
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - Initializing object from ResultSet: 1000221
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - Hydrating entity: net.targetgroup.broker.application.SecuredProperty#1000221
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'SECURED ' as column: TYPE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: PURCHDATE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: PURCHPRICE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: CURVALUE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MORTBAL
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning ' ' as column: MORTLENDR
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MORTREPAY
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: OTHERBAL
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'MONTHLY ' as column: PAYMENT10_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MORTTERM
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'DETACHED ' as column: PROPTYPE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: RMLEASETRM
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: COUNCDPER
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: COUNCDAMT
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: COUNCIL
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'FREEHOLD ' as column: TENURE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PARTLET
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: COMMERCIAL
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'b ' as column: USERSTAMP
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.DateType - returning null as column: DATEBUILT
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: DATETIME
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: CONSTRUCT
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: JOINTOWNED
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: BEDROOMS
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: RECEPTIONS
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: BATHROOMS
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: GARAGES
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: FEATURES
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: SHAREOWNSC
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: NOSTOREYS
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PPI
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: FLEXIBLE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: DSSASSI34_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: HIGHEST35_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: TOBESOL36_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: SELLING37_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: ESTIMAT38_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: VALUATION1
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: KITCHENS
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: WC
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: ACRES
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: SERVICE43_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: GROUNDRENT
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: NHBCFLAG
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: ARCHITE46_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: THIRTYD47_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: SECONDP48_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PROPERT49_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: CURRENT50_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: POTENTI51_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: TOBELET52_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.DateType - returning null as column: TENANCY53_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: TENANCY54_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: IMPREQU55_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: IMPREQU56_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: SUBSIDE57_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: ELECTRI58_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: WATERFLAG
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: GASFLAG
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: DRAINAG61_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N ' as column: OTHERSE62_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: AGRIRES63_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: EXMODFLAG
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: EXPOLIC65_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: EXLOCAL66_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: EXHOUSI67_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: COMMERC68_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PURCHFR69_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: RELATIV70_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: VALUATI71_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.DateType - returning null as column: ANTCOMP72_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.DateType - returning null as column: ACTCOMP73_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ACCESS
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: REBUILDCST
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MORTRATE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: MORTTYPE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: REPVEHICLE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: MATUREDATE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MATUREV80_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: INTTYPE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PARTYTO82_
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: ACTIVE
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning '906' as column: APPID
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: CUSTID
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - returning '1000552' as column: ADDRID
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - done processing result set (1 rows)
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - total objects hydrated: 1
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - resolving associations for [net.targetgroup.broker.application.SecuredProperty#1000221]
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - loading [net.targetgroup.broker.address.Address#1000552]
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - attempting to resolve [net.targetgroup.broker.address.Address#1000552]
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - object not resolved in any cache [net.targetgroup.broker.address.Address#1000552]
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.persister.NormalizedEntityPersister - Materializing entity: [net.targetgroup.broker.address.Address#1000552]
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.SQL - select address0_.ADDRID as ADDRID0_, case when address0__1_.ADDRID is not null then 1 when address0_.ADDRID is not null then 0 end as clazz_0_, address0_.ADDR01 as ADDR011_0_, address0_.ADDR02 as ADDR021_0_, address0_.ADDR03 as ADDR031_0_, address0_.ADDR04 as ADDR041_0_, address0_.ADDR05 as ADDR051_0_, address0_.POSTCODE as POSTCODE1_0_, address0_.USERSTAMP as USERSTAMP1_0_, address0_.DATETIME as DATETIME1_0_, address0__1_.CUSTID as CUSTID2_0_, address0__1_.USERSTAMP as USERSTAMP2_0_, address0__1_.ADDRTYPE as ADDRTYPE2_0_, address0__1_.DATETIME as DATETIME2_0_, address0__1_.MOVEDIN as MOVEDIN2_0_, address0__1_.VOTERSROLL as VOTERSROLL2_0_, address0__1_.MOVEDOUT as MOVEDOUT2_0_, address0__1_.VOTERSIN as VOTERSIN2_0_, address0__1_.OWNERSHIPSTATUS as OWNERSH10_2_0_, address0__1_.VOTERSOUT as VOTERSOUT2_0_ from ADDRESS address0_ left outer join CORR_ADDR address0__1_ on address0_.ADDRID=address0__1_.ADDRID where address0_.ADDRID=?
2004-10-06 09:52:14,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
2004-10-06 09:52:14,270 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - binding '1000552' to parameter: 1
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - processing result set
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - result row: 1000552
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - returning '0' as column: clazz_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - Initializing object from ResultSet: 1000552
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - Hydrating entity: net.targetgroup.broker.address.Address#1000552
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR011_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR021_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR031_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR041_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR051_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: POSTCODE1_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: USERSTAMP1_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: DATETIME1_0_
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - done processing result set (1 rows)
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - total objects hydrated: 1
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - resolving associations for [net.targetgroup.broker.address.Address#1000552]
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - done materializing entity [net.targetgroup.broker.address.Address#1000552]
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - done materializing entity [net.targetgroup.broker.application.SecuredProperty#1000221]
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - initializing non-lazy collections
2004-10-06 09:52:14,458 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.SecuredPropertyDAOHibernate - SECURITY ID READ IS: 1000221
2004-10-06 09:52:17,458 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Getting contained objects
2004-10-06 09:52:17,458 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Loading objects for customer 3096
2004-10-06 09:52:17,458 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - loading customer-correspondent contained objects
2004-10-06 09:52:18,239 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - The list of tels is {HOME=net.targetgroup.broker.correspondent.Telephone@3c1c5324}
2004-10-06 09:52:18,239 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Loading customer correspondents...
2004-10-06 09:52:18,801 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - List of correspondents is [net.targetgroup.broker.correspondent.Correspondent@40489324]
2004-10-06 09:52:18,801 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Getting all employmnets for customer 3096
2004-10-06 09:52:19,520 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Employments are [ID: 1434
BusinessNature: null
Contact: net.targetgroup.broker.correspondent.Correspondent@5cea1324
Department: null
EmploymentDescription:
End Date: null
JobTitle: null
OccupationType: DISABLED
StartDate: null
Salary: Amount: null
TransType: null
Frequency: null
Included: false

]1
2004-10-06 09:52:20,067 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Judgements are []
2004-10-06 09:52:20,426 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Transactions are []
2004-10-06 09:52:20,708 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Bank account number is 1059
2004-10-06 09:52:22,036 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.customer.customerservices.CustomerManagerBean - Lender account groups for customer 3096 are: [net.targetgroup.broker.customer.LenderAccountGroup@2c73d324, net.targetgroup.broker.customer.LenderAccountGroup@20755324]
2004-10-06 09:52:22,520 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationservices.ApplicationManagerBean - Finding product for application 906
2004-10-06 09:52:22,895 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationservices.ApplicationManagerBean - Finding insurance for application 906
2004-10-06 09:52:23,114 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationservices.ApplicationManagerBean - Finding fees for application 906
2004-10-06 09:52:23,536 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationservices.ApplicationManagerBean - Looking for mortgage insurance for application 906
2004-10-06 09:52:24,051 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - find: from SecuredProperty a where a.customerID = ? and a.type = 'CURRENT'
2004-10-06 09:52:24,051 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.engine.QueryParameters - parameters: [3096]
2004-10-06 09:52:24,051 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.engine.QueryParameters - named parameters: {}
2004-10-06 09:52:24,051 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.hql.QueryTranslator - compiling query
2004-10-06 09:52:24,051 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - flushing session
2004-10-06 09:52:24,051 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.engine.Cascades - processing cascades for: net.targetgroup.broker.application.SecuredProperty
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.engine.Cascades - cascading to saveOrUpdate()
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - saveOrUpdate() persistent instance
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.engine.Cascades - done processing cascades for: net.targetgroup.broker.application.SecuredProperty
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Flushing entities and processing referenced collections
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Processing unreferenced collections
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Scheduling collection removes/(re)creates/updates
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Flushed: 0 insertions, 0 updates, 0 deletions to 2 objects
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.Printer - listing entities:
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.Printer - net.targetgroup.broker.application.SecuredProperty{access=null, estimatedValue=null, councilDiscountAmount=null, tenancyTerm=null, userStamp=b , estimateCosts=null, anticipatedCompletionDate=null, architectCertFlag=false, agriculturalRestrictionsFlag=false, expectedMaturityValue=null, tenure=FREEHOLD , propertyType=DETACHED , commercialPurpose=null, mortgageRate=null, groundRent=null, wc=null, waterFlag=false, dssAssistedFlag=false, currentlyRentFlag=false, electricityFlag=false, improvementsFlag=false, propertyToBeSoldFlag=false, mortgageBalance=null, bedrooms=null, shareOwnershipScheme=false, active=false, purchasePrice=null, currentValue=null, garages=null, actualCompletionDate=null, exLocalAuthorityFlag=false, ownership=null, potentialRent=null, mortgageLender= , otherServicesFlag=false, subsidenceHistory=null, ppi=false, nhbcFlag=false, tenancyStartDate=null, rebuildCost=null, numberOfStoreys=null, construction=null, repaymentVehicle=null, address=Address#1000552, sellingPrice=null, drainageFlag=false, exHousingAssociationFlag=false, propertyToBeLetFlag=false, secondApplicantPartyToMortgage=false, paymentFrequency=MONTHLY , kitchens=null, timeStamp=null, interestType=null, mortgageTerm=null, mortgageRepayment=null, acres=null, serviceCharge=null, gasFlag=false, councilDiscountPercentage=null, relativeDetails=null, flexibleMortgage=false, repaymentVehicleMaturityDate=null, type=SECURED , remainingLeaseTerm=null, secondProperty=false, valuation1=null, dateBuilt=null, bathrooms=null, commercial=false, purchaseForRelativeFlag=false, currentRent=null, highestPayment=null, unusualFeatures=null, partLet=false, otherBalance=null, applicationID=906, council=false, exPoliceFlag=false, mortgageType=null, receptions=null, thirtyDayOccupancy=false, valuationType=null, identifier=1000221, purchaseDate=null, exModFlag=false, customerID=null}
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.Printer - net.targetgroup.broker.address.Address{addressLines=[, , , , ], timeStamp=null, postcode=null, userStamp=null, identifier=1000552}
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - Dont need to execute flush
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.hql.QueryTranslator - HQL: from net.targetgroup.broker.application.SecuredProperty a where a.customerID = ? and a.type = 'CURRENT'
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.hql.QueryTranslator - SQL: select securedpro0_.SECURITYID as SECURITYID, securedpro0_.TYPE as TYPE, securedpro0_.PURCHDATE as PURCHDATE, securedpro0_.PURCHPRICE as PURCHPRICE, securedpro0_.CURVALUE as CURVALUE, securedpro0_.MORTBAL as MORTBAL, securedpro0_.MORTLENDR as MORTLENDR, securedpro0_.MORTREPAY as MORTREPAY, securedpro0_.OTHERBAL as OTHERBAL, securedpro0_.PAYMENTFREQUENCY as PAYMENT10_, securedpro0_.MORTTERM as MORTTERM, securedpro0_.PROPTYPE as PROPTYPE, securedpro0_.RMLEASETRM as RMLEASETRM, securedpro0_.COUNCDPER as COUNCDPER, securedpro0_.COUNCDAMT as COUNCDAMT, securedpro0_.COUNCIL as COUNCIL, securedpro0_.TENURE as TENURE, securedpro0_.PARTLET as PARTLET, securedpro0_.COMMERCIAL as COMMERCIAL, securedpro0_.USERSTAMP as USERSTAMP, securedpro0_.DATEBUILT as DATEBUILT, securedpro0_.DATETIME as DATETIME, securedpro0_.CONSTRUCT as CONSTRUCT, securedpro0_.JOINTOWNED as JOINTOWNED, securedpro0_.BEDROOMS as BEDROOMS, securedpro0_.RECEPTIONS as RECEPTIONS, securedpro0_.BATHROOMS as BATHROOMS, securedpro0_.GARAGES as GARAGES, securedpro0_.FEATURES as FEATURES, securedpro0_.SHAREOWNSC as SHAREOWNSC, securedpro0_.NOSTOREYS as NOSTOREYS, securedpro0_.PPI as PPI, securedpro0_.FLEXIBLE as FLEXIBLE, securedpro0_.DSSASSISTEDFLAG as DSSASSI34_, securedpro0_.HIGHESTPAYMENT as HIGHEST35_, securedpro0_.TOBESOLDFLAG as TOBESOL36_, securedpro0_.SELLINGPRICE as SELLING37_, securedpro0_.ESTIMATEDVALUE as ESTIMAT38_, securedpro0_.VALUATION1 as VALUATION1, securedpro0_.KITCHENS as KITCHENS, securedpro0_.WC as WC, securedpro0_.ACRES as ACRES, securedpro0_.SERVICECHARGE as SERVICE43_, securedpro0_.GROUNDRENT as GROUNDRENT, securedpro0_.NHBCFLAG as NHBCFLAG, securedpro0_.ARCHITECTCERTFLAG as ARCHITE46_, securedpro0_.THIRTYDAYOCCUPANCY as THIRTYD47_, securedpro0_.SECONDPROPERTYFLAG as SECONDP48_, securedpro0_.PROPERTYLETFLAG as PROPERT49_, securedpro0_.CURRENTMONTHLYRENT as CURRENT50_, securedpro0_.POTENTIALMNTHRENT as POTENTI51_, securedpro0_.TOBELETFLAG as TOBELET52_, securedpro0_.TENANCYSTARTDATE as TENANCY53_, securedpro0_.TENANCYTERM as TENANCY54_, securedpro0_.IMPREQUIREDFLAG as IMPREQU55_, securedpro0_.IMPREQUIREDEST as IMPREQU56_, securedpro0_.SUBSIDENCEDETAILS as SUBSIDE57_, securedpro0_.ELECTRICITYFLAG as ELECTRI58_, securedpro0_.WATERFLAG as WATERFLAG, securedpro0_.GASFLAG as GASFLAG, securedpro0_.DRAINAGEFLAG as DRAINAG61_, securedpro0_.OTHERSERVICES as OTHERSE62_, securedpro0_.AGRIRESTRICTFLAG as AGRIRES63_, securedpro0_.EXMODFLAG as EXMODFLAG, securedpro0_.EXPOLICEFLAG as EXPOLIC65_, securedpro0_.EXLOCALAUTHFLAG as EXLOCAL66_, securedpro0_.EXHOUSINGASSFLAG as EXHOUSI67_, securedpro0_.COMMERCIALPURPOSE as COMMERC68_, securedpro0_.PURCHFROMRELFLAG as PURCHFR69_, securedpro0_.RELATIVEDETAILS as RELATIV70_, securedpro0_.VALUATIONTYPE as VALUATI71_, securedpro0_.ANTCOMPLETEDATE as ANTCOMP72_, securedpro0_.ACTCOMPLETEDATE as ACTCOMP73_, securedpro0_.ACCESS as ACCESS, securedpro0_.REBUILDCST as REBUILDCST, securedpro0_.MORTRATE as MORTRATE, securedpro0_.MORTTYPE as MORTTYPE, securedpro0_.REPVEHICLE as REPVEHICLE, securedpro0_.MATUREDATE as MATUREDATE, securedpro0_.MATUREVALUE as MATUREV80_, securedpro0_.INTTYPE as INTTYPE, securedpro0_.PARTYTOMORTGAGE as PARTYTO82_, securedpro0_.ACTIVE as ACTIVE, securedpro0_.APPID as APPID, securedpro0_.CUSTID as CUSTID, securedpro0_.ADDRID as ADDRID from SECURITY securedpro0_ where (securedpro0_.CUSTID=? )and(securedpro0_.TYPE='CURRENT' )
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.SQL - select securedpro0_.SECURITYID as SECURITYID, securedpro0_.TYPE as TYPE, securedpro0_.PURCHDATE as PURCHDATE, securedpro0_.PURCHPRICE as PURCHPRICE, securedpro0_.CURVALUE as CURVALUE, securedpro0_.MORTBAL as MORTBAL, securedpro0_.MORTLENDR as MORTLENDR, securedpro0_.MORTREPAY as MORTREPAY, securedpro0_.OTHERBAL as OTHERBAL, securedpro0_.PAYMENTFREQUENCY as PAYMENT10_, securedpro0_.MORTTERM as MORTTERM, securedpro0_.PROPTYPE as PROPTYPE, securedpro0_.RMLEASETRM as RMLEASETRM, securedpro0_.COUNCDPER as COUNCDPER, securedpro0_.COUNCDAMT as COUNCDAMT, securedpro0_.COUNCIL as COUNCIL, securedpro0_.TENURE as TENURE, securedpro0_.PARTLET as PARTLET, securedpro0_.COMMERCIAL as COMMERCIAL, securedpro0_.USERSTAMP as USERSTAMP, securedpro0_.DATEBUILT as DATEBUILT, securedpro0_.DATETIME as DATETIME, securedpro0_.CONSTRUCT as CONSTRUCT, securedpro0_.JOINTOWNED as JOINTOWNED, securedpro0_.BEDROOMS as BEDROOMS, securedpro0_.RECEPTIONS as RECEPTIONS, securedpro0_.BATHROOMS as BATHROOMS, securedpro0_.GARAGES as GARAGES, securedpro0_.FEATURES as FEATURES, securedpro0_.SHAREOWNSC as SHAREOWNSC, securedpro0_.NOSTOREYS as NOSTOREYS, securedpro0_.PPI as PPI, securedpro0_.FLEXIBLE as FLEXIBLE, securedpro0_.DSSASSISTEDFLAG as DSSASSI34_, securedpro0_.HIGHESTPAYMENT as HIGHEST35_, securedpro0_.TOBESOLDFLAG as TOBESOL36_, securedpro0_.SELLINGPRICE as SELLING37_, securedpro0_.ESTIMATEDVALUE as ESTIMAT38_, securedpro0_.VALUATION1 as VALUATION1, securedpro0_.KITCHENS as KITCHENS, securedpro0_.WC as WC, securedpro0_.ACRES as ACRES, securedpro0_.SERVICECHARGE as SERVICE43_, securedpro0_.GROUNDRENT as GROUNDRENT, securedpro0_.NHBCFLAG as NHBCFLAG, securedpro0_.ARCHITECTCERTFLAG as ARCHITE46_, securedpro0_.THIRTYDAYOCCUPANCY as THIRTYD47_, securedpro0_.SECONDPROPERTYFLAG as SECONDP48_, securedpro0_.PROPERTYLETFLAG as PROPERT49_, securedpro0_.CURRENTMONTHLYRENT as CURRENT50_, securedpro0_.POTENTIALMNTHRENT as POTENTI51_, securedpro0_.TOBELETFLAG as TOBELET52_, securedpro0_.TENANCYSTARTDATE as TENANCY53_, securedpro0_.TENANCYTERM as TENANCY54_, securedpro0_.IMPREQUIREDFLAG as IMPREQU55_, securedpro0_.IMPREQUIREDEST as IMPREQU56_, securedpro0_.SUBSIDENCEDETAILS as SUBSIDE57_, securedpro0_.ELECTRICITYFLAG as ELECTRI58_, securedpro0_.WATERFLAG as WATERFLAG, securedpro0_.GASFLAG as GASFLAG, securedpro0_.DRAINAGEFLAG as DRAINAG61_, securedpro0_.OTHERSERVICES as OTHERSE62_, securedpro0_.AGRIRESTRICTFLAG as AGRIRES63_, securedpro0_.EXMODFLAG as EXMODFLAG, securedpro0_.EXPOLICEFLAG as EXPOLIC65_, securedpro0_.EXLOCALAUTHFLAG as EXLOCAL66_, securedpro0_.EXHOUSINGASSFLAG as EXHOUSI67_, securedpro0_.COMMERCIALPURPOSE as COMMERC68_, securedpro0_.PURCHFROMRELFLAG as PURCHFR69_, securedpro0_.RELATIVEDETAILS as RELATIV70_, securedpro0_.VALUATIONTYPE as VALUATI71_, securedpro0_.ANTCOMPLETEDATE as ANTCOMP72_, securedpro0_.ACTCOMPLETEDATE as ACTCOMP73_, securedpro0_.ACCESS as ACCESS, securedpro0_.REBUILDCST as REBUILDCST, securedpro0_.MORTRATE as MORTRATE, securedpro0_.MORTTYPE as MORTTYPE, securedpro0_.REPVEHICLE as REPVEHICLE, securedpro0_.MATUREDATE as MATUREDATE, securedpro0_.MATUREVALUE as MATUREV80_, securedpro0_.INTTYPE as INTTYPE, securedpro0_.PARTYTOMORTGAGE as PARTYTO82_, securedpro0_.ACTIVE as ACTIVE, securedpro0_.APPID as APPID, securedpro0_.CUSTID as CUSTID, securedpro0_.ADDRID as ADDRID from SECURITY securedpro0_ where (securedpro0_.CUSTID=? )and(securedpro0_.TYPE='CURRENT' )
2004-10-06 09:52:24,067 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
2004-10-06 09:52:24,379 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - binding '3096' to parameter: 1
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - processing result set
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - returning '1000222' as column: SECURITYID
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - result row: 1000222
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - Initializing object from ResultSet: 1000222
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - Hydrating entity: net.targetgroup.broker.application.SecuredProperty#1000222
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'CURRENT ' as column: TYPE
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: PURCHDATE
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: PURCHPRICE
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: CURVALUE
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MORTBAL
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning ' ' as column: MORTLENDR
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MORTREPAY
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: OTHERBAL
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'MONTHLY ' as column: PAYMENT10_
2004-10-06 09:52:24,958 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MORTTERM
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'DETACHED ' as column: PROPTYPE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: RMLEASETRM
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: COUNCDPER
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: COUNCDAMT
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: COUNCIL
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'FREEHOLD ' as column: TENURE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PARTLET
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: COMMERCIAL
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'b ' as column: USERSTAMP
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.DateType - returning null as column: DATEBUILT
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: DATETIME
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: CONSTRUCT
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: JOINTOWNED
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: BEDROOMS
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: RECEPTIONS
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: BATHROOMS
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: GARAGES
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: FEATURES
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: SHAREOWNSC
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: NOSTOREYS
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PPI
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: FLEXIBLE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: DSSASSI34_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: HIGHEST35_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: TOBESOL36_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: SELLING37_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: ESTIMAT38_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: VALUATION1
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: KITCHENS
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: WC
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: ACRES
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: SERVICE43_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: GROUNDRENT
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: NHBCFLAG
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: ARCHITE46_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: THIRTYD47_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: SECONDP48_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PROPERT49_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: CURRENT50_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: POTENTI51_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: TOBELET52_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.DateType - returning null as column: TENANCY53_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: TENANCY54_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: IMPREQU55_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: IMPREQU56_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: SUBSIDE57_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: ELECTRI58_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: WATERFLAG
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: GASFLAG
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: DRAINAG61_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N ' as column: OTHERSE62_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: AGRIRES63_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: EXMODFLAG
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: EXPOLIC65_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: EXLOCAL66_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: EXHOUSI67_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: COMMERC68_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PURCHFR69_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: RELATIV70_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: VALUATI71_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.DateType - returning null as column: ANTCOMP72_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.DateType - returning null as column: ACTCOMP73_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ACCESS
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: REBUILDCST
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MORTRATE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: MORTTYPE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: REPVEHICLE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: MATUREDATE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning null as column: MATUREV80_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: INTTYPE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: PARTYTO82_
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning 'N' as column: ACTIVE
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning '906' as column: APPID
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.BigDecimalType - returning '3096' as column: CUSTID
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - returning '1000556' as column: ADDRID
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - done processing result set (1 rows)
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-10-06 09:52:24,973 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - total objects hydrated: 1
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - resolving associations for [net.targetgroup.broker.application.SecuredProperty#1000222]
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - loading [net.targetgroup.broker.address.Address#1000556]
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - attempting to resolve [net.targetgroup.broker.address.Address#1000556]
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - object not resolved in any cache [net.targetgroup.broker.address.Address#1000556]
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.persister.NormalizedEntityPersister - Materializing entity: [net.targetgroup.broker.address.Address#1000556]
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.SQL - select address0_.ADDRID as ADDRID0_, case when address0__1_.ADDRID is not null then 1 when address0_.ADDRID is not null then 0 end as clazz_0_, address0_.ADDR01 as ADDR011_0_, address0_.ADDR02 as ADDR021_0_, address0_.ADDR03 as ADDR031_0_, address0_.ADDR04 as ADDR041_0_, address0_.ADDR05 as ADDR051_0_, address0_.POSTCODE as POSTCODE1_0_, address0_.USERSTAMP as USERSTAMP1_0_, address0_.DATETIME as DATETIME1_0_, address0__1_.CUSTID as CUSTID2_0_, address0__1_.USERSTAMP as USERSTAMP2_0_, address0__1_.ADDRTYPE as ADDRTYPE2_0_, address0__1_.DATETIME as DATETIME2_0_, address0__1_.MOVEDIN as MOVEDIN2_0_, address0__1_.VOTERSROLL as VOTERSROLL2_0_, address0__1_.MOVEDOUT as MOVEDOUT2_0_, address0__1_.VOTERSIN as VOTERSIN2_0_, address0__1_.OWNERSHIPSTATUS as OWNERSH10_2_0_, address0__1_.VOTERSOUT as VOTERSOUT2_0_ from ADDRESS address0_ left outer join CORR_ADDR address0__1_ on address0_.ADDRID=address0__1_.ADDRID where address0_.ADDRID=?
2004-10-06 09:52:25,020 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
2004-10-06 09:52:25,114 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - binding '1000556' to parameter: 1
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - processing result set
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - result row: 1000556
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.IntegerType - returning '0' as column: clazz_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - Initializing object from ResultSet: 1000556
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - Hydrating entity: net.targetgroup.broker.address.Address#1000556
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR011_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR021_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR031_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR041_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: ADDR051_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: POSTCODE1_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.StringType - returning null as column: USERSTAMP1_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.type.TimestampType - returning null as column: DATETIME1_0_
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - done processing result set (1 rows)
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-10-06 09:52:25,208 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
2004-10-06 09:52:25,254 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.loader.Loader - total objects hydrated: 1
2004-10-06 09:52:25,254 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - resolving associations for [net.targetgroup.broker.address.Address#1000556]
2004-10-06 09:52:25,254 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - done materializing entity [net.targetgroup.broker.address.Address#1000556]
2004-10-06 09:52:25,254 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - done materializing entity [net.targetgroup.broker.application.SecuredProperty#1000222]
2004-10-06 09:52:25,254 [MessageListenerThreadPool : 0] DEBUG net.sf.hibernate.impl.SessionImpl - initializing non-lazy collections
2004-10-06 09:52:26,254 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationservices.ApplicationManagerBean - Matched a consolidation for the current property
2004-10-06 09:52:26,286 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationdataaccess.EntityStatementsDataAccess - About to execute SELECT STATEMENTID, DESCRIPTION, MANDATORYFLAG, STATEMENTCODE, PARENTSTATEMENT FROM STATEMENTS order by STATEMENTID
2004-10-06 09:52:26,504 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationdataaccess.EntityStatementsDataAccess - Executed SELECT STATEMENTID, DESCRIPTION, MANDATORYFLAG, STATEMENTCODE, PARENTSTATEMENT FROM STATEMENTS order by STATEMENTID
2004-10-06 09:52:26,567 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationservices.ApplicationManagerBean - Finding disclosure statements for application 906
2004-10-06 09:52:26,989 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.broker.application.applicationservices.ApplicationManagerBean - Looking for source of application 906
2004-10-06 09:52:27,708 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.util.jndi.JNDIMapping - bundle name is net.targetgroup.standingdata.utils.jndi.jndi
2004-10-06 09:52:27,708 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.util.jndi.JNDIMapping - bundle name is net.targetgroup.standingdata.utils.jndi.jndi
2004-10-06 09:52:27,708 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.util.jndi.JNDIMapping - cached bundle version is null
2004-10-06 09:52:27,708 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.util.jndi.JNDIMapping - load bundle from file net.targetgroup.standingdata.utils.jndi.jndi
2004-10-06 09:52:27,754 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.standingdata.StandingDataBean - Getting single detail
2004-10-06 09:52:27,786 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.util.jndi.JNDIMapping - bundle name is net.targetgroup.standingdata.utils.jndi.jndi
2004-10-06 09:52:27,786 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.util.jndi.JNDIMapping - bundle name is net.targetgroup.standingdata.utils.jndi.jndi
2004-10-06 09:52:27,786 [MessageListenerThreadPool : 0] DEBUG net.targetgroup.util.jndi.JNDIMapping - cached bundle version is null
2004-10-06 09:52:27,786 [MessageListenerThread

_________________
On the information super B road

Top
 Profile  
 
Paul Newport
 Post subject:
PostPosted: Wed Oct 06, 2004 4:59 am 
Senior
Senior

Joined: Tue Aug 03, 2004 2:11 pm
Posts: 142
Location: Somerset
And here's the mapping

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>


<class name="net.targetgroup.broker.application.SecuredProperty" table="SECURITY">

<id name="identifier" type="int" column="SECURITYID" unsaved-value="-1">
<generator class="native" />
</id>

<property name="type" type="java.lang.String" column="TYPE" length="10" />
<property name="purchaseDate" type="java.sql.Timestamp" column="PURCHDATE" length="19" />
<property name="purchasePrice" type="java.math.BigDecimal" column="PURCHPRICE" length="9" />
<property name="currentValue" type="java.math.BigDecimal" column="CURVALUE" length="9" />
<property name="mortgageBalance" type="java.math.BigDecimal" column="MORTBAL" length="9" />
<property name="mortgageLender" type="java.lang.String" column="MORTLENDR" length="60" />
<property name="mortgageRepayment" type="java.math.BigDecimal" column="MORTREPAY" length="9" />
<property name="otherBalance" type="java.math.BigDecimal" column="OTHERBAL" length="9" />
<property name="paymentFrequency" type="java.lang.String" column="PAYMENTFREQUENCY" length="10" />
<property name="mortgageTerm" type="java.math.BigDecimal" column="MORTTERM" length="3" />
<property name="propertyType" type="java.lang.String" column="PROPTYPE" length="40" />
<property name="remainingLeaseTerm" type="java.math.BigDecimal" column="RMLEASETRM" length="7" />
<property name="councilDiscountPercentage" type="java.math.BigDecimal" column="COUNCDPER" length="3" />
<property name="councilDiscountAmount" type="java.math.BigDecimal" column="COUNCDAMT" length="9" />
<property name="council" type="net.targetgroup.util.datatypes.CustomBooleanType" column="COUNCIL" length="1" />
<property name="tenure" type="java.lang.String" column="TENURE" length="30" />
<property name="partLet" type="net.targetgroup.util.datatypes.CustomBooleanType" column="PARTLET" length="1" />
<property name="commercial" type="net.targetgroup.util.datatypes.CustomBooleanType" column="COMMERCIAL" length="1" />
<property name="userStamp" type="java.lang.String" column="USERSTAMP" length="10" />
<property name="dateBuilt" type="java.sql.Date" column="DATEBUILT" length="10" />
<property name="timeStamp" type="java.sql.Timestamp" column="DATETIME" length="19" />
<property name="construction" type="java.lang.String" column="CONSTRUCT" length="40" />
<property name="ownership" type="java.lang.String" column="JOINTOWNED" length="1" />
<property name="bedrooms" type="java.math.BigDecimal" column="BEDROOMS" length="3" />
<property name="receptions" type="java.math.BigDecimal" column="RECEPTIONS" length="3" />
<property name="bathrooms" type="java.math.BigDecimal" column="BATHROOMS" length="3" />
<property name="garages" type="java.math.BigDecimal" column="GARAGES" length="3" />
<property name="unusualFeatures" type="java.lang.String" column="FEATURES" length="64" />
<property name="shareOwnershipScheme" type="net.targetgroup.util.datatypes.CustomBooleanType" column="SHAREOWNSC" length="1" />
<property name="numberOfStoreys" type="java.math.BigDecimal" column="NOSTOREYS" length="3" />
<property name="ppi" type="net.targetgroup.util.datatypes.CustomBooleanType" column="PPI" length="1" />
<property name="flexibleMortgage" type="net.targetgroup.util.datatypes.CustomBooleanType" column="FLEXIBLE" length="1" />
<property name="dssAssistedFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="DSSASSISTEDFLAG" length="1" />
<property name="highestPayment" type="java.math.BigDecimal" column="HIGHESTPAYMENT" length="9" />
<property name="propertyToBeSoldFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="TOBESOLDFLAG" length="1" />
<property name="sellingPrice" type="java.math.BigDecimal" column="SELLINGPRICE" length="11" />
<property name="estimatedValue" type="java.math.BigDecimal" column="ESTIMATEDVALUE" length="11" />
<property name="valuation1" type="java.math.BigDecimal" column="VALUATION1" length="11" />
<property name="kitchens" type="java.math.BigDecimal" column="KITCHENS" length="3" />
<property name="wc" type="java.math.BigDecimal" column="WC" length="3" />
<property name="acres" type="java.math.BigDecimal" column="ACRES" length="3" />
<property name="serviceCharge" type="java.math.BigDecimal" column="SERVICECHARGE" length="9" />
<property name="groundRent" type="java.math.BigDecimal" column="GROUNDRENT" length="9" />
<property name="nhbcFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="NHBCFLAG" length="1" />
<property name="architectCertFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="ARCHITECTCERTFLAG" length="1" />
<property name="thirtyDayOccupancy" type="net.targetgroup.util.datatypes.CustomBooleanType" column="THIRTYDAYOCCUPANCY" length="1" />
<property name="secondProperty" type="net.targetgroup.util.datatypes.CustomBooleanType" column="SECONDPROPERTYFLAG" length="1" />
<property name="currentlyRentFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="PROPERTYLETFLAG" length="1" />
<property name="currentRent" type="java.math.BigDecimal" column="CURRENTMONTHLYRENT" length="9" />
<property name="potentialRent" type="java.math.BigDecimal" column="POTENTIALMNTHRENT" length="9" />
<property name="propertyToBeLetFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="TOBELETFLAG" length="1" />
<property name="tenancyStartDate" type="java.sql.Date" column="TENANCYSTARTDATE" length="10" />
<property name="tenancyTerm" type="java.math.BigDecimal" column="TENANCYTERM" length="4" />
<property name="improvementsFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="IMPREQUIREDFLAG" length="1" />
<property name="estimateCosts" type="java.math.BigDecimal" column="IMPREQUIREDEST" length="9" />
<property name="subsidenceHistory" type="java.lang.String" column="SUBSIDENCEDETAILS" length="64" />
<property name="electricityFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="ELECTRICITYFLAG" length="1" />
<property name="waterFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="WATERFLAG" length="1" />
<property name="gasFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="GASFLAG" length="1" />
<property name="drainageFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="DRAINAGEFLAG" length="1" />
<property name="otherServicesFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="OTHERSERVICES" length="20" />
<property name="agriculturalRestrictionsFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="AGRIRESTRICTFLAG" length="1" />
<property name="exModFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="EXMODFLAG" length="1" />
<property name="exPoliceFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="EXPOLICEFLAG" length="1" />
<property name="exLocalAuthorityFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="EXLOCALAUTHFLAG" length="1" />
<property name="exHousingAssociationFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="EXHOUSINGASSFLAG" length="1" />
<property name="commercialPurpose" type="java.lang.String" column="COMMERCIALPURPOSE" length="64" />
<property name="purchaseForRelativeFlag" type="net.targetgroup.util.datatypes.CustomBooleanType" column="PURCHFROMRELFLAG" length="1" />
<property name="relativeDetails" type="java.lang.String" column="RELATIVEDETAILS" length="40" />
<property name="valuationType" type="java.lang.String" column="VALUATIONTYPE" length="30" />
<property name="anticipatedCompletionDate" type="java.sql.Date" column="ANTCOMPLETEDATE" length="10" />
<property name="actualCompletionDate" type="java.sql.Date" column="ACTCOMPLETEDATE" length="10" />
<property name="access" type="java.lang.String" column="ACCESS" length="60" />
<property name="rebuildCost" type="java.math.BigDecimal" column="REBUILDCST" length="11" />
<property name="mortgageRate" type="java.math.BigDecimal" column="MORTRATE" length="5" />
<property name="mortgageType" type="java.lang.String" column="MORTTYPE" length="30" />
<property name="repaymentVehicle" type="java.lang.String" column="REPVEHICLE" length="30" />
<property name="repaymentVehicleMaturityDate" type="java.sql.Timestamp" column="MATUREDATE" length="19" />
<property name="expectedMaturityValue" type="java.math.BigDecimal" column="MATUREVALUE" length="11" />
<property name="interestType" type="java.lang.String" column="INTTYPE" length="30" />
<property name="secondApplicantPartyToMortgage" type="net.targetgroup.util.datatypes.CustomBooleanType" column="PARTYTOMORTGAGE" length="1" />
<property name="active" type="net.targetgroup.util.datatypes.CustomBooleanType" column="ACTIVE" length="1" />
<property name="applicationID" type="java.math.BigDecimal" column="APPID" length="9" />
<property name="customerID" type="java.math.BigDecimal" column="CUSTID" length="9" />
<many-to-one name="address" class="net.targetgroup.broker.address.Address" not-null="true" cascade="all">
<column name="ADDRID" />
</many-to-one>

</class>
</hibernate-mapping>


and

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>


<class name="net.targetgroup.broker.address.Address" table="ADDRESS">

<id name="identifier" type="int" column="ADDRID" unsaved-value="-1">
<generator class="native" />
</id>
<property name="addressLines" type="net.targetgroup.broker.address.AddressLinesUserType">
<column name="ADDR01" />
<column name="ADDR02" />
<column name="ADDR03" />
<column name="ADDR04" />
<column name="ADDR05" />
</property>

<property name="postcode" type="java.lang.String" column="POSTCODE" length="8" />
<property name="userStamp" type="java.lang.String" column="USERSTAMP" length="10" />
<property name="timeStamp" type="java.sql.Timestamp" column="DATETIME" length="19" />

<joined-subclass name="net.targetgroup.broker.customer.CustomerAddress" table="CORR_ADDR">

<key>
<column name="ADDRID" />
</key>

<property name="customerIdentifier" type="java.math.BigDecimal" column="CUSTID" length="9" />
<property name="userStamp" type="java.lang.String" column="USERSTAMP" length="10" />
<property name="addressType" type="java.lang.String" column="ADDRTYPE" length="30" />
<property name="timeStamp" type="java.sql.Timestamp" column="DATETIME" length="26" />
<property name="movedInDate" type="java.sql.Timestamp" column="MOVEDIN" length="26" />
<property name="votersRoll" type="net.targetgroup.util.datatypes.CustomBooleanType" column="VOTERSROLL" length="1" />
<property name="movedOutDate" type="java.sql.Timestamp" column="MOVEDOUT" length="26" />
<property name="votersStartDate" type="java.sql.Date" column="VOTERSIN" length="10" />
<property name="ownStatus" type="java.lang.String" column="OWNERSHIPSTATUS" length="40" />
<property name="votersEndDate" type="java.sql.Date" column="VOTERSOUT" length="10" />


</joined-subclass>

</class>
</hibernate-mapping>

_________________
On the information super B road

Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.