I am trying to use a select generator. My problem is another application is inserting data into Oracle and relying on a trigger/sequence to set the id. If I use a generator sequence, when I insert, I get the id + 1. I read about the select generator and seem to have missed something in its usage. What I want is to use the value the trigger would create. The example in the Hibernate reference manual (see below) has a key parameter to another field. I want the id that Oracle creates using the trigger. Is this possible? When I tried it, Hibernate doesn't like my using the id column. Thanks in advance.

Primary keys assigned by triggers
For legacy schemas only (Hibernate does not generate DDL with triggers).
<id name="id" type="long" column="person_id">
<generator class="select">
<param name="key">socialSecurityNumber</param>
</generator>
</id>
In the above example, there is a unique valued property named socialSecurityNumber defined by the class, as
a natural key, and a surrogate key named person_id whose value is generated by a trigger.

Trigger
BEGIN
SELECT SODS.S_301_1_ORDERS.nextval
INTO :new.ORDERID
FROM dual;
END;

Hibernate version:
3.1Beta

Mapping documents:
<class name="Order" table="ORDERS" schema="SODS">

<id name="id" column="ORDERID">
<generator class="select" >
<param name="key">id</param>
</generator>
</id>

<property name="customerId" type="long">
<column name="CUSTOMERID" precision="11" scale="0" />
</property>
...

Code between sessionFactory.openSession() and session.close():
public void saveOrder(Order order)
{
getHibernateTemplate().saveOrUpdate(order);

if (log.isDebugEnabled())
{
log.debug("id set to: " + order.getId());
}
}

Full stack trace of any exception that occurs:
org.springframework.orm.hibernate3.HibernateSystemException: Unable to resolve property: id; nested exception is org.hibernate.HibernateException: Unable to resolve property: id
org.hibernate.HibernateException: Unable to resolve property: id
at org.hibernate.tuple.EntityMetamodel.getPropertyIndex(EntityMetamodel.java:338)
at org.hibernate.tuple.AbstractEntityTuplizer.getPropertyValue(AbstractEntityTuplizer.java:279)
at org.hibernate.persister.entity.BasicEntityPersister.getPropertyValue(BasicEntityPersister.java:3036)
at org.hibernate.id.SelectGenerator.bindParameters(SelectGenerator.java:45)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:41)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1844)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2253)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:266)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:164)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:71)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:473)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:468)
at org.springframework.orm.hibernate3.HibernateTemplate$18.doInHibernate(HibernateTemplate.java:630)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:315)
at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:627)
at org.wadsworth.sods.dao.hibernate.OrderDAOHibernate.saveOrder(OrderDAOHibernate.java:40)
at org.wadsworth.sods.dao.TestOrderDAO.testSaveOrder(TestOrderDAO.java:30)
...(Click for full stack trace)...

Name and version of the database you are using:
Oracle 9i

The generated SQL (show_sql=true):
SQL appears in debug log below

Debug level Hibernate log excerpt:
C:\Java\j2sdk1.4.2_08\bin\javaw -classpath "C:\Java\web\sods\classes;C:\bea\weblogic81\server\lib\weblogic_sp.jar;C:\bea\weblogic81\server\lib\weblogic.jar;C:\bea\weblogic81\server\lib\webservices.jar;C:\softdev\lib\spring123\asm-attrs.jar;C:\softdev\lib\spring123\asm.jar;C:\softdev\lib\spring123\cglib-2.1.jar;C:\softdev\lib\spring123\commons-collections-2.1.1.jar;C:\softdev\lib\spring123\commons-logging-1.0.4.jar;C:\softdev\lib\spring123\dom4j-1.6.jar;C:\softdev\lib\spring123\ehcache-1.1.jar;C:\softdev\lib\spring123\spring.jar;C:\softdev\lib\spring123\spring-mock.jar;C:\softdev\lib\spring123\xml-apis.jar;C:\softdev\lib\hibernate31beta\antlr-2.7.5H3.jar;C:\softdev\lib\hibernate31beta\asm.jar;C:\softdev\lib\hibernate31beta\asm-attrs.jar;C:\softdev\lib\hibernate31beta\cglib-2.1.2.jar;C:\softdev\lib\hibernate31beta\commons-collections-2.1.1.jar;C:\softdev\lib\hibernate31beta\commons-logging-1.0.4.jar;C:\softdev\lib\hibernate31beta\dom4j-1.6.jar;C:\softdev\lib\hibernate31beta\hibernate3.jar;C:\softdev\lib\hibernate31beta\jdbc2_0-stdext.jar;C:\softdev\lib\hibernate31beta\jta.jar;C:\softdev\lib\hibernate31beta\log4j-1.2.9.jar;C:\softdev\lib\hibernate31beta\xml-apis.jar;C:\Java\web\sods\sodswebapp;C:\Java\web\sods\sodswebapp\WEB-INF;C:\Java\JBuilder2005\thirdparty\junit3.8\junit.jar;C:\Java\JBuilder2005\lib\unittest.jar;C:\Java\JBuilder2005\thirdparty\jakarta-taglibs-standard-1.0.6\lib\jstl.jar;C:\Java\JBuilder2005\thirdparty\jakarta-taglibs-standard-1.0.6\lib\standard.jar;C:\Java\JBuilder2005\thirdparty\jakarta-taglibs-standard-1.0.6\lib\saxpath.jar;C:\Java\JBuilder2005\thirdparty\jakarta-taglibs-standard-1.0.6\lib\jaxen-full.jar;C:\softdev\lib\HPN3rdParty\jstl.jar;C:\softdev\lib\HPN3rdParty\standard.jar;C:\softdev\lib\HPN3rdParty\taglibs-input.jar;C:\softdev\lib\HPN3rdParty\commons-beanutils-core.jar;C:\softdev\lib\server\wchpnutil.jar;C:\clims\lib\valueobjects.jar;C:\clims\lib\softdevutil.jar;C:\Java\j2sdk1.4.2_08\demo\jfc\Java2D\Java2Demo.jar;C:\Java\j2sdk1.4.2_08\demo\plugin\jfc\Java2D\Java2Demo.jar;C:\Java\j2sdk1.4.2_08\jre\javaws\javaws.jar;C:\Java\j2sdk1.4.2_08\jre\lib\charsets.jar;C:\Java\j2sdk1.4.2_08\jre\lib\ext\dnsns.jar;C:\Java\j2sdk1.4.2_08\jre\lib\ext\ldapsec.jar;C:\Java\j2sdk1.4.2_08\jre\lib\ext\localedata.jar;C:\Java\j2sdk1.4.2_08\jre\lib\ext\sunjce_provider.jar;C:\Java\j2sdk1.4.2_08\jre\lib\im\indicim.jar;C:\Java\j2sdk1.4.2_08\jre\lib\im\thaiim.jar;C:\Java\j2sdk1.4.2_08\jre\lib\jce.jar;C:\Java\j2sdk1.4.2_08\jre\lib\jsse.jar;C:\Java\j2sdk1.4.2_08\jre\lib\plugin.jar;C:\Java\j2sdk1.4.2_08\jre\lib\rt.jar;C:\Java\j2sdk1.4.2_08\jre\lib\sunrsasign.jar;C:\Java\j2sdk1.4.2_08\lib\dt.jar;C:\Java\j2sdk1.4.2_08\lib\htmlconverter.jar;C:\Java\j2sdk1.4.2_08\lib\tools.jar" com.borland.jbuilder.unittest.JBTestRunner -socket TimGX270:2038 org.wadsworth.sods.dao.TestOrderDAO
INFO - Environment.<clinit>(464) | Hibernate 3.1 beta 1
INFO - Environment.<clinit>(477) | hibernate.properties not found
INFO - Environment.<clinit>(510) | using CGLIB reflection optimizer
INFO - Environment.<clinit>(540) | using JDK 1.4 java.sql.Timestamp handling
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.Customer -> CUSTOMERS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> CUSTOMERID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: companyName -> COMPANYNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: contactFirstName -> CONTACTFIRSTNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: contactLastName -> CONTACTLASTNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: billingAddress -> BILLINGADDRESS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: city -> CITY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: stateOrProvince -> STATEORPROVINCE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: postalCode -> POSTALCODE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: country -> COUNTRY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: contactTitle -> CONTACTTITLE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: phoneNumber -> PHONENUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: faxNumber -> FAXNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: facilityId -> FACILITY_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: roomFloorAddress2 -> ROOMFLOORADDRESS2
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: departmentAddress3 -> DEPARTMENTADDRESS3
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: upsAccountNumber -> UPSACCOUNTNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: taxId -> TAXID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: taxIdType -> TAXIDTYPE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: locationId -> LOCATIONID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: consigneeBilled -> CONSIGNEEBILLED
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: residentialIndicator -> RESIDENTIALINDICATOR
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: emailAddress -> EMAILADDRESS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: kitFacilityId -> KIT_FACILITY_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: context -> CONTEXT
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: upsCustId -> UPS_CUST_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: created -> CREATED
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: createdDate -> CREATED_DATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: dataCleaned -> DATA_CLEANED
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: phoneExt -> PHONE_EXT
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.CustomerContact -> CUSTOMER_CONTACT
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> CUSTOMERCONTACTID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: customerId -> CUSTOMER_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: contactId -> CONTACT_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: lastName -> LAST_NAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: firstName -> FIRST_NAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: mi -> MI
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: phone -> PHONE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: status -> STATUS
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.Employee -> EMPLOYEES
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> EMPLOYEEID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: firstName -> FIRSTNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: lastName -> LASTNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: title -> TITLE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: extension -> EXTENSION
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: workPhone -> WORKPHONE
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.Month -> MONTHS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> MONTH_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: monthDesc -> MONTH_DESC
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.MyCompanyInformation -> MY_COMPANY_INFORMATION
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> SETUPID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: salesTaxRate -> SALESTAXRATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: companyName -> COMPANYNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: address -> ADDRESS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: city -> CITY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: stateOrProvince -> STATEORPROVINCE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: postalCode -> POSTALCODE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: country -> COUNTRY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: phoneNumber -> PHONENUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: faxNumber -> FAXNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: defaultPaymentTerms -> DEFAULTPAYMENTTERMS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: defaultInvoiceDescription -> DEFAULTINVOICEDESCRIPTION
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.Order -> ORDERS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> ORDERID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: customerId -> CUSTOMERID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: employeeId -> EMPLOYEEID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: orderDate -> ORDERDATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: purchaseOrderNumber -> PURCHASEORDERNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipName -> SHIPNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipAddress -> SHIPADDRESS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipCity -> SHIPCITY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipStateOrProvince -> SHIPSTATEORPROVINCE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipPostalCode -> SHIPPOSTALCODE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipCountry -> SHIPCOUNTRY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipPhoneNumber -> SHIPPHONENUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipDate -> SHIPDATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shippingMethodId -> SHIPPINGMETHODID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: freightCharge -> FREIGHTCHARGE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: salesTaxRate -> SALESTAXRATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: piCode -> PI_CODE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: status -> STATUS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: lastName -> LASTNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: firstName -> FIRSTNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: mi -> MI
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: upsTrackingNumber -> UPSTRACKINGNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shippingInstruction -> SHIPPINGINSTRUCTION
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: referenceNum -> REFERENCE_NUM
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.OrderDetail -> ORDER_DETAILS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> ORDERDETAILID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: orderId -> ORDERID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: productId -> PRODUCTID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: quantity -> QUANTITY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: unitPrice -> UNITPRICE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: discount -> DISCOUNT
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: chargeBackCode -> CHARGE_BACK_CODE
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.OrderStatus -> ORDER_STATUS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> ORDER_STATUS_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: orderStatusName -> ORDER_STATUS_NAME
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.Payment -> PAYMENTS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> PAYMENTID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: orderId -> ORDERID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: paymentAmount -> PAYMENTAMOUNT
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: paymentDate -> PAYMENTDATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: creditCardNumber -> CREDITCARDNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: cardHoldersName -> CARDHOLDERSNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: creditCardExpDate -> CREDITCARDEXPDATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: paymentMethodId -> PAYMENTMETHODID
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.PaymentMethod -> PAYMENT_METHODS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> PAYMENTMETHODID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: paymentMethod -> PAYMENTMETHOD
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: creditCard -> CREDITCARD
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.Product -> PRODUCTS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> PRODUCTID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: productName -> PRODUCTNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: dohNumber -> DOH_NUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: unitPrice -> UNITPRICE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: status -> STATUS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: chargeBackCode -> CHARGE_BACK_CODE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: labelColor -> LABELCOLOR
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: configuration -> CONFIGURATION
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: piCode -> PI_CODE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: comment -> COMMENT_
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.ShipOrder -> SHIPORDERS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: orderId -> ORDERID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: customerId -> CUSTOMERID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: employeeId -> EMPLOYEEID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: orderDate -> ORDERDATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: purchaseOrderNumber -> PURCHASEORDERNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: requiredByDate -> REQUIREDBYDATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: promisedByDate -> PROMISEDBYDATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipName -> SHIPNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipAddress -> SHIPADDRESS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipCity -> SHIPCITY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipState -> SHIPSTATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipStateOrProvince -> SHIPSTATEORPROVINCE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipPostalCode -> SHIPPOSTALCODE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipCountry -> SHIPCOUNTRY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipPhoneNumber -> SHIPPHONENUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shipDate -> SHIPDATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shippingMethodId -> SHIPPINGMETHODID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: freightCharge -> FREIGHTCHARGE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: salesTaxRate -> SALESTAXRATE
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.ShippingMethod -> SHIPPING_METHODS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> SHIPPINGMETHODID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: shippingMethod -> SHIPPINGMETHOD
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.State -> STATE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: abbrev -> STATE_ABBREV
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: name -> STATE_NAME
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.Status -> STATUS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> STATUS_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: name -> STATUS_NAME
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.SwitchboardItem -> SWITCHBOARD_ITEMS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> SWITCHBOARDID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: itemNumber -> ITEMNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: itemText -> ITEMTEXT
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: command -> COMMAND
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: argument -> ARGUMENT
DEBUG - DTDEntityResolver.resolveEntity(42) | trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG - DTDEntityResolver.resolveEntity(53) | found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO - HbmBinder.bindRootPersistentClassCommonValues(267) | Mapping class: org.wadsworth.sods.model.UpsFacility -> UPS_FACILITY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: id -> ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: facilityId -> FACILITY_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: customerId -> CUSTOMERID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: companyOrName -> COMPANYORNAME
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: attention -> ATTENTION
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: street -> STREET
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: roomFloorAddress2 -> ROOMFLOORADDRESS2
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: departmentAddress3 -> DEPARTMENTADDRESS3
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: city -> CITY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: stateProv -> STATEPROV
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: postalZipCode -> POSTALZIPCODE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: country -> COUNTRY
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: telephone -> TELEPHONE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: faxNumber -> FAXNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: upsAccountNumber -> UPSACCOUNTNUMBER
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: taxId -> TAXID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: taxIdType -> TAXIDTYPE
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: locationId -> LOCATIONID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: consigneeBilled -> CONSIGNEEBILLED
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: residentialIndicator -> RESIDENTIALINDICATOR
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: emailAddress -> EMAILADDRESS
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: kitFacilityId -> KIT_FACILITY_ID
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: context -> CONTEXT
DEBUG - HbmBinder.bindProperty(1117) | Mapped property: addressMatched -> ADDRESS_MATCHED
DEBUG - Configuration.buildSessionFactory(1025) | Preparing to build session factory with filters : {}
INFO - Configuration.secondPassCompile(902) | processing extends queue
INFO - Configuration.secondPassCompile(906) | processing collection mappings
INFO - Configuration.secondPassCompile(915) | processing association property references
INFO - Configuration.secondPassCompile(937) | processing foreign key constraints
INFO - ConnectionProviderFactory.newConnectionProvider(72) | Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
INFO - SettingsFactory.buildSettings(77) | RDBMS: Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning and Oracle Label Security options
JServer Release 9.2.0.6.0 - Production
INFO - SettingsFactory.buildSettings(78) | JDBC driver: Oracle JDBC driver, version: 10.1.0.2.0
INFO - Dialect.<init>(93) | Using dialect: org.hibernate.dialect.Oracle9Dialect
INFO - TransactionFactoryFactory.buildTransactionFactory(31) | Using default transaction strategy (direct JDBC transactions)
INFO - TransactionManagerLookupFactory.getTransactionManagerLookup(33) | No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
INFO - SettingsFactory.buildSettings(125) | Automatic flush during beforeCompletion(): disabled
INFO - SettingsFactory.buildSettings(129) | Automatic session close at end of transaction: disabled
INFO - SettingsFactory.buildSettings(136) | JDBC batch size: 15
INFO - SettingsFactory.buildSettings(139) | JDBC batch updates for versioned data: disabled
INFO - SettingsFactory.buildSettings(144) | Scrollable result sets: enabled
DEBUG - SettingsFactory.buildSettings(148) | Wrap result sets: disabled
INFO - SettingsFactory.buildSettings(152) | JDBC3 getGeneratedKeys(): disabled
INFO - SettingsFactory.buildSettings(160) | Connection release mode: null
INFO - SettingsFactory.buildSettings(187) | Default batch fetch size: 1
INFO - SettingsFactory.buildSettings(191) | Generate SQL with comments: disabled
INFO - SettingsFactory.buildSettings(195) | Order SQL updates by primary key: disabled
INFO - SettingsFactory.createQueryTranslatorFactory(334) | Query translator: org.hibernate.hql.classic.ClassicQueryTranslatorFactory
INFO - SettingsFactory.buildSettings(203) | Query language substitutions: {}
INFO - SettingsFactory.buildSettings(209) | Second-level cache: enabled
INFO - SettingsFactory.buildSettings(213) | Query cache: disabled
INFO - SettingsFactory.createCacheProvider(321) | Cache provider: org.hibernate.cache.EhCacheProvider
INFO - SettingsFactory.buildSettings(228) | Optimize cache for minimal puts: disabled
INFO - SettingsFactory.buildSettings(237) | Structured second-level cache entries: disabled
DEBUG - SQLExceptionConverterFactory.buildSQLExceptionConverter(52) | Using dialect defined converter
INFO - SettingsFactory.buildSettings(261) | Statistics: disabled
INFO - SettingsFactory.buildSettings(265) | Deleted entity synthetic identifier rollback: disabled
INFO - SettingsFactory.buildSettings(279) | Default entity-mode: pojo
INFO - SessionFactoryImpl.<init>(156) | building session factory
DEBUG - SessionFactoryImpl.<init>(165) | Session factory constructed with filter configurations : {}
DEBUG - SessionFactoryImpl.<init>(168) | instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Java\j2sdk1.4.2_08\jre\bin, java.vm.version=1.4.2_08-b03, 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=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Java\web\sods, java.runtime.version=1.4.2_08-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Java\j2sdk1.4.2_08\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\WINDOWS\TEMP\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\Java\j2sdk1.4.2_08\bin;.;C:\WINDOWS\system32;C:\WINDOWS;.;C:\Java\JBuilder2005\bin;C:\Java\JBuilder2005\jdk1.4\bin;C:\Java\j2sdk1.4.2_08\bin;C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\bin;C:\Java\apache-ant-1.6.2\bin;C:\cygwin\bin;C:\Program Files\Rational\common;C:\Program Files\Rational\ClearCase\bin;C:\Program Files\Symantec\pcAnywhere\;\win32;C:\Program Files\Sybase\Shared\Web Targets;C:\Program Files\Sybase\Shared\PowerBuilder;C:\Program Files\Sybase\SQL Anywhere 8\win32;C:\Program Files\Sybase\Shared\win32;C:\Program Files\Sybase\Shared\Sybase Central 4.1;C:\Program Files\Sybase\Shared\DataDirect;C:\Program Files\Sybase\InfoMaker 9.0\Tutorial;C:\Program Files\Ghostscript\gs7.05\bin;C:\oracle\ora8i\bin;C:\oracle\ora8i\Apache\Perl\5.00503\bin\mswin32-x86;C:\Program Files\Oracle\jre\1.1.7\bin;C:\Program Files\Apache Software Foundation\Maven 1.0\bin;C:\Java\groovy-1.0-beta-7\bin;C:\Program Files\cvs;C:\Program Files\Sybase\SQL Anywhere 9\win32;C:\Program Files\Sybase\SQL Anywhere 9\drivers;C:\Program Files\Sybase\Shared\Sybase Central 4.3\win32;C:\Program Files\Sybase\InfoMaker 10.0\Tutorial;;C:\Java\JBuilder2005\debug\sa;C:\Java\JBuilder2005\lib, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, hibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory, os.version=5.1, user.home=C:\Documents and Settings\ttroy, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, show_sql=true, user.name=ttroy, java.class.path=C:\Java\web\sods\classes;C:\bea\weblogic81\server\lib\weblogic_sp.jar;C:\bea\weblogic81\server\lib\weblogic.jar;C:\bea\weblogic81\server\lib\webservices.jar;C:\softdev\lib\spring123\asm-attrs.jar;C:\softdev\lib\spring123\asm.jar;C:\softdev\lib\spring123\cglib-2.1.jar;C:\softdev\lib\spring123\commons-collections-2.1.1.jar;C:\softdev\lib\spring123\commons-logging-1.0.4.jar;C:\softdev\lib\spring123\dom4j-1.6.jar;C:\softdev\lib\spring123\ehcache-1.1.jar;C:\softdev\lib\spring123\spring.jar;C:\softdev\lib\spring123\spring-mock.jar;C:\softdev\lib\spring123\xml-apis.jar;C:\softdev\lib\hibernate31beta\antlr-2.7.5H3.jar;C:\softdev\lib\hibernate31beta\asm.jar;C:\softdev\lib\hibernate31beta\asm-attrs.jar;C:\softdev\lib\hibernate31beta\cglib-2.1.2.jar;C:\softdev\lib\hibernate31beta\commons-collections-2.1.1.jar;C:\softdev\lib\hibernate31beta\commons-logging-1.0.4.jar;C:\softdev\lib\hibernate31beta\dom4j-1.6.jar;C:\softdev\lib\hibernate31beta\hibernate3.jar;C:\softdev\lib\hibernate31beta\jdbc2_0-stdext.jar;C:\softdev\lib\hibernate31beta\jta.jar;C:\softdev\lib\hibernate31beta\log4j-1.2.9.jar;C:\softdev\lib\hibernate31beta\xml-apis.jar;C:\Java\web\sods\sodswebapp;C:\Java\web\sods\sodswebapp\WEB-INF;C:\Java\JBuilder2005\thirdparty\junit3.8\junit.jar;C:\Java\JBuilder2005\lib\unittest.jar;C:\Java\JBuilder2005\thirdparty\jakarta-taglibs-standard-1.0.6\lib\jstl.jar;C:\Java\JBuilder2005\thirdparty\jakarta-taglibs-standard-1.0.6\lib\standard.jar;C:\Java\JBuilder2005\thirdparty\jakarta-taglibs-standard-1.0.6\lib\saxpath.jar;C:\Java\JBuilder2005\thirdparty\jakarta-taglibs-standard-1.0.6\lib\jaxen-full.jar;C:\softdev\lib\HPN3rdParty\jstl.jar;C:\softdev\lib\HPN3rdParty\standard.jar;C:\softdev\lib\HPN3rdParty\taglibs-input.jar;C:\softdev\lib\HPN3rdParty\commons-beanutils-core.jar;C:\softdev\lib\server\wchpnutil.jar;C:\clims\lib\valueobjects.jar;C:\clims\lib\softdevutil.jar;C:\Java\j2sdk1.4.2_08\demo\jfc\Java2D\Java2Demo.jar;C:\Java\j2sdk1.4.2_08\demo\plugin\jfc\Java2D\Java2Demo.jar;C:\Java\j2sdk1.4.2_08\jre\javaws\javaws.jar;C:\Java\j2sdk1.4.2_08\jre\lib\charsets.jar;C:\Java\j2sdk1.4.2_08\jre\lib\ext\dnsns.jar;C:\Java\j2sdk1.4.2_08\jre\lib\ext\ldapsec.jar;C:\Java\j2sdk1.4.2_08\jre\lib\ext\localedata.jar;C:\Java\j2sdk1.4.2_08\jre\lib\ext\sunjce_provider.jar;C:\Java\j2sdk1.4.2_08\jre\lib\im\indicim.jar;C:\Java\j2sdk1.4.2_08\jre\lib\im\thaiim.jar;C:\Java\j2sdk1.4.2_08\jre\lib\jce.jar;C:\Java\j2sdk1.4.2_08\jre\lib\jsse.jar;C:\Java\j2sdk1.4.2_08\jre\lib\plugin.jar;C:\Java\j2sdk1.4.2_08\jre\lib\rt.jar;C:\Java\j2sdk1.4.2_08\jre\lib\sunrsasign.jar;C:\Java\j2sdk1.4.2_08\lib\dt.jar;C:\Java\j2sdk1.4.2_08\lib\htmlconverter.jar;C:\Java\j2sdk1.4.2_08\lib\tools.jar, java.vm.specification.version=1.0, java.home=C:\Java\j2sdk1.4.2_08\jre, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.2_08, java.ext.dirs=C:\Java\j2sdk1.4.2_08\jre\lib\ext, sun.boot.class.path=C:\Java\j2sdk1.4.2_08\jre\lib\rt.jar;C:\Java\j2sdk1.4.2_08\jre\lib\i18n.jar;C:\Java\j2sdk1.4.2_08\jre\lib\sunrsasign.jar;C:\Java\j2sdk1.4.2_08\jre\lib\jsse.jar;C:\Java\j2sdk1.4.2_08\jre\lib\jce.jar;C:\Java\j2sdk1.4.2_08\jre\lib\charsets.jar;C:\Java\j2sdk1.4.2_08\jre\classes, java.vendor=Sun Microsystems Inc., connection.driver_class=oracle.jdbc.driver.OracleDriver, file.separator=\, hibernate.connection.provider_class=org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, dialect=net.sf.hibernate.dialect.Oracle9Dialect, sun.cpu.isalist=pentium i486 i386}
WARN - Configurator.configure(126) | No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/softdev/lib/spring123/ehcache-1.1.jar!/ehcache-failsafe.xml
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.OrderDetail
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select ORDERDETAILID from SODS.ORDER_DETAILS where ORDERDETAILID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select orderdetai_.ORDERDETAILID, orderdetai_.ORDERID as ORDERID6_, orderdetai_.PRODUCTID as PRODUCTID6_, orderdetai_.QUANTITY as QUANTITY6_, orderdetai_.UNITPRICE as UNITPRICE6_, orderdetai_.DISCOUNT as DISCOUNT6_, orderdetai_.CHARGE_BACK_CODE as CHARGE7_6_ from SODS.ORDER_DETAILS orderdetai_ where orderdetai_.ORDERDETAILID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.ORDER_DETAILS (ORDERID, PRODUCTID, QUANTITY, UNITPRICE, DISCOUNT, CHARGE_BACK_CODE, ORDERDETAILID) values (?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.ORDER_DETAILS set ORDERID=?, PRODUCTID=?, QUANTITY=?, UNITPRICE=?, DISCOUNT=?, CHARGE_BACK_CODE=? where ORDERDETAILID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.ORDER_DETAILS where ORDERDETAILID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.UpsFacility
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select ID from SODS.UPS_FACILITY where ID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select upsfacilit_.ID, upsfacilit_.FACILITY_ID as FACILITY2_16_, upsfacilit_.CUSTOMERID as CUSTOMERID16_, upsfacilit_.COMPANYORNAME as COMPANYO4_16_, upsfacilit_.ATTENTION as ATTENTION16_, upsfacilit_.STREET as STREET16_, upsfacilit_.ROOMFLOORADDRESS2 as ROOMFLOO7_16_, upsfacilit_.DEPARTMENTADDRESS3 as DEPARTME8_16_, upsfacilit_.CITY as CITY16_, upsfacilit_.STATEPROV as STATEPROV16_, upsfacilit_.POSTALZIPCODE as POSTALZ11_16_, upsfacilit_.COUNTRY as COUNTRY16_, upsfacilit_.TELEPHONE as TELEPHONE16_, upsfacilit_.FAXNUMBER as FAXNUMBER16_, upsfacilit_.UPSACCOUNTNUMBER as UPSACCO15_16_, upsfacilit_.TAXID as TAXID16_, upsfacilit_.TAXIDTYPE as TAXIDTYPE16_, upsfacilit_.LOCATIONID as LOCATIONID16_, upsfacilit_.CONSIGNEEBILLED as CONSIGN19_16_, upsfacilit_.RESIDENTIALINDICATOR as RESIDEN20_16_, upsfacilit_.EMAILADDRESS as EMAILAD21_16_, upsfacilit_.KIT_FACILITY_ID as KIT22_16_, upsfacilit_.CONTEXT as CONTEXT16_, upsfacilit_.ADDRESS_MATCHED as ADDRESS24_16_ from SODS.UPS_FACILITY upsfacilit_ where upsfacilit_.ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.UPS_FACILITY (FACILITY_ID, CUSTOMERID, COMPANYORNAME, ATTENTION, STREET, ROOMFLOORADDRESS2, DEPARTMENTADDRESS3, CITY, STATEPROV, POSTALZIPCODE, COUNTRY, TELEPHONE, FAXNUMBER, UPSACCOUNTNUMBER, TAXID, TAXIDTYPE, LOCATIONID, CONSIGNEEBILLED, RESIDENTIALINDICATOR, EMAILADDRESS, KIT_FACILITY_ID, CONTEXT, ADDRESS_MATCHED, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.UPS_FACILITY set FACILITY_ID=?, CUSTOMERID=?, COMPANYORNAME=?, ATTENTION=?, STREET=?, ROOMFLOORADDRESS2=?, DEPARTMENTADDRESS3=?, CITY=?, STATEPROV=?, POSTALZIPCODE=?, COUNTRY=?, TELEPHONE=?, FAXNUMBER=?, UPSACCOUNTNUMBER=?, TAXID=?, TAXIDTYPE=?, LOCATIONID=?, CONSIGNEEBILLED=?, RESIDENTIALINDICATOR=?, EMAILADDRESS=?, KIT_FACILITY_ID=?, CONTEXT=?, ADDRESS_MATCHED=? where ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.UPS_FACILITY where ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.CustomerContact
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select CUSTOMERCONTACTID from SODS.CUSTOMER_CONTACT where CUSTOMERCONTACTID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select customerco_.CUSTOMERCONTACTID, customerco_.CUSTOMER_ID as CUSTOMER2_1_, customerco_.CONTACT_ID as CONTACT3_1_, customerco_.LAST_NAME as LAST4_1_, customerco_.FIRST_NAME as FIRST5_1_, customerco_.MI as MI1_, customerco_.PHONE as PHONE1_, customerco_.STATUS as STATUS1_ from SODS.CUSTOMER_CONTACT customerco_ where customerco_.CUSTOMERCONTACTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.CUSTOMER_CONTACT (CUSTOMER_ID, CONTACT_ID, LAST_NAME, FIRST_NAME, MI, PHONE, STATUS, CUSTOMERCONTACTID) values (?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.CUSTOMER_CONTACT set CUSTOMER_ID=?, CONTACT_ID=?, LAST_NAME=?, FIRST_NAME=?, MI=?, PHONE=?, STATUS=? where CUSTOMERCONTACTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.CUSTOMER_CONTACT where CUSTOMERCONTACTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.Month
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select MONTH_ID from SODS.MONTHS where MONTH_ID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select month_.MONTH_ID, month_.MONTH_DESC as MONTH2_3_ from SODS.MONTHS month_ where month_.MONTH_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.MONTHS (MONTH_DESC, MONTH_ID) values (?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.MONTHS set MONTH_DESC=? where MONTH_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.MONTHS where MONTH_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.Product
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select PRODUCTID from SODS.PRODUCTS where PRODUCTID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select product_.PRODUCTID, product_.PRODUCTNAME as PRODUCTN2_10_, product_.DOH_NUMBER as DOH3_10_, product_.UNITPRICE as UNITPRICE10_, product_.STATUS as STATUS10_, product_.CHARGE_BACK_CODE as CHARGE6_10_, product_.LABELCOLOR as LABELCOLOR10_, product_.CONFIGURATION as CONFIGUR8_10_, product_.PI_CODE as PI9_10_, product_.COMMENT_ as COMMENT10_10_ from SODS.PRODUCTS product_ where product_.PRODUCTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.PRODUCTS (PRODUCTNAME, DOH_NUMBER, UNITPRICE, STATUS, CHARGE_BACK_CODE, LABELCOLOR, CONFIGURATION, PI_CODE, COMMENT_, PRODUCTID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.PRODUCTS set PRODUCTNAME=?, DOH_NUMBER=?, UNITPRICE=?, STATUS=?, CHARGE_BACK_CODE=?, LABELCOLOR=?, CONFIGURATION=?, PI_CODE=?, COMMENT_=? where PRODUCTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.PRODUCTS where PRODUCTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.Order
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select ORDERID from SODS.ORDERS where ORDERID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select order_.ORDERID, order_.CUSTOMERID as CUSTOMERID5_, order_.EMPLOYEEID as EMPLOYEEID5_, order_.ORDERDATE as ORDERDATE5_, order_.PURCHASEORDERNUMBER as PURCHASE5_5_, order_.SHIPNAME as SHIPNAME5_, order_.SHIPADDRESS as SHIPADDR7_5_, order_.SHIPCITY as SHIPCITY5_, order_.SHIPSTATEORPROVINCE as SHIPSTAT9_5_, order_.SHIPPOSTALCODE as SHIPPOS10_5_, order_.SHIPCOUNTRY as SHIPCOU11_5_, order_.SHIPPHONENUMBER as SHIPPHO12_5_, order_.SHIPDATE as SHIPDATE5_, order_.SHIPPINGMETHODID as SHIPPIN14_5_, order_.FREIGHTCHARGE as FREIGHT15_5_, order_.SALESTAXRATE as SALESTA16_5_, order_.PI_CODE as PI17_5_, order_.STATUS as STATUS5_, order_.LASTNAME as LASTNAME5_, order_.FIRSTNAME as FIRSTNAME5_, order_.MI as MI5_, order_.UPSTRACKINGNUMBER as UPSTRAC22_5_, order_.SHIPPINGINSTRUCTION as SHIPPIN23_5_, order_.REFERENCE_NUM as REFERENCE24_5_ from SODS.ORDERS order_ where order_.ORDERID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.ORDERS (CUSTOMERID, EMPLOYEEID, ORDERDATE, PURCHASEORDERNUMBER, SHIPNAME, SHIPADDRESS, SHIPCITY, SHIPSTATEORPROVINCE, SHIPPOSTALCODE, SHIPCOUNTRY, SHIPPHONENUMBER, SHIPDATE, SHIPPINGMETHODID, FREIGHTCHARGE, SALESTAXRATE, PI_CODE, STATUS, LASTNAME, FIRSTNAME, MI, UPSTRACKINGNUMBER, SHIPPINGINSTRUCTION, REFERENCE_NUM, ORDERID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.ORDERS set CUSTOMERID=?, EMPLOYEEID=?, ORDERDATE=?, PURCHASEORDERNUMBER=?, SHIPNAME=?, SHIPADDRESS=?, SHIPCITY=?, SHIPSTATEORPROVINCE=?, SHIPPOSTALCODE=?, SHIPCOUNTRY=?, SHIPPHONENUMBER=?, SHIPDATE=?, SHIPPINGMETHODID=?, FREIGHTCHARGE=?, SALESTAXRATE=?, PI_CODE=?, STATUS=?, LASTNAME=?, FIRSTNAME=?, MI=?, UPSTRACKINGNUMBER=?, SHIPPINGINSTRUCTION=?, REFERENCE_NUM=? where ORDERID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.ORDERS where ORDERID=?
DEBUG - BasicEntityPersister.logStaticSQL(2305) | Identity insert: insert into SODS.ORDERS (CUSTOMERID, EMPLOYEEID, ORDERDATE, PURCHASEORDERNUMBER, SHIPNAME, SHIPADDRESS, SHIPCITY, SHIPSTATEORPROVINCE, SHIPPOSTALCODE, SHIPCOUNTRY, SHIPPHONENUMBER, SHIPDATE, SHIPPINGMETHODID, FREIGHTCHARGE, SALESTAXRATE, PI_CODE, STATUS, LASTNAME, FIRSTNAME, MI, UPSTRACKINGNUMBER, SHIPPINGINSTRUCTION, REFERENCE_NUM) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.ShippingMethod
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select SHIPPINGMETHODID from SODS.SHIPPING_METHODS where SHIPPINGMETHODID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select shippingme_.SHIPPINGMETHODID, shippingme_.SHIPPINGMETHOD as SHIPPING2_12_ from SODS.SHIPPING_METHODS shippingme_ where shippingme_.SHIPPINGMETHODID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.SHIPPING_METHODS (SHIPPINGMETHOD, SHIPPINGMETHODID) values (?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.SHIPPING_METHODS set SHIPPINGMETHOD=? where SHIPPINGMETHODID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.SHIPPING_METHODS where SHIPPINGMETHODID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.State
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select STATE_ABBREV from SODS.STATE where STATE_ABBREV =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select state_.STATE_ABBREV, state_.STATE_NAME as STATE2_13_ from SODS.STATE state_ where state_.STATE_ABBREV=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.STATE (STATE_NAME, STATE_ABBREV) values (?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.STATE set STATE_NAME=? where STATE_ABBREV=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.STATE where STATE_ABBREV=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.Employee
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select EMPLOYEEID from SODS.EMPLOYEES where EMPLOYEEID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select employee_.EMPLOYEEID, employee_.FIRSTNAME as FIRSTNAME2_, employee_.LASTNAME as LASTNAME2_, employee_.TITLE as TITLE2_, employee_.EXTENSION as EXTENSION2_, employee_.WORKPHONE as WORKPHONE2_ from SODS.EMPLOYEES employee_ where employee_.EMPLOYEEID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.EMPLOYEES (FIRSTNAME, LASTNAME, TITLE, EXTENSION, WORKPHONE, EMPLOYEEID) values (?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.EMPLOYEES set FIRSTNAME=?, LASTNAME=?, TITLE=?, EXTENSION=?, WORKPHONE=? where EMPLOYEEID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.EMPLOYEES where EMPLOYEEID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.MyCompanyInformation
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select SETUPID from SODS.MY_COMPANY_INFORMATION where SETUPID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select mycompanyi_.SETUPID, mycompanyi_.SALESTAXRATE as SALESTAX2_4_, mycompanyi_.COMPANYNAME as COMPANYN3_4_, mycompanyi_.ADDRESS as ADDRESS4_, mycompanyi_.CITY as CITY4_, mycompanyi_.STATEORPROVINCE as STATEORP6_4_, mycompanyi_.POSTALCODE as POSTALCODE4_, mycompanyi_.COUNTRY as COUNTRY4_, mycompanyi_.PHONENUMBER as PHONENUM9_4_, mycompanyi_.FAXNUMBER as FAXNUMBER4_, mycompanyi_.DEFAULTPAYMENTTERMS as DEFAULT11_4_, mycompanyi_.DEFAULTINVOICEDESCRIPTION as DEFAULT12_4_ from SODS.MY_COMPANY_INFORMATION mycompanyi_ where mycompanyi_.SETUPID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.MY_COMPANY_INFORMATION (SALESTAXRATE, COMPANYNAME, ADDRESS, CITY, STATEORPROVINCE, POSTALCODE, COUNTRY, PHONENUMBER, FAXNUMBER, DEFAULTPAYMENTTERMS, DEFAULTINVOICEDESCRIPTION, SETUPID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.MY_COMPANY_INFORMATION set SALESTAXRATE=?, COMPANYNAME=?, ADDRESS=?, CITY=?, STATEORPROVINCE=?, POSTALCODE=?, COUNTRY=?, PHONENUMBER=?, FAXNUMBER=?, DEFAULTPAYMENTTERMS=?, DEFAULTINVOICEDESCRIPTION=? where SETUPID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.MY_COMPANY_INFORMATION where SETUPID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.Customer
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select CUSTOMERID from SODS.CUSTOMERS where CUSTOMERID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select customer_.CUSTOMERID, customer_.COMPANYNAME as COMPANYN2_0_, customer_.CONTACTFIRSTNAME as CONTACTF3_0_, customer_.CONTACTLASTNAME as CONTACTL4_0_, customer_.BILLINGADDRESS as BILLINGA5_0_, customer_.CITY as CITY0_, customer_.STATEORPROVINCE as STATEORP7_0_, customer_.POSTALCODE as POSTALCODE0_, customer_.COUNTRY as COUNTRY0_, customer_.CONTACTTITLE as CONTACT10_0_, customer_.PHONENUMBER as PHONENU11_0_, customer_.FAXNUMBER as FAXNUMBER0_, customer_.FACILITY_ID as FACILITY13_0_, customer_.ROOMFLOORADDRESS2 as ROOMFLO14_0_, customer_.DEPARTMENTADDRESS3 as DEPARTM15_0_, customer_.UPSACCOUNTNUMBER as UPSACCO16_0_, customer_.TAXID as TAXID0_, customer_.TAXIDTYPE as TAXIDTYPE0_, customer_.LOCATIONID as LOCATIONID0_, customer_.CONSIGNEEBILLED as CONSIGN20_0_, customer_.RESIDENTIALINDICATOR as RESIDEN21_0_, customer_.EMAILADDRESS as EMAILAD22_0_, customer_.KIT_FACILITY_ID as KIT23_0_, customer_.CONTEXT as CONTEXT0_, customer_.UPS_CUST_ID as UPS25_0_, customer_.CREATED as CREATED0_, customer_.CREATED_DATE as CREATED27_0_, customer_.DATA_CLEANED as DATA28_0_, customer_.PHONE_EXT as PHONE29_0_ from SODS.CUSTOMERS customer_ where customer_.CUSTOMERID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.CUSTOMERS (COMPANYNAME, CONTACTFIRSTNAME, CONTACTLASTNAME, BILLINGADDRESS, CITY, STATEORPROVINCE, POSTALCODE, COUNTRY, CONTACTTITLE, PHONENUMBER, FAXNUMBER, FACILITY_ID, ROOMFLOORADDRESS2, DEPARTMENTADDRESS3, UPSACCOUNTNUMBER, TAXID, TAXIDTYPE, LOCATIONID, CONSIGNEEBILLED, RESIDENTIALINDICATOR, EMAILADDRESS, KIT_FACILITY_ID, CONTEXT, UPS_CUST_ID, CREATED, CREATED_DATE, DATA_CLEANED, PHONE_EXT, CUSTOMERID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.CUSTOMERS set COMPANYNAME=?, CONTACTFIRSTNAME=?, CONTACTLASTNAME=?, BILLINGADDRESS=?, CITY=?, STATEORPROVINCE=?, POSTALCODE=?, COUNTRY=?, CONTACTTITLE=?, PHONENUMBER=?, FAXNUMBER=?, FACILITY_ID=?, ROOMFLOORADDRESS2=?, DEPARTMENTADDRESS3=?, UPSACCOUNTNUMBER=?, TAXID=?, TAXIDTYPE=?, LOCATIONID=?, CONSIGNEEBILLED=?, RESIDENTIALINDICATOR=?, EMAILADDRESS=?, KIT_FACILITY_ID=?, CONTEXT=?, UPS_CUST_ID=?, CREATED=?, CREATED_DATE=?, DATA_CLEANED=?, PHONE_EXT=? where CUSTOMERID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.CUSTOMERS where CUSTOMERID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.OrderStatus
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select ORDER_STATUS_ID from SODS.ORDER_STATUS where ORDER_STATUS_ID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select orderstatu_.ORDER_STATUS_ID, orderstatu_.ORDER_STATUS_NAME as ORDER2_7_ from SODS.ORDER_STATUS orderstatu_ where orderstatu_.ORDER_STATUS_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.ORDER_STATUS (ORDER_STATUS_NAME, ORDER_STATUS_ID) values (?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.ORDER_STATUS set ORDER_STATUS_NAME=? where ORDER_STATUS_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.ORDER_STATUS where ORDER_STATUS_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.Payment
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select PAYMENTID from SODS.PAYMENTS where PAYMENTID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select payment_.PAYMENTID, payment_.ORDERID as ORDERID8_, payment_.PAYMENTAMOUNT as PAYMENTA3_8_, payment_.PAYMENTDATE as PAYMENTD4_8_, payment_.CREDITCARDNUMBER as CREDITCA5_8_, payment_.CARDHOLDERSNAME as CARDHOLD6_8_, payment_.CREDITCARDEXPDATE as CREDITCA7_8_, payment_.PAYMENTMETHODID as PAYMENTM8_8_ from SODS.PAYMENTS payment_ where payment_.PAYMENTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.PAYMENTS (ORDERID, PAYMENTAMOUNT, PAYMENTDATE, CREDITCARDNUMBER, CARDHOLDERSNAME, CREDITCARDEXPDATE, PAYMENTMETHODID, PAYMENTID) values (?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.PAYMENTS set ORDERID=?, PAYMENTAMOUNT=?, PAYMENTDATE=?, CREDITCARDNUMBER=?, CARDHOLDERSNAME=?, CREDITCARDEXPDATE=?, PAYMENTMETHODID=? where PAYMENTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.PAYMENTS where PAYMENTID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.ShipOrder
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select ID from SODS.SHIPORDERS where ID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select shiporder_.ID, shiporder_.ORDERID as ORDERID11_, shiporder_.CUSTOMERID as CUSTOMERID11_, shiporder_.EMPLOYEEID as EMPLOYEEID11_, shiporder_.ORDERDATE as ORDERDATE11_, shiporder_.PURCHASEORDERNUMBER as PURCHASE6_11_, shiporder_.REQUIREDBYDATE as REQUIRED7_11_, shiporder_.PROMISEDBYDATE as PROMISED8_11_, shiporder_.SHIPNAME as SHIPNAME11_, shiporder_.SHIPADDRESS as SHIPADD10_11_, shiporder_.SHIPCITY as SHIPCITY11_, shiporder_.SHIPSTATE as SHIPSTATE11_, shiporder_.SHIPSTATEORPROVINCE as SHIPSTA13_11_, shiporder_.SHIPPOSTALCODE as SHIPPOS14_11_, shiporder_.SHIPCOUNTRY as SHIPCOU15_11_, shiporder_.SHIPPHONENUMBER as SHIPPHO16_11_, shiporder_.SHIPDATE as SHIPDATE11_, shiporder_.SHIPPINGMETHODID as SHIPPIN18_11_, shiporder_.FREIGHTCHARGE as FREIGHT19_11_, shiporder_.SALESTAXRATE as SALESTA20_11_ from SODS.SHIPORDERS shiporder_ where shiporder_.ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.SHIPORDERS (ORDERID, CUSTOMERID, EMPLOYEEID, ORDERDATE, PURCHASEORDERNUMBER, REQUIREDBYDATE, PROMISEDBYDATE, SHIPNAME, SHIPADDRESS, SHIPCITY, SHIPSTATE, SHIPSTATEORPROVINCE, SHIPPOSTALCODE, SHIPCOUNTRY, SHIPPHONENUMBER, SHIPDATE, SHIPPINGMETHODID, FREIGHTCHARGE, SALESTAXRATE, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.SHIPORDERS set ORDERID=?, CUSTOMERID=?, EMPLOYEEID=?, ORDERDATE=?, PURCHASEORDERNUMBER=?, REQUIREDBYDATE=?, PROMISEDBYDATE=?, SHIPNAME=?, SHIPADDRESS=?, SHIPCITY=?, SHIPSTATE=?, SHIPSTATEORPROVINCE=?, SHIPPOSTALCODE=?, SHIPCOUNTRY=?, SHIPPHONENUMBER=?, SHIPDATE=?, SHIPPINGMETHODID=?, FREIGHTCHARGE=?, SALESTAXRATE=? where ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.SHIPORDERS where ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.Status
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select STATUS_ID from SODS.STATUS where STATUS_ID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select status_.STATUS_ID, status_.STATUS_NAME as STATUS2_14_ from SODS.STATUS status_ where status_.STATUS_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.STATUS (STATUS_NAME, STATUS_ID) values (?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.STATUS set STATUS_NAME=? where STATUS_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.STATUS where STATUS_ID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.PaymentMethod
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select PAYMENTMETHODID from SODS.PAYMENT_METHODS where PAYMENTMETHODID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select paymentmet_.PAYMENTMETHODID, paymentmet_.PAYMENTMETHOD as PAYMENTM2_9_, paymentmet_.CREDITCARD as CREDITCARD9_ from SODS.PAYMENT_METHODS paymentmet_ where paymentmet_.PAYMENTMETHODID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.PAYMENT_METHODS (PAYMENTMETHOD, CREDITCARD, PAYMENTMETHODID) values (?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.PAYMENT_METHODS set PAYMENTMETHOD=?, CREDITCARD=? where PAYMENTMETHODID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.PAYMENT_METHODS where PAYMENTMETHODID=?
DEBUG - BasicEntityPersister.logStaticSQL(2295) | Static SQL for entity: org.wadsworth.sods.model.SwitchboardItem
DEBUG - BasicEntityPersister.logStaticSQL(2297) | Version select: select SWITCHBOARDID from SODS.SWITCHBOARD_ITEMS where SWITCHBOARDID =?
DEBUG - BasicEntityPersister.logStaticSQL(2298) | Snapshot select: select switchboar_.SWITCHBOARDID, switchboar_.ITEMNUMBER as ITEMNUMBER15_, switchboar_.ITEMTEXT as ITEMTEXT15_, switchboar_.COMMAND as COMMAND15_, switchboar_.ARGUMENT as ARGUMENT15_ from SODS.SWITCHBOARD_ITEMS switchboar_ where switchboar_.SWITCHBOARDID=?
DEBUG - BasicEntityPersister.logStaticSQL(2300) | Insert 0: insert into SODS.SWITCHBOARD_ITEMS (ITEMNUMBER, ITEMTEXT, COMMAND, ARGUMENT, SWITCHBOARDID) values (?, ?, ?, ?, ?)
DEBUG - BasicEntityPersister.logStaticSQL(2301) | Update 0: update SODS.SWITCHBOARD_ITEMS set ITEMNUMBER=?, ITEMTEXT=?, COMMAND=?, ARGUMENT=? where SWITCHBOARDID=?
DEBUG - BasicEntityPersister.logStaticSQL(2302) | Delete 0: delete from SODS.SWITCHBOARD_ITEMS where SWITCHBOARDID=?
DEBUG - EntityLoader.<init>(96) | Static select for entity org.wadsworth.sods.model.OrderDetail: select orderdetai0_.ORDERDETAILID as ORDERDET1_6_0_, orderdetai0_.ORDERID as ORDERID6_0_, orderdetai0_.PRODUCTID as PRODUCTID6_0_, orderdetai0_.QUANTITY as QUANTITY6_0_, orderdetai0_.UNITPRICE as UNITPRICE6_0_, orderdetai0_.DISCOUNT as DISCOUNT6_0_, orderdetai0_.CHARGE_BACK_CODE as CHARGE7_6_0_ from SODS.ORDER_DETAILS orderdetai0_ where orderdetai0_.ORDERDETAILID=?
DEBUG - EntityLoader.<init>(96) | Static select for entity org.wadsworth.sods.model.OrderDetail: select orderdetai0_.ORDERDETAILID as ORDERDET1_6_0_, orderdetai0_.ORDERID as ORDERID6_0_, orderdetai0_.PRODUCTID as PRODUCTID6_0_, orderdetai0_.QUANTITY as QUANTITY6_0_, orderdetai0_.UNITPRICE as UNITPRICE6_0_, orderdetai0_.DISCOUNT as DISCOUNT6_0_, orderdetai0_.CHARGE_BACK_CODE as CHARGE7_6_0_ from SODS.ORDER_DETAILS orderdetai0_ where orderdetai0_.ORDERDETAILID=?
DEBUG - EntityLoader.<init>(96) | Static select for entity org.wadsworth.sods.model.OrderDetail: select orderdetai0_.ORDERDETAILID as ORDERDET1_6_0_, orderdetai0_.ORDERID as ORDERID6_0_, orderdetai0_.PRODUCTID as PRODUCTID6_0_, orderdetai0_.QUANTITY as QUANTITY6_0_, orderdetai0_.UNITPRICE as UNITPRICE6_0_, orderdetai0_.DISCOUNT as DISCOUNT6_0_, orderdetai0_.CHARGE_BACK_CODE as CHARGE7_6_0_ from SODS.ORDER_DETAILS orderdetai0_ where orderdetai0_.ORDERDETAILID=? for update
DEBUG - EntityLoader.<init>(96) | Static select for entity org.wadsworth.sods.model.OrderDetail: select orderdetai0_.ORDERDETAILID as ORDERDET1_6_0_, orderdetai0_.ORDERID as ORDERID6_0_, orderdetai0_.PRODUCTID as PRODUCTID6_0_, orderdetai0_.QUANTITY as QUANTITY6_0_, orderdetai0_.UNITPRICE as UNITPRICE6_0_, orderdetai0_.DISCOUNT as DISCOUNT6_0_, orderdetai0_.CHARGE_BACK_CODE as CHARGE7_6_0_ from SODS.ORDER_DETAILS orderdetai0_ where orderdetai0_.ORDERDETAILID=? for update nowait
DEBUG - EntityLoader.<init>(96) | Static select for entity org.wadsworth.sods.model.UpsFacility: select upsfacilit0_.ID as ID16_0_, upsfacilit0_.FACILITY_ID as FACILITY2_16_0_, upsfacilit0_.CUSTOMERID as CUSTOMERID16_0_, upsfacilit0_.COMPANYORNAME as COMPANYO4_16_0_, upsfacilit0_.ATTENTION as ATTENTION16_0_, upsfacilit0_.STREET as STREET16_0_, upsfacilit0_.ROOMFLOORADDRESS2 as ROOMFLOO7_16_0_, upsfacilit0_.DEPARTMENTADDRESS3 as DEPARTME8_16_0_, upsfacilit0_.CITY as CITY16_0_, upsfacilit0_.STATEPROV as STATEPROV16_0_, upsfacilit0_.POSTALZIPCODE as POSTALZ11_16_0_, upsfacilit0_.COUNTRY as COUNTRY16_0_, upsfacilit0_.TELEPHONE as TELEPHONE16_0_, upsfacilit0_.FAXNUMBER as FAXNUMBER16_0_, upsfacilit0_.UPSACCOUNTNUMBER as UPSACCO15_16_0_, upsfacilit0_.TAXID as TAXID16_0_, upsfacilit0_.TAXIDTYPE as TAXIDTYPE16_0_, upsfacilit0_.LOCATIONID as LOCATIONID16_0_, upsfacilit0_.CONSIGNE

No, it is not possible. Try to understand what this generator is supposed to do:

1) insert record without id, but filling other properties.
2) select inserted record back to find out assigned id.

In order to able to get record back table should have unique field other that id - natural key, that will be inserted at first step.

While I wish your answer was something else, I now understand the usage of the select generator. Thanks.

This could work if the org.hibernate.HibernateException: Unable to resolve property: id didn't happen. What I didn't realize yesterday is that the database inserts do happen even when the exception is thrown. This morning I changed my mapping file and ran my unit tests. Once I looked at the database, I saw that all my tests that "failed" yesterday did insert records.

My original desire to use the select generator seems to be possible. The exception was thrown because it did not find my id property not because the insert failed.

Or you can maybe use this id generator: http://forum.hibernate.org/viewtopic.php?t=973262