Hi all,

I have set the sql dialect to be ms sql in the hibernate.cfg.xml file.


When I issue a find command I get a sql syntax error



I get the following error




The entire message follows

[code]in] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: loginName -> login_name, type: string
1150 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: hasServerAccess -> has_server_access, type: boolean
1150 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: isSysadminMember -> is_sysadmin_member, type: boolean
1150 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: cachedate -> cachedate, type: timestamp
1150 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@1e3118a [Attribute: name resource value "Syscategory.hbm.xml"]
1150 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Syscategory.hbm.xml
1151 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1152 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1161 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Syscategory -> syscategories
1161 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: categoryId -> category_id, type: integer
1161 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: categoryClass -> category_class, type: integer
1161 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: categoryType -> category_type, type: byte
1161 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1169 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@3b1d04 [Attribute: name resource value "Sysdbmaintplan.hbm.xml"]
1169 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysdbmaintplan.hbm.xml
1170 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1171 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1183 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdbmaintplan -> sysdbmaintplans
1183 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: planId -> plan_id, type: string
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: planName -> plan_name, type: string
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dateCreated -> date_created, type: timestamp
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: owner -> owner, type: string
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: maxHistoryRows -> max_history_rows, type: integer
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: remoteHistoryServer -> remote_history_server, type: string
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: maxRemoteHistoryRows -> max_remote_history_rows, type: integer
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: userDefined1 -> user_defined_1, type: integer
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: userDefined2 -> user_defined_2, type: string
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: userDefined3 -> user_defined_3, type: timestamp
1184 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: userDefined4 -> user_defined_4, type: string
1185 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: logShipping -> log_shipping, type: boolean
1186 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdbmaintplanJobs, type: java.util.Set
1187 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdbmaintplanDatabas, type: java.util.Set
1187 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@cb6009 [Attribute: name resource value "SysdbmaintplanDatabas.hbm.xml"]
1187 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: SysdbmaintplanDatabas.hbm.xml
1189 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1189 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1193 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.SysdbmaintplanDatabas -> sysdbmaintplan_databases
1194 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: databaseName -> database_name, type: string
1221 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdbmaintplan -> plan_id, type: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdbmaintplan
1221 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@be0e27 [Attribute: name resource value "SysdbmaintplanHistory.hbm.xml"]
1221 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: SysdbmaintplanHistory.hbm.xml
1222 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1223 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1229 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.SysdbmaintplanHistory -> sysdbmaintplan_history
1229 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sequenceId -> sequence_id, type: integer
1229 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: planId -> plan_id, type: string
1229 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: planName -> plan_name, type: string
1229 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: databaseName -> database_name, type: string
1229 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: serverName -> server_name, type: string
1229 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: activity -> activity, type: string
1229 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: succeeded -> succeeded, type: boolean
1230 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: endTime -> end_time, type: timestamp
1230 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: duration -> duration, type: integer
1230 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: startTime -> start_time, type: timestamp
1230 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: errorNumber -> error_number, type: integer
1230 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: message -> message, type: string
1243 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@dda25b [Attribute: name resource value "SysdbmaintplanJob.hbm.xml"]
1244 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: SysdbmaintplanJob.hbm.xml
1245 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1245 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1312 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.SysdbmaintplanJob -> sysdbmaintplan_jobs
1313 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: jobId -> job_id, type: string
1319 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdbmaintplan -> plan_id, type: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdbmaintplan
1320 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@15253d5 [Attribute: name resource value "Sysdownloadlist.hbm.xml"]
1320 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysdownloadlist.hbm.xml
1322 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1322 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1342 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdownloadlist -> sysdownloadlist
1343 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: instanceId -> instance_id, type: integer
1343 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sourceServer -> source_server, type: string
1343 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: operationCode -> operation_code, type: byte
1343 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: objectType -> object_type, type: byte
1343 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: objectId -> object_id, type: string
1344 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: targetServer -> target_server, type: string
1344 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: errorMessage -> error_message, type: string
1344 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: datePosted -> date_posted, type: timestamp
1344 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dateDownloaded -> date_downloaded, type: timestamp
1344 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: status -> status, type: byte
1344 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: deletedObjectName -> deleted_object_name, type: string
1361 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@1d256fa [Attribute: name resource value "Sysdtscategory.hbm.xml"]
1361 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysdtscategory.hbm.xml
1365 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1365 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1401 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtscategory -> sysdtscategories
1401 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: id -> id, type: string
1401 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1401 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: description -> description, type: string
1402 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: parentid -> parentid, type: string
1403 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdtspackags, type: java.util.Set
1404 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@497934 [Attribute: name resource value "Sysdtspackages.hbm.xml"]
1404 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysdtspackages.hbm.xml
1406 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1406 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1415 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtspackages -> sysdtspackages
1416 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: id -> id, type: string
1416 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: versionid -> versionid, type: string
1421 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: comp_id -> id, versionid, type: za.co.clarkeconsulting.mssql.msdb.dataobjects.SysdtspackagPK
1422 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1422 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: description -> description, type: string
1422 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: createdate -> createdate, type: timestamp
1422 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: owner -> owner, type: string
1422 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: ownerSid -> owner_sid, type: binary
1422 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: packagetype -> packagetype, type: integer
1423 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdtscategory -> categoryid, type: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtscategory
1423 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@1bb60c3 [Attribute: name resource value "Sysdtspackagelog.hbm.xml"]
1423 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysdtspackagelog.hbm.xml
1424 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1425 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1435 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtspackagelog -> sysdtspackagelog
1435 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lineagefull -> lineagefull, type: string
1435 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1435 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: description -> description, type: string
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: id -> id, type: string
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: versionid -> versionid, type: string
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lineageshort -> lineageshort, type: integer
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: starttime -> starttime, type: timestamp
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: endtime -> endtime, type: timestamp
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: elapsedtime -> elapsedtime, type: double
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: computer -> computer, type: string
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: operator -> operator, type: string
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: logdate -> logdate, type: timestamp
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: errorcode -> errorcode, type: integer
1436 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: errordescription -> errordescription, type: string
1438 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdtssteplogs, type: java.util.Set
1438 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@16bd8ea [Attribute: name resource value "Sysdtssteplog.hbm.xml"]
1438 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysdtssteplog.hbm.xml
1440 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1441 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1451 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtssteplog -> sysdtssteplog
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: stepexecutionid -> stepexecutionid, type: long
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: stepname -> stepname, type: string
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: stepexecstatus -> stepexecstatus, type: integer
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: stepexecresult -> stepexecresult, type: integer
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: starttime -> starttime, type: timestamp
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: endtime -> endtime, type: timestamp
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: elapsedtime -> elapsedtime, type: double
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: errorcode -> errorcode, type: integer
1452 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: errordescription -> errordescription, type: string
1453 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: progresscount -> progresscount, type: long
1453 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdtspackagelog -> lineagefull, type: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtspackagelog
1456 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdtstasklogs, type: java.util.Set
1456 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@b6e39f [Attribute: name resource value "Sysdtstasklog.hbm.xml"]
1456 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysdtstasklog.hbm.xml
1459 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1459 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1464 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtstasklog -> sysdtstasklog
1464 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sequenceid -> sequenceid, type: integer
1464 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sysdtssteplog -> stepexecutionid, type: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtssteplog
1471 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: comp_id -> sequenceid, stepexecutionid, type: za.co.clarkeconsulting.mssql.msdb.dataobjects.SysdtstasklogPK
1472 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: errorcode -> errorcode, type: integer
1472 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: description -> description, type: string
1472 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@9945ce [Attribute: name resource value "Sysjob.hbm.xml"]
1472 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysjob.hbm.xml
1473 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1476 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1487 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysjob -> sysjobs
1487 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: jobId -> job_id, type: string
1487 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: originatingServer -> originating_server, type: string
1487 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1488 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: enabled -> enabled, type: byte
1488 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: description -> description, type: string
1488 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: startStepId -> start_step_id, type: integer
1488 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: categoryId -> category_id, type: integer
1488 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: ownerSid -> owner_sid, type: binary
1488 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: notifyLevelEventlog -> notify_level_eventlog, type: integer
1488 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: notifyLevelEmail -> notify_level_email, type: integer
1490 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: notifyLevelNetsend -> notify_level_netsend, type: integer
1490 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: notifyLevelPage -> notify_level_page, type: integer
1490 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: notifyEmailOperatorId -> notify_email_operator_id, type: integer
1490 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: notifyNetsendOperatorId -> notify_netsend_operator_id, type: integer
1490 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: notifyPageOperatorId -> notify_page_operator_id, type: integer
1490 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: deleteLevel -> delete_level, type: integer
1490 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dateCreated -> date_created, type: timestamp
1490 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dateModified -> date_modified, type: timestamp
1491 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: versionNumber -> version_number, type: integer
1528 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@f39b3a [Attribute: name resource value "Sysjobhistory.hbm.xml"]
1528 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysjobhistory.hbm.xml
1530 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1530 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1537 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysjobhistory -> sysjobhistory
1537 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: instanceId -> instance_id, type: integer
1537 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: jobId -> job_id, type: string
1537 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: stepId -> step_id, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: stepName -> step_name, type: string
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sqlMessageId -> sql_message_id, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sqlSeverity -> sql_severity, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: message -> message, type: string
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: runStatus -> run_status, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: runDate -> run_date, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: runTime -> run_time, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: runDuration -> run_duration, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: operatorIdEmailed -> operator_id_emailed, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: operatorIdNetsent -> operator_id_netsent, type: integer
1538 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: operatorIdPaged -> operator_id_paged, type: integer
1539 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: retriesAttempted -> retries_attempted, type: integer
1539 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: server -> server, type: string
1552 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@12940b3 [Attribute: name resource value "Sysjobschedul.hbm.xml"]
1552 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysjobschedul.hbm.xml
1555 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1555 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1561 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysjobschedul -> sysjobschedules
1561 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: scheduleId -> schedule_id, type: integer
1561 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: jobId -> job_id, type: string
1561 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1561 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: enabled -> enabled, type: integer
1561 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: freqType -> freq_type, type: integer
1561 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: freqInterval -> freq_interval, type: integer
1561 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: freqSubdayType -> freq_subday_type, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: freqSubdayInterval -> freq_subday_interval, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: freqRelativeInterval -> freq_relative_interval, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: freqRecurrenceFactor -> freq_recurrence_factor, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: activeStartDate -> active_start_date, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: activeEndDate -> active_end_date, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: activeStartTime -> active_start_time, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: activeEndTime -> active_end_time, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: nextRunDate -> next_run_date, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: nextRunTime -> next_run_time, type: integer
1562 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dateCreated -> date_created, type: timestamp
1589 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@1e78fc6 [Attribute: name resource value "Sysjobserver.hbm.xml"]
1589 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysjobserver.hbm.xml
1591 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1592 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1599 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysjobserver -> sysjobservers
1600 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: jobId -> job_id, type: string
1600 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: serverId -> server_id, type: integer
1600 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunOutcome -> last_run_outcome, type: byte
1600 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastOutcomeMessage -> last_outcome_message, type: string
1600 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunDate -> last_run_date, type: integer
1600 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunTime -> last_run_time, type: integer
1600 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunDuration -> last_run_duration, type: integer
1607 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@79a2e7 [Attribute: name resource value "Sysjobstep.hbm.xml"]
1607 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysjobstep.hbm.xml
1610 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1610 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1616 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysjobstep -> sysjobsteps
1616 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: jobId -> job_id, type: string
1616 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: stepId -> step_id, type: integer
1616 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: stepName -> step_name, type: string
1617 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: subsystem -> subsystem, type: string
1617 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: command -> command, type: string
1617 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: flags -> flags, type: integer
1617 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: additionalParameters -> additional_parameters, type: string
1617 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: cmdexecSuccessCode -> cmdexec_success_code, type: integer
1617 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: onSuccessAction -> on_success_action, type: byte
1617 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: onSuccessStepId -> on_success_step_id, type: integer
1617 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: onFailAction -> on_fail_action, type: byte
1618 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: onFailStepId -> on_fail_step_id, type: integer
1618 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: server -> server, type: string
1618 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: databaseName -> database_name, type: string
1618 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: databaseUserName -> database_user_name, type: string
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: retryAttempts -> retry_attempts, type: integer
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: retryInterval -> retry_interval, type: integer
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: osRunPriority -> os_run_priority, type: integer
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: outputFileName -> output_file_name, type: string
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunOutcome -> last_run_outcome, type: integer
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunDuration -> last_run_duration, type: integer
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunRetries -> last_run_retries, type: integer
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunDate -> last_run_date, type: integer
1619 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastRunTime -> last_run_time, type: integer
1655 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@120bf2c [Attribute: name resource value "Sysnotification.hbm.xml"]
1656 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysnotification.hbm.xml
1657 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1657 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1665 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysnotification -> sysnotifications
1666 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: alertId -> alert_id, type: integer
1667 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: operatorId -> operator_id, type: integer
1667 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: notificationMethod -> notification_method, type: byte
1673 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@18f1d7e [Attribute: name resource value "Sysoperator.hbm.xml"]
1673 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Sysoperator.hbm.xml
1679 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1680 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1755 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysoperator -> sysoperators
1755 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: id -> id, type: integer
1755 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1755 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: enabled -> enabled, type: byte
1755 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: emailAddress -> email_address, type: string
1755 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastEmailDate -> last_email_date, type: integer
1755 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastEmailTime -> last_email_time, type: integer
1755 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: pagerAddress -> pager_address, type: string
1755 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastPagerDate -> last_pager_date, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastPagerTime -> last_pager_time, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: weekdayPagerStartTime -> weekday_pager_start_time, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: weekdayPagerEndTime -> weekday_pager_end_time, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: saturdayPagerStartTime -> saturday_pager_start_time, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: saturdayPagerEndTime -> saturday_pager_end_time, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sundayPagerStartTime -> sunday_pager_start_time, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sundayPagerEndTime -> sunday_pager_end_time, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: pagerDays -> pager_days, type: byte
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: netsendAddress -> netsend_address, type: string
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastNetsendDate -> last_netsend_date, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastNetsendTime -> last_netsend_time, type: integer
1756 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: categoryId -> category_id, type: integer
1775 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@811c88 [Attribute: name resource value "Systargetserver.hbm.xml"]
1775 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Systargetserver.hbm.xml
1776 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1777 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1787 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Systargetserver -> systargetservers
1787 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: serverId -> server_id, type: integer
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: serverName -> server_name, type: string
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: location -> location, type: string
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: timeZoneAdjustment -> time_zone_adjustment, type: integer
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: enlistDate -> enlist_date, type: timestamp
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastPollDate -> last_poll_date, type: timestamp
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: status -> status, type: integer
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: localTimeAtLastPoll -> local_time_at_last_poll, type: timestamp
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: enlistedByNtUser -> enlisted_by_nt_user, type: string
1788 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: pollInterval -> poll_interval, type: integer
1826 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@1dd3812 [Attribute: name resource value "Systargetservergroup.hbm.xml"]
1826 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Systargetservergroup.hbm.xml
1827 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1828 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1834 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Systargetservergroup -> systargetservergroups
1834 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: servergroupId -> servergroup_id, type: integer
1834 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1840 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@1aa9f99 [Attribute: name resource value "Systargetservergroupmember.hbm.xml"]
1840 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Systargetservergroupmember.hbm.xml
1841 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1842 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1849 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Systargetservergroupmember -> systargetservergroupmembers
1850 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: servergroupId -> servergroup_id, type: integer
1850 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: serverId -> server_id, type: integer
1855 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@60e128 [Attribute: name resource value "Systaskid.hbm.xml"]
1855 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Systaskid.hbm.xml
1856 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1856 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1862 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Systaskid -> systaskids
1863 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: taskId -> task_id, type: integer
1863 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: jobId -> job_id, type: string
1866 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@76fba0 [Attribute: name resource value "Backupset.hbm.xml"]
1867 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: Backupset.hbm.xml
1868 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
1868 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
1880 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupset -> backupset
1880 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: backupSetId -> backup_set_id, type: integer
1880 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: backupSetUuid -> backup_set_uuid, type: string
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: firstFamilyNumber -> first_family_number, type: byte
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: firstMediaNumber -> first_media_number, type: short
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastFamilyNumber -> last_family_number, type: byte
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastMediaNumber -> last_media_number, type: short
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: catalogFamilyNumber -> catalog_family_number, type: byte
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: catalogMediaNumber -> catalog_media_number, type: short
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: position -> position, type: integer
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: expirationDate -> expiration_date, type: timestamp
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: softwareVendorId -> software_vendor_id, type: integer
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: name -> name, type: string
1881 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: description -> description, type: string
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: userName -> user_name, type: string
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: softwareMajorVersion -> software_major_version, type: byte
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: softwareMinorVersion -> software_minor_version, type: byte
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: softwareBuildVersion -> software_build_version, type: short
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: timeZone -> time_zone, type: short
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: mtfMinorVersion -> mtf_minor_version, type: byte
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: firstLsn -> first_lsn, type: big_decimal
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: lastLsn -> last_lsn, type: big_decimal
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: checkpointLsn -> checkpoint_lsn, type: big_decimal
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: databaseBackupLsn -> database_backup_lsn, type: big_decimal
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: databaseCreationDate -> database_creation_date, type: timestamp
1882 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: backupStartDate -> backup_start_date, type: timestamp
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: backupFinishDate -> backup_finish_date, type: timestamp
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: type -> type, type: string
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: sortOrder -> sort_order, type: short
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: codePage -> code_page, type: short
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: compatibilityLevel -> compatibility_level, type: byte
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: databaseVersion -> database_version, type: integer
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: backupSize -> backup_size, type: big_decimal
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: databaseName -> database_name, type: string
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: serverName -> server_name, type: string
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: machineName -> machine_name, type: string
1883 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: flags -> flags, type: integer
1884 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: unicodeLocale -> unicode_locale, type: integer
1884 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: unicodeCompareStyle -> unicode_compare_style, type: integer
1884 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: collationName -> collation_name, type: string
1884 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: backupmediaset -> media_set_id, type: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupmediaset
1885 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: restorehistories, type: java.util.Set
1885 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: backupfiles, type: java.util.Set
1885 [main] INFO net.sf.hibernate.cfg.Configuration - Configured SessionFactory: null
1885 [main] DEBUG net.sf.hibernate.cfg.Configuration - properties: {hibernate.connection.password=beesem20v, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=/opt/sun-jdk-1.4.2.05/jre/lib/i386, java.vm.version=1.4.2_05-b04, hibernate.connection.username=sa, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=:, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=unknown, java.vm.specification.name=Java Virtual Machine Specification, user.dir=/home/mark/workspace/ApplicationMonitor, java.runtime.version=1.4.2_05-b04, java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment, java.endorsed.dirs=/opt/sun-jdk-1.4.2.05/jre/lib/endorsed, os.arch=i386, java.io.tmpdir=/tmp, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., os.name=Linux, sun.java2d.fontpath=, jta.UserTransaction=java:comp/UserTransaction, java.library.path=/opt/sun-jdk-1.4.2.05/jre/lib/i386/client:/opt/sun-jdk-1.4.2.05/jre/lib/i386:/opt/sun-jdk-1.4.2.05/jre/../lib/i386:/usr/lib/mozilla, java.specification.name=Java Platform API Specification, java.class.version=48.0, hibernate.transaction.factory_class=net.sf.hibernate.transaction.JTATransactionFactory, java.util.prefs.PreferencesFactory=java.util.prefs.FileSystemPreferencesFactory, os.version=2.6.7-gentoo-r9, user.home=/home/mark, user.timezone=, java.awt.printerjob=sun.print.PSPrinterJob, file.encoding=ANSI_X3.4-1968, java.specification.version=1.4, hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver, user.name=mark, java.class.path=/usr/lib/eclipse-3/plugins/org.eclipse.jdt.junit_3.0.0/junitsupport.jar:/usr/lib/eclipse-3/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar:/home/mark/workspace/ApplicationMonitor/bin:/usr/lib/eclipse-3/plugins/org.junit_3.8.1/junit.jar:/home/mark/workspace/ApplicationMonitor/lib/c3p0-0.8.4.5.jar:/home/mark/workspace/ApplicationMonitor/lib/cglib-full-2.0.1.jar:/home/mark/workspace/ApplicationMonitor/lib/commons-beanutils.jar:/home/mark/workspace/ApplicationMonitor/lib/commons-collections.jar:/home/mark/workspace/ApplicationMonitor/lib/commons-lang-2.0.jar:/home/mark/workspace/ApplicationMonitor/lib/commons-logging.jar:/home/mark/workspace/ApplicationMonitor/lib/commons-logging-api.jar:/home/mark/workspace/ApplicationMonitor/lib/concurrent-1.3.2.jar:/home/mark/workspace/ApplicationMonitor/lib/connector.jar:/home/mark/workspace/ApplicationMonitor/lib/dom4j.jar:/home/mark/workspace/ApplicationMonitor/lib/ehcache-0.7.jar:/home/mark/workspace/ApplicationMonitor/lib/hibernate2.jar:/home/mark/workspace/ApplicationMonitor/lib/jcs-1.0-dev.jar:/home/mark/workspace/ApplicationMonitor/lib/jta.jar:/home/mark/workspace/ApplicationMonitor/lib/log4j-1.2.8.jar:/home/mark/workspace/ApplicationMonitor/lib/msbase.jar:/home/mark/workspace/ApplicationMonitor/lib/mssqlserver.jar:/home/mark/workspace/ApplicationMonitor/lib/msutil.jar:/home/mark/workspace/ApplicationMonitor/lib/odmg-3.0.jar:/home/mark/workspace/ApplicationMonitor/lib/oscache-2.0.jar:/home/mark/workspace/ApplicationMonitor/lib/proxool-0.8.3.jar:/home/mark/workspace/ApplicationMonitor/lib/swarmcache-1.0rc2.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=/opt/sun-jdk-1.4.2.05/jre, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.SQLServerDialect, hibernate.connection.url=jdbc:microsoft:sqlserver://misprod:1433, user.language=en, java.specification.vendor=Sun Microsystems Inc., hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.2_05, java.ext.dirs=/opt/sun-jdk-1.4.2.05/jre/lib/ext, sun.boot.class.path=/opt/sun-jdk-1.4.2.05/jre/lib/rt.jar:/opt/sun-jdk-1.4.2.05/jre/lib/i18n.jar:/opt/sun-jdk-1.4.2.05/jre/lib/sunrsasign.jar:/opt/sun-jdk-1.4.2.05/jre/lib/jsse.jar:/opt/sun-jdk-1.4.2.05/jre/lib/jce.jar:/opt/sun-jdk-1.4.2.05/jre/lib/charsets.jar:/opt/sun-jdk-1.4.2.05/jre/classes, java.vendor=Sun Microsystems Inc., hibernate.jta.UserTransaction=java:comp/UserTransaction, file.separator=/, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, hibernate.use_outer_join=true, dialect=net.sf.hibernate.dialect.SQLServerDialect, sun.cpu.isalist=}
1885 [main] INFO net.sf.hibernate.cfg.Configuration - processing one-to-many association mappings
1886 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupmediaset.backupsets
1886 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupmediaset.backupsets -> backupset
1886 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: media_set_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupset
1886 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupmediaset.backupmediafamilies
1886 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupmediaset.backupmediafamilies -> backupmediafamily
1886 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: media_set_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupmediafamily
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.LogShippingPrimary.logShippingSecondaries
1887 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.LogShippingPrimary.logShippingSecondaries -> log_shipping_secondaries
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: primary_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.LogShippingSecondary
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorehistory.restorefiles
1887 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorehistory.restorefiles -> restorefile
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: restore_history_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorefile
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorehistory.restorefilegroups
1887 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorehistory.restorefilegroups -> restorefilegroup
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: restore_history_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorefilegroup
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdbmaintplan.sysdbmaintplanJobs
1887 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdbmaintplan.sysdbmaintplanJobs -> sysdbmaintplan_jobs
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: plan_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.SysdbmaintplanJob
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdbmaintplan.sysdbmaintplanDatabas
1887 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdbmaintplan.sysdbmaintplanDatabas -> sysdbmaintplan_databases
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: plan_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.SysdbmaintplanDatabas
1887 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtscategory.sysdtspackags
1887 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtscategory.sysdtspackags -> sysdtspackages
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: categoryid, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtspackages
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtspackagelog.sysdtssteplogs
1888 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtspackagelog.sysdtssteplogs -> sysdtssteplog
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: lineagefull, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtssteplog
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtssteplog.sysdtstasklogs
1888 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtssteplog.sysdtstasklogs -> sysdtstasklog
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: stepexecutionid, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Sysdtstasklog
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupset.restorehistories
1888 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupset.restorehistories -> restorehistory
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: backup_set_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorehistory
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Second pass for collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupset.backupfiles
1888 [main] INFO net.sf.hibernate.cfg.Binder - Mapping collection: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupset.backupfiles -> backupfile
1888 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped collection key: backup_set_id, one-to-many: za.co.clarkeconsulting.mssql.msdb.dataobjects.Backupfile
1888 [main] INFO net.sf.hibernate.cfg.Configuration - processing one-to-one association property references
1888 [main] INFO net.sf.hibernate.cfg.Configuration - processing foreign key constraints
1889 [main] DEBUG net.sf.hibernate.cfg.Configuration - resolving reference to class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorehistory
1889 [main] DEBUG net.sf.hibernate.cfg.Configuration - resolving reference to class: za.co.clarkeconsulting.mssql.msdb.dataobjects.Restorehistory
1889 [main] DEBUG net.sf.hibernate.cfg.Configuration - resolving reference to clas

Hum, this should works fine, I guess. Well, try rewrite the query to:

or:

valeuz...