ok, i've been going crazy with getting versioning to work correctly. When I use a version of type Integer, things work ok. When I change this to use a type of timestamp, it doesn't work. The values are populated in the objects but for some reason (here is the problem) the ID of the parent is not transferred onto the child and I get a "cannot insert null in column" exception. This only occurs when I use timestamp. When I use integer, the parent generated ID gets copied onto the child.

I'm using hibernate 3.1.

My parent has a one-to-many with child and is using a a custom generator, here are all the mappings:

The parents TCTransmission/TCTransaction mappings don't seem to have an issue with timestamp but I think it is FXExecution where the column trans_id doesn't get populated.

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

<hibernate-mapping package="com.ms.pbcustody.transcapfx.model">
<class name="TCTransmission" table="TransCapture_beta..tc_transmission">

<cache usage="read-write"/>

<id name="transmissionId" column="transmission_id">
<generator class="assigned" />
</id>
<property name="userId" column="user_id" not-null="true" />
<property name="transmissionStatus" column="transmission_status" not-null="true" />
<property name="buClientId" column="bu_client_id" not-null="true" />
<property name="transmissionMnemonic" column="transmission_mnemonic" not-null="true" />
<property name="transmissionTime" column="transmission_time" not-null="true" />
<property name="postingTime" column="posting_time" />

<set name="transactions" inverse="true" fetch="join" cascade="all">
<cache usage="read-write"/>
<key column="transmission_id" not-null="true" />
<one-to-many class="TCTransaction" />
</set>

</class>

</hibernate-mapping>


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

<hibernate-mapping package="com.ms.pbcustody.transcapfx.model">
<class name="TCTransaction" table="TransCapture_beta..tc_transaction">
<cache usage="read-write"/>
<id name="transactionId" column="trans_id">
<generator class="com.ms.pbcustody.transcapfx.model.TransactionIdGenerator" />
</id>
<version name="storeTime" column="store_time" type="timestamp"/>
<property name="userId" column="user_id" not-null="true" />
<property name="transmissionId" column="transmission_id" not-null="true" />
<property name="transactionType" column="transaction_type" not-null="true" />
<property name="transactionStatus" column="transaction_status" not-null="true" />
<property name="processFlag" column="process_flag" not-null="true" />
<property name="authorizationTime" column="authorization_time" />
<property name="processingTime" column="processing_time" />
<property name="completionTime" column="completion_time" />
<property name="loginName" column="login_name" />
<property name="origTransId" column="orig_trans_id" />
<property name="referenceNo" column="reference_no" />
<property name="buClientId" column="bu_client_id" />
<property name="lastTransactionStatus" column="last_transaction_status" />
<property name="currentFlag" column="current_flag" not-null="true" optimistic-lock="false"/>
<property name="contentType" column="content_type" />
<property name="uuid" column="uuid" />

<set name="executions" inverse="true" cascade="all">
<cache usage="read-write"/>
<key column="trans_id" not-null="true" />
<one-to-many class="com.ms.pbcustody.transcapfx.model.FXExecution" />
</set>
<set name="allocations" inverse="true" cascade="all">
<cache usage="read-write"/>
<key column="trans_id" not-null="true" />
<one-to-many class="com.ms.pbcustody.transcapfx.model.FXAllocation" />
</set>
<many-to-one name="transmission" column="transmission_id" class="TCTransmission" fetch="join" update="false" insert="false" not-null="true" />
</class>
</hibernate-mapping>

When I uncomment the 1st version and use that instead of the 2nd one, everything seems to work.

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

<hibernate-mapping package="com.ms.pbcustody.transcapfx.model">
<class name="FXExecution" table="TransCapture_beta..fx_execution">

<cache usage="read-write"/>

<composite-id>
<key-property name="transactionId" column="trans_id"/>
<key-property name="seqNo" column="seq_no" />
</composite-id>

<!-- <version name="version" unsaved-value="null"/>-->
<version name="updateTime" column="update_time" type="timestamp"/>
<property name="recordType" column="record_type" />
<property name="transactionType" column="transaction_type" />
<property name="transactionLevel" column="transaction_level"/>
<property name="productType" column="product_type"/>
<property name="referenceNo" column="reference_no"/>
<property name="blockId" column="block_id"/>
<property name="executionAccountNo" column="exec_account_no"/>
<property name="accountNo" column="account_no"/>
<property name="executionBroker" column="exec_broker"/>
<property name="tradeDate" column="trade_date"/>
<property name="settlementDate" column="settlement_date"/>
<property name="buyCcy" column="buy_ccy"/>
<property name="sellCcy" column="sell_ccy"/>
<property name="buyQuantity" column="buy_quantity"/>
<property name="sellQuantity" column="sell_quantity"/>
<property name="fxRate" column="fx_rate"/>
<property name="clientBaseEquivalent" column="client_base_equivalent"/>
<property name="hedgeVsSpeculative" column="hedge_vs_speculative"/>
<property name="hearsayIndicator" column="hearsay_ind"/>
<property name="taxIndicator" column="tax_ind"/>
<property name="custodianBroker" column="custodian_broker"/>
<property name="moneyManager" column="money_manager"/>
<property name="bookId" column="book_id"/>
<property name="dealId" column="deal_id"/>
<property name="exchangeRate" column="exch_rate"/>
<property name="acquisationDate" column="acquisation_date"/>
<property name="comments" column="comments"/>
<property name="linkId" column="link_id"/>

<many-to-one name="Transaction" column="trans_id" class="TCTransaction" fetch="join" update="false" insert="false" not-null="true" />

</class>
</hibernate-mapping>


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="SybaseSession">
<property name="hibernate.dialect">org.hibernate.dialect.SybaseDialect</property>
<property name="connection.url">jdbc:sybase:Tds:paidb274:7464</property>
<property name="connection.username">transcap</property>
<property name="connection.password">Pearljam4$</property>
<property name="hibernate.jdbc.batch_size">30</property>

<!-- 2nd-level cache -->
<property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
<property name="hibernate.cache.use_second_level_cache">true</property>
<property name="hibernate.cache.use_minimal_puts">true</property>
<property name="hibernate.cache.use_structured_entries">true</property>
<property name="hibernate.generate_statistics">true</property>

<property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property>

<!-- Query cache -->
<property name="hibernate.cache.use_query_cache">true</property>

<!-- Echo all executed SQL to stdout -->
<property name="show_sql">false</property>

<mapping resource="com/ms/pbcustody/transcapfx/model/TCTransaction.hbm.xml"/>
<mapping resource="com/ms/pbcustody/transcapfx/model/TCTransmission.hbm.xml"/>
<mapping resource="com/ms/pbcustody/transcapfx/model/FXExecution.hbm.xml"/>
<mapping resource="com/ms/pbcustody/transcapfx/model/FXAllocation.hbm.xml"/>
</session-factory>
</hibernate-configuration>



The code i'm using is simple, i'm doing a cascade on all child objects:


tx = session.beginTransaction();
TCTransmission tcTransmission = (TCTransmission) session.get(TCTransmission.class, String.valueOf(transmission.getTransmissionId()));
if (tcTransmission == null) {
tcTransmission = new TCTransmission();
}
tcTransmission.fromTransmission(transmission);
session.saveOrUpdate(tcTransmission);
tx.commit();

Logs don't indicate a problem with the mapping:

13:56:40,387 INFO Environment:479 - Hibernate 3.1
13:56:40,434 INFO Environment:509 - hibernate.properties not found
13:56:40,434 INFO Environment:525 - using CGLIB reflection optimizer
13:56:40,434 INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
13:56:40,980 INFO Configuration:1286 - configuring from resource: com/ms/pbcustody/transcapfx/config/sybase_hibernate.cfg.xml
13:56:40,980 INFO Configuration:1263 - Configuration resource: com/ms/pbcustody/transcapfx/config/sybase_hibernate.cfg.xml
13:56:41,699 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath under org/hibernate/
13:56:41,715 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath
13:56:42,074 DEBUG Configuration:1247 - hibernate.dialect=org.hibernate.dialect.SybaseDialect
13:56:42,090 DEBUG Configuration:1247 - connection.url=jdbc:sybase:Tds:paidb274:7464
13:56:42,090 DEBUG Configuration:1247 - connection.username=transcap
13:56:42,090 DEBUG Configuration:1247 - connection.password=Pearljam4$
13:56:42,090 DEBUG Configuration:1247 - hibernate.jdbc.batch_size=30
13:56:42,090 DEBUG Configuration:1247 - hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
13:56:42,090 DEBUG Configuration:1247 - hibernate.cache.use_second_level_cache=true
13:56:42,105 DEBUG Configuration:1247 - hibernate.cache.use_minimal_puts=true
13:56:42,105 DEBUG Configuration:1247 - hibernate.cache.use_structured_entries=true
13:56:42,105 DEBUG Configuration:1247 - hibernate.generate_statistics=true
13:56:42,105 DEBUG Configuration:1247 - hibernate.current_session_context_class=org.hibernate.context.ThreadLocalSessionContext
13:56:42,105 DEBUG Configuration:1247 - hibernate.cache.use_query_cache=true
13:56:42,105 DEBUG Configuration:1247 - show_sql=false
13:56:42,105 DEBUG Configuration:1442 - SybaseSession<-org.dom4j.tree.DefaultAttribute@1cb4cae [Attribute: name resource value "com/ms/pbcustody/transcapfx/model/TCTransaction.hbm.xml"]
13:56:42,105 INFO Configuration:468 - Reading mappings from resource: com/ms/pbcustody/transcapfx/model/TCTransaction.hbm.xml
13:56:42,121 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
13:56:42,137 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
13:56:42,605 INFO HbmBinder:265 - Mapping class: com.ms.pbcustody.transcapfx.model.TCTransaction -> TransCapture_beta..tc_transaction
13:56:42,699 DEBUG HbmBinder:1196 - Mapped property: transactionId -> trans_id
13:56:42,699 DEBUG HbmBinder:1196 - Mapped property: storeTime -> store_time
13:56:42,793 DEBUG HbmBinder:1196 - Mapped property: userId -> user_id
13:56:42,793 DEBUG HbmBinder:1196 - Mapped property: transmissionId -> transmission_id
13:56:42,793 DEBUG HbmBinder:1196 - Mapped property: transactionType -> transaction_type
13:56:42,793 DEBUG HbmBinder:1196 - Mapped property: transactionStatus -> transaction_status
13:56:42,793 DEBUG HbmBinder:1196 - Mapped property: processFlag -> process_flag
13:56:42,809 DEBUG HbmBinder:1196 - Mapped property: authorizationTime -> authorization_time
13:56:42,809 DEBUG HbmBinder:1196 - Mapped property: processingTime -> processing_time
13:56:42,809 DEBUG HbmBinder:1196 - Mapped property: completionTime -> completion_time
13:56:42,824 DEBUG HbmBinder:1196 - Mapped property: loginName -> login_name
13:56:42,824 DEBUG HbmBinder:1196 - Mapped property: origTransId -> orig_trans_id
13:56:42,824 DEBUG HbmBinder:1196 - Mapped property: referenceNo -> reference_no
13:56:42,824 DEBUG HbmBinder:1196 - Mapped property: buClientId -> bu_client_id
13:56:42,824 DEBUG HbmBinder:1196 - Mapped property: lastTransactionStatus -> last_transaction_status
13:56:42,824 DEBUG HbmBinder:1196 - Mapped property: currentFlag -> current_flag
13:56:42,840 DEBUG HbmBinder:1196 - Mapped property: contentType -> content_type
13:56:42,840 DEBUG HbmBinder:1196 - Mapped property: uuid -> uuid
13:56:42,871 DEBUG HbmBinder:1196 - Mapped property: executions
13:56:42,871 DEBUG HbmBinder:1196 - Mapped property: allocations
13:56:43,824 DEBUG HbmBinder:1196 - Mapped property: transmission -> transmission_id
13:56:43,824 DEBUG Configuration:1442 - SybaseSession<-org.dom4j.tree.DefaultAttribute@14d6015 [Attribute: name resource value "com/ms/pbcustody/transcapfx/model/TCTransmission.hbm.xml"]
13:56:43,824 INFO Configuration:468 - Reading mappings from resource: com/ms/pbcustody/transcapfx/model/TCTransmission.hbm.xml
13:56:43,840 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
13:56:43,840 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
13:56:43,934 INFO HbmBinder:265 - Mapping class: com.ms.pbcustody.transcapfx.model.TCTransmission -> TransCapture_beta..tc_transmission
13:56:43,934 DEBUG HbmBinder:1196 - Mapped property: transmissionId -> transmission_id
13:56:43,934 DEBUG HbmBinder:1196 - Mapped property: userId -> user_id
13:56:43,949 DEBUG HbmBinder:1196 - Mapped property: transmissionStatus -> transmission_status
13:56:43,949 DEBUG HbmBinder:1196 - Mapped property: buClientId -> bu_client_id
13:56:43,949 DEBUG HbmBinder:1196 - Mapped property: transmissionMnemonic -> transmission_mnemonic
13:56:43,949 DEBUG HbmBinder:1196 - Mapped property: transmissionTime -> transmission_time
13:56:43,949 DEBUG HbmBinder:1196 - Mapped property: postingTime -> posting_time
13:56:43,949 DEBUG HbmBinder:1196 - Mapped property: transactions
13:56:44,121 DEBUG Configuration:1442 - SybaseSession<-org.dom4j.tree.DefaultAttribute@147788d [Attribute: name resource value "com/ms/pbcustody/transcapfx/model/FXExecution.hbm.xml"]
13:56:44,121 INFO Configuration:468 - Reading mappings from resource: com/ms/pbcustody/transcapfx/model/FXExecution.hbm.xml
13:56:44,121 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
13:56:44,121 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
13:56:44,231 INFO HbmBinder:265 - Mapping class: com.ms.pbcustody.transcapfx.model.FXExecution -> TransCapture_beta..fx_execution
13:56:44,277 DEBUG HbmBinder:1196 - Mapped property: transactionId -> trans_id
13:56:44,293 DEBUG HbmBinder:1196 - Mapped property: seqNo -> seq_no
13:56:44,293 DEBUG HbmBinder:1196 - Mapped property: updateTime -> update_time
13:56:44,293 DEBUG HbmBinder:1196 - Mapped property: recordType -> record_type
13:56:44,293 DEBUG HbmBinder:1196 - Mapped property: transactionType -> transaction_type
13:56:44,293 DEBUG HbmBinder:1196 - Mapped property: transactionLevel -> transaction_level
13:56:44,293 DEBUG HbmBinder:1196 - Mapped property: productType -> product_type
13:56:44,309 DEBUG HbmBinder:1196 - Mapped property: referenceNo -> reference_no
13:56:44,309 DEBUG HbmBinder:1196 - Mapped property: blockId -> block_id
13:56:44,309 DEBUG HbmBinder:1196 - Mapped property: executionAccountNo -> exec_account_no
13:56:44,309 DEBUG HbmBinder:1196 - Mapped property: accountNo -> account_no
13:56:44,324 DEBUG HbmBinder:1196 - Mapped property: executionBroker -> exec_broker
13:56:44,637 DEBUG HbmBinder:1196 - Mapped property: tradeDate -> trade_date
13:56:44,637 DEBUG HbmBinder:1196 - Mapped property: settlementDate -> settlement_date
13:56:44,637 DEBUG HbmBinder:1196 - Mapped property: buyCcy -> buy_ccy
13:56:44,637 DEBUG HbmBinder:1196 - Mapped property: sellCcy -> sell_ccy
13:56:44,652 DEBUG HbmBinder:1196 - Mapped property: buyQuantity -> buy_quantity
13:56:44,652 DEBUG HbmBinder:1196 - Mapped property: sellQuantity -> sell_quantity
13:56:44,652 DEBUG HbmBinder:1196 - Mapped property: fxRate -> fx_rate
13:56:44,652 DEBUG HbmBinder:1196 - Mapped property: clientBaseEquivalent -> client_base_equivalent
13:56:44,652 DEBUG HbmBinder:1196 - Mapped property: hedgeVsSpeculative -> hedge_vs_speculative
13:56:44,652 DEBUG HbmBinder:1196 - Mapped property: hearsayIndicator -> hearsay_ind
13:56:44,668 DEBUG HbmBinder:1196 - Mapped property: taxIndicator -> tax_ind
13:56:44,668 DEBUG HbmBinder:1196 - Mapped property: custodianBroker -> custodian_broker
13:56:44,668 DEBUG HbmBinder:1196 - Mapped property: moneyManager -> money_manager
13:56:44,668 DEBUG HbmBinder:1196 - Mapped property: bookId -> book_id
13:56:44,668 DEBUG HbmBinder:1196 - Mapped property: dealId -> deal_id
13:56:44,668 DEBUG HbmBinder:1196 - Mapped property: exchangeRate -> exch_rate
13:56:44,668 DEBUG HbmBinder:1196 - Mapped property: acquisationDate -> acquisation_date
13:56:44,668 DEBUG HbmBinder:1196 - Mapped property: comments -> comments
13:56:44,684 DEBUG HbmBinder:1196 - Mapped property: linkId -> link_id
13:56:44,684 DEBUG HbmBinder:1196 - Mapped property: Transaction -> trans_id
13:56:44,699 DEBUG Configuration:1442 - SybaseSession<-org.dom4j.tree.DefaultAttribute@85a863 [Attribute: name resource value "com/ms/pbcustody/transcapfx/model/FXAllocation.hbm.xml"]
13:56:44,699 INFO Configuration:468 - Reading mappings from resource: com/ms/pbcustody/transcapfx/model/FXAllocation.hbm.xml
13:56:44,715 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
13:56:44,731 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
13:56:44,809 INFO HbmBinder:265 - Mapping class: com.ms.pbcustody.transcapfx.model.FXAllocation -> TransCapture_beta..fx_allocation
13:56:44,824 DEBUG HbmBinder:1196 - Mapped property: transId -> trans_id
13:56:44,824 DEBUG HbmBinder:1196 - Mapped property: seqNo -> seq_no
13:56:44,824 DEBUG HbmBinder:1196 - Mapped property: updateTime -> update_time
13:56:44,824 DEBUG HbmBinder:1196 - Mapped property: recordType -> record_type
13:56:44,824 DEBUG HbmBinder:1196 - Mapped property: transactionType -> transaction_type
13:56:44,871 DEBUG HbmBinder:1196 - Mapped property: transactionLevel -> transaction_level
13:56:44,887 DEBUG HbmBinder:1196 - Mapped property: productType -> product_type
13:56:44,887 DEBUG HbmBinder:1196 - Mapped property: referenceNo -> reference_no
13:56:44,887 DEBUG HbmBinder:1196 - Mapped property: blockId -> block_id
13:56:44,887 DEBUG HbmBinder:1196 - Mapped property: executionAccountNo -> exec_account_no
13:56:44,887 DEBUG HbmBinder:1196 - Mapped property: accountNo -> account_no
13:56:44,887 DEBUG HbmBinder:1196 - Mapped property: executionBroker -> exec_broker
13:56:44,902 DEBUG HbmBinder:1196 - Mapped property: tradeDate -> trade_date
13:56:44,902 DEBUG HbmBinder:1196 - Mapped property: settlementDate -> settlement_date
13:56:44,902 DEBUG HbmBinder:1196 - Mapped property: buyCcy -> buy_ccy
13:56:44,902 DEBUG HbmBinder:1196 - Mapped property: sellCcy -> sell_ccy
13:56:44,902 DEBUG HbmBinder:1196 - Mapped property: buyQuantity -> buy_quantity
13:56:44,902 DEBUG HbmBinder:1196 - Mapped property: sellQuantity -> sell_quantity
13:56:44,918 DEBUG HbmBinder:1196 - Mapped property: fxRate -> fx_rate
13:56:44,918 DEBUG HbmBinder:1196 - Mapped property: clientBaseEquivalent -> client_base_equivalent
13:56:44,918 DEBUG HbmBinder:1196 - Mapped property: hedgeVsSpeculative -> hedge_vs_speculative
13:56:44,918 DEBUG HbmBinder:1196 - Mapped property: hearsayIndicator -> hearsay_ind
13:56:44,918 DEBUG HbmBinder:1196 - Mapped property: taxIndicator -> tax_ind
13:56:44,918 DEBUG HbmBinder:1196 - Mapped property: custodianBroker -> custodian_broker
13:56:44,918 DEBUG HbmBinder:1196 - Mapped property: moneyManager -> money_manager
13:56:44,965 DEBUG HbmBinder:1196 - Mapped property: bookId -> book_id
13:56:44,965 DEBUG HbmBinder:1196 - Mapped property: dealId -> deal_id
13:56:44,965 DEBUG HbmBinder:1196 - Mapped property: exchangeRate -> exch_rate
13:56:44,965 DEBUG HbmBinder:1196 - Mapped property: acquisationDate -> acquisation_date
13:56:44,965 DEBUG HbmBinder:1196 - Mapped property: comments -> comments
13:56:44,965 DEBUG HbmBinder:1196 - Mapped property: linkId -> link_id
13:56:44,996 DEBUG HbmBinder:1196 - Mapped property: Transaction -> trans_id
13:56:44,996 INFO Configuration:1397 - Configured SessionFactory: SybaseSession
13:56:45,012 DEBUG Configuration:1145 - Preparing to build session factory with filters : {}
13:56:45,012 INFO Configuration:1022 - processing extends queue
13:56:45,027 INFO Configuration:1026 - processing collection mappings
13:56:45,027 DEBUG CollectionSecondPass:33 - Second pass for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.executions
13:56:45,027 INFO HbmBinder:2276 - Mapping collection: com.ms.pbcustody.transcapfx.model.TCTransaction.executions -> TransCapture_beta..fx_execution
13:56:45,043 DEBUG CollectionSecondPass:49 - Mapped collection key: trans_id, one-to-many: com.ms.pbcustody.transcapfx.model.FXExecution
13:56:45,043 DEBUG CollectionSecondPass:33 - Second pass for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations
13:56:45,043 INFO HbmBinder:2276 - Mapping collection: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations -> TransCapture_beta..fx_allocation
13:56:45,043 DEBUG CollectionSecondPass:49 - Mapped collection key: trans_id, one-to-many: com.ms.pbcustody.transcapfx.model.FXAllocation
13:56:45,043 DEBUG CollectionSecondPass:33 - Second pass for collection: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:56:45,043 INFO HbmBinder:2276 - Mapping collection: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions -> TransCapture_beta..tc_transaction
13:56:45,043 DEBUG CollectionSecondPass:49 - Mapped collection key: transmission_id, one-to-many: com.ms.pbcustody.transcapfx.model.TCTransaction
13:56:45,043 INFO Configuration:1035 - processing association property references
13:56:45,043 INFO Configuration:1057 - processing foreign key constraints
13:56:45,043 DEBUG Configuration:1108 - resolving reference to class: com.ms.pbcustody.transcapfx.model.TCTransaction
13:56:45,043 DEBUG Configuration:1108 - resolving reference to class: com.ms.pbcustody.transcapfx.model.TCTransaction
13:56:45,059 DEBUG Configuration:1108 - resolving reference to class: com.ms.pbcustody.transcapfx.model.TCTransmission
13:56:46,778 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:56:46,778 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
13:56:46,778 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
13:56:46,778 WARN DriverManagerConnectionProvider:52 - no JDBC Driver class was specified by property hibernate.connection.driver_class
13:56:46,793 INFO DriverManagerConnectionProvider:80 - using driver: null at URL: jdbc:sybase:Tds:paidb274:7464
13:56:46,793 INFO DriverManagerConnectionProvider:83 - connection properties: {user=transcap, password=Pearljam4$}
13:56:46,793 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
13:56:46,809 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
13:56:46,918 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:sybase:Tds:paidb274:7464, Isolation Level: 2
13:56:52,450 DEBUG SettingsFactory:299 - could not get database version from JDBC metadata
13:56:52,450 INFO SettingsFactory:77 - RDBMS: Adaptive Server Enterprise, version: Adaptive Server Enterprise/12.5.3/EBF 13400 ESD#6 ONE-OFF/P/Linux Intel/Enterprise Linux/ase1253/1947/32-bit/OPT/Mon Mar 6 20:22:17 2006
13:56:52,450 INFO SettingsFactory:78 - JDBC driver: jConnect (TM) for JDBC (TM), version: jConnect (TM) for JDBC(TM)/5.5(Build 25020)/P/JDK12/Tue Jun 19 3:13:19 2001
13:56:52,450 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
13:56:52,575 INFO Dialect:103 - Using dialect: org.hibernate.dialect.SybaseDialect
13:56:52,653 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
13:56:52,684 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
13:56:52,684 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
13:56:52,684 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
13:56:52,684 INFO SettingsFactory:136 - JDBC batch size: 30
13:56:52,684 INFO SettingsFactory:139 - JDBC batch updates for versioned data: disabled
13:56:52,700 INFO SettingsFactory:144 - Scrollable result sets: enabled
13:56:52,700 DEBUG SettingsFactory:148 - Wrap result sets: disabled
13:56:52,700 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
13:56:52,700 INFO SettingsFactory:160 - Connection release mode: auto
13:56:52,731 INFO SettingsFactory:187 - Default batch fetch size: 1
13:56:52,731 INFO SettingsFactory:191 - Generate SQL with comments: disabled
13:56:52,809 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
13:56:52,809 INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
13:56:52,825 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
13:56:52,840 INFO SettingsFactory:203 - Query language substitutions: {}
13:56:52,840 INFO SettingsFactory:209 - Second-level cache: enabled
13:56:52,840 INFO SettingsFactory:213 - Query cache: enabled
13:56:52,840 INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.EhCacheProvider
13:56:52,903 INFO SettingsFactory:228 - Optimize cache for minimal puts: enabled
13:56:52,903 INFO SettingsFactory:237 - Structured second-level cache entries: enabled
13:56:52,903 INFO SettingsFactory:312 - Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
13:56:52,934 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
13:56:52,965 INFO SettingsFactory:264 - Statistics: enabled
13:56:52,965 INFO SettingsFactory:268 - Deleted entity synthetic identifier rollback: disabled
13:56:52,965 INFO SettingsFactory:283 - Default entity-mode: pojo
13:56:53,169 INFO SessionFactoryImpl:153 - building session factory
13:56:53,169 DEBUG SessionFactoryImpl:164 - Session factory constructed with filter configurations : {}
13:56:53,184 DEBUG SessionFactoryImpl:167 - instantiating session factory with properties: {java.vendor=Sun Microsystems Inc., show_sql=false, META_PROJECT=clienttech, hibernate.connection.url=jdbc:sybase:Tds:paidb274:7464, sun.management.compiler=HotSpot Client Compiler, hibernate.cache.use_structured_entries=true, ENRICHMENT_POOL_SIZE=1, PROJECT=fileimport, os.name=Windows XP, sun.boot.class.path=C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\lib\rt.jar;C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\lib\i18n.jar;C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\lib\sunrsasign.jar;C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\lib\jsse.jar;C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\lib\jce.jar;C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\lib\charsets.jar;C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\classes, hibernate.current_session_context_class=org.hibernate.context.ThreadLocalSessionContext, sun.desktop=windows, java.vm.specification.vendor=Sun Microsystems Inc., hibernate.generate_statistics=true, java.runtime.version=1.5.0_04-b05, hibernate.cache.use_minimal_puts=true, hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider, user.name=test, FILEIMPORT_POOL_SIZE=1, hibernate.session_factory_name=SybaseSession, user.language=en, FI_ERROR_QUEUE=MQDEV.test.TRAINING.ERROR2, sun.boot.library.path=C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\bin, java.version=1.5.0_04, user.timezone=America/New_York, ADMIN_PORT=:13030, sun.arch.data.model=32, java.endorsed.dirs=C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\lib\endorsed, sun.cpu.isalist=, sun.jnu.encoding=Cp1252, file.encoding.pkg=sun.io, TMD_POOL_SIZE=1, file.separator=\, java.specification.name=Java Platform API Specification, hibernate.cglib.use_reflection_optimizer=true, java.class.version=49.0, user.country=US, connection.url=jdbc:sybase:Tds:paidb274:7464, java.home=C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre, java.vm.info=mixed mode, TMD_INPUT_HTTP_PORT=:13196, os.version=5.1, LOG_CONFIG_FILE=etc/mslog_config.xml, path.separator=;, connection.password=Pearljam4$, java.vm.version=1.5.0_04-b05, hibernate.connection.password=Pearljam4$, user.variant=, UI_INPUT_HTTP_PORT=:13193, hibernate.jdbc.batch_size=30, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, hibernate.connection.username=transcap, ENRICHMENT_INPUT_HTTP_PORT=:13195, UI_POOL_SIZE=1, user.home=C:\Documents and Settings\test, java.specification.vendor=Sun Microsystems Inc., DB_STORE_BATCH_SIZE=100, java.library.path=\\ms\dist\msjava\PROJ\tools_jni\2.0\exec\lib;\\ms\dist\msjava\PROJ\msnet_jni\4.0\exec\lib;P:\dist\mq\mqparts\1.0\exits;C:\WINDOWS\system32;C:\Program%20Files\NEONSystems\ShadowDirect\Lib32, java.vendor.url=http://java.sun.com/, connection.username=transcap, java.vm.vendor=Sun Microsystems Inc., hibernate.dialect=org.hibernate.dialect.SybaseDialect, FI_ERROR_QUEUE_MANAGER=NYT1, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=C:\dev\pbcustody\transcapfx\trunk\src\build;\\ms\dist\appmw\PROJ\jxb\1.0\common\lib\appmw_jxb_broker-g.jar;\\ms\dist\msjava\PROJ\tiaf\2.1\common\lib\msjava_tiaf-g.jar;\\ms\dist\msjava\PROJ\tools\2.0\common\lib\msjava_tools-g.jar;\\ms\dist\msjava\PROJ\jdbcext\2.0\common\lib\msjava_jdbcext-g.jar;\\ms\dist\msjava\PROJ\mslog\2.0\common\lib\msjava_mslog_log-g.jar;\\ms\dist\msjava\PROJ\mslog\2.0\common\lib\msjava_mslog_netcool-g.jar;\\ms\dist\msjava\PROJ\mslog\2.0\common\lib\msjava_mslog_jdk_logging-g.jar;\\ms\dist\msjava\PROJ\mqtk\2.0\common\lib\msjava_mqtk_mqi-g.jar;\\ms\dist\msjava\PROJ\msnet\4.0\common\lib\msjava_msnet-g.jar;\\ms\dist\msjava\PROJ\msnet\4.0\common\lib\msjava_msnet_nio-g.jar;\\ms\dist\msjava\PROJ\soaptk\4.0\common\lib\msjava_soaptk-g.jar;\\ms\dist\appmw\PROJ\camjava\2.1\common\lib\appmw_camjava-g.jar;\\ms\dist\msjava\PROJ\hdom\3.3\common\lib\msjava_hdom-g.jar;\\ms\dist\msjava\PROJ\oswego\1.3\common\lib\msjava_oswego.jar;\\ms\dist\msjava\PROJ\getopt\1.0\common\lib\msjava_getopt.jar;\\ms\dist\msjava\PROJ\jconnect\6.0.2\common\lib\jTDS3.jar;\\ms\dist\msjava\PROJ\jconnect\6.0.2\common\lib\jconn3.jar;\\ms\dev\clienttech\fileimport\trunk\install\common\fileimport\lib\FileImport.jar;\\ms\dist\mspa1\PROJ\security\1.2\common\lib\entitlements_client.jar;\\ms\dist\appmw\PROJ\cpsjava\1.2\common\lib\appmw_cpsjava_light-g.jar;\\ms\dist\appmw\PROJ\cpsjava\1.2\common\lib\appmw_cpsjava-g.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\ant-1.6.5.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\ant-antlr-1.6.5.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\ant-junit-1.6.5.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\ant-launcher-1.6.5.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\ant-swing-1.6.5.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\antlr-2.7.6rc1.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\asm-attrs.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\asm.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\c3p0-0.9.0.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\cglib-2.1.3.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\cleanimports.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\commons-collections-2.1.1.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\commons-logging-1.0.4.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\concurrent-1.3.2.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\connector.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\dom4j-1.6.1.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\ehcache-1.1.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jaas.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jacc-1_0-fr.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jaxen-1.1-beta-7.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jboss-cache.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jboss-common.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jboss-jmx.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jboss-system.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jdbc2_0-stdext.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jgroups-2.2.7.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\jta.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\junit-3.8.1.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\log4j-1.2.11.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\oscache-2.1.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\proxool-0.8.3.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\swarmcache-1.0rc2.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\syndiag2.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\versioncheck.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\xerces-2.6.2.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\xml-apis.jar;\\ms\dist\msjava\PROJ\eval\hibernate-3.1\common\lib\hibernate3.jar;C:\dev\clienttech\transcap\trunk\src\build\jc\classes;\\ms\dist\msjava\PROJ\mslog\1.4\lib\msjava_mslog_log-g.jar;\\ms\dist\msjava\PROJ\mslog\1.4\lib\msjava_mslog_netcool-g.jar;\\ms\dist\msjava\PROJ\mslog\1.4\lib\msjava_mslog_jdk_logging-g.jar;\\ms\dist\msjava\PROJ\mslog\1.4\lib\msjava_mslog_test-g.jar;\\ms\dist\msjava\PROJ\oswego\1.3\lib\msjava_oswego.jar;\\ms\dist\msjava\PROJ\tomcat\4.1.24\tomcat4\common\lib\servlet.jar;\\ms\dist\msjava\PROJ\oreilly\2.1\lib\msjava_oreilly.jar;\\ms\dist\msjava\PROJ\jconnect\5.5\classes\jconn2.jar;\\ms\dist\msjava\PROJ\oro\2.0\lib\msjava_oro.jar;\\ms\dist\appmw\PROJ\jxb\1.0\lib\appmw_jxb_broker-g.jar;\\ms\dist\clienttech\PROJ\climon\0.9\common\climon\lib\clienttech_climon.jar;\\ms\dist\mspa1\PROJ\pricing\0.6.4\lib\mspa1_pricing.jar;\\ms\dist\msjava\PROJ\collections\3.1\lib\msjava_collections.jar;\\ms\dist\msjava\PROJ\junit\3.8.1\lib\msjava_junit.jar;\\ms\dist\msjava\PROJ\tiaf\2.1\lib\msjava_tiaf-g.jar;\\ms\dist\mspa1\PROJ\security\1.2\lib\entitlements_client.jar;\\ms\dist\msjava\PROJ\hdom\3.2\lib\msjava_hdom-g.jar;\\ms\dist\msjava\PROJ\msnet\4.1\lib\msjava_msnet.jar;\\ms\dist\msjava\PROJ\msnet\4.1\lib\msjava_msnet_nio.jar;\\ms\dist\msjava\PROJ\soaptk\4.0\lib\msjava_soaptk-g.jar;\\ms\dist\msjava\PROJ\camtk\2.1\lib\msjava_camtk-g.jar;\\ms\dist\msjava\PROJ\tools\2.0\lib\msjava_tools-g.jar;\\ms\dist\msjava\PROJ\tools\2.0\lib\msjava_tools_jni-g.jar;\\ms\dist\msjava\PROJ\tools\2.0\lib\msjava_tools_nojni-g.jar;\\ms\dist\msjava\PROJ\toolsdb\2.0\lib\msjava_toolsdb-g.jar;\\ms\dist\msjava\PROJ\toolsdb\2.0\lib\msjava_toolsdb_jdbc3-g.jar;\\ms\dist\clienttech\PROJ\queryadapter\0.9.6\lib\clienttech_queryadapter-g.jar;\\ms\dist\clienttech\PROJ\dataservice\0.7\lib\clienttech_dataservice.jar;\\ms\dev\clienttech\fileimport\trunk\install\common\fileimport\lib\FileImport.jar;\\ms\dist\clienttech\PROJ\products\3.1.1\common\lib\products_client.jar;\\ms\dist\msjava\PROJ\javamail\1.3.1\lib\msjava_mail.jar;\\ms\dist\msjava\PROJ\javamail\1.3.1\lib\msjava_imap.jar;\\ms\dist\msjava\PROJ\javamail\1.3.1\lib\msjava_mailapi.jar;\\ms\dist\msjava\PROJ\javamail\1.3.1\lib\msjava_pop3.jar;\\ms\dist\msjava\PROJ\javamail\1.3.1\lib\msjava_smtp.jar;\\ms\dist\msjava\PROJ\jaf\1.0.2\lib\msjava_jaf.jar;\\ms\dist\clienttech\PROJ\genericquery\1.8.2\lib\jakarta-poi-1.10.0-dev-20030222.jar;\\ms\dist\clienttech\PROJ\genericquery\1.8.2\lib\genericquery-g.jar;\\ms\dist\fast\PROJ\dps2_domain\1.3.0\lib\fast_dps2_domain-g.jar;\\ms\dist\fast\PROJ\dps2_domain\1.3.0\lib\fast_dps2_domain_flows-g.jar;C:\dev\clienttech\transcap\trunk\src\lib\commons-lang-2.1.jar;C:\dev\clienttech\transcapjxb\trunk\src\bin;\\ms\dist\msjava\PROJ\toolsdb\2.0\common\lib\msjava_toolsdb-g.jar;\\ms\dist\msjava\PROJ\toolsdb\2.0\common\lib\msjava_toolsdb_jdbc3-g.jar;\\ms\dist\msjava\PROJ\camtk\2.0\common\lib\msjava_camtk-g.jar;\\ms\dist\msjava\PROJ\xerces\2.5\common\lib\msjava_xerces.jar;\\ms\dist\msjava\PROJ\xerces\2.5\common\lib\msjava_xml-apis.jar;\\ms\dist\msjava\PROJ\jconnect\5.5.4\common\lib\msjava_jconnect.jar;\\ms\dist\msjava\PROJ\xalan\2.6.0\common\lib\msjava_xalan.jar;\\ms\dist\msjava\PROJ\hdom\3.2\common\lib\msjava_hdom-g.jar;\\ms\dist\msjava\PROJ\tools\2.0\common\lib\msjava_tools-g.jar;\\ms\dist\msjava\PROJ\tools\2.0\common\lib\msjava_tools_jni-g.jar;\\ms\dist\msjava\PROJ\tools\2.0\common\lib\msjava_tools_nojni-g.jar;\\ms\dist\clienttech\PROJ\genericquery\1.8.2\lib\genericquery.jar;\\ms\dev\clienttech\products\1.5\install\common\products\lib\products_client.jar;\\ms\dev\msjava\mslog\2.0\install\common\lib\msjava_mslog_log-g.jar;\\ms\dev\msjava\mslog\2.0\install\common\lib\msjava_mslog_netcool-g.jar;\\ms\dev\msjava\mslog\2.0\install\common\lib\msjava_mslog_jdk_logging-g.jar;\\ms\dist\msjava\PROJ\msnet\4.0\common\lib\msjava_msnet.jar;\\ms\dist\msjava\PROJ\msnet\4.0\common\lib\msjava_msnet_test.jar;\\ms\dist\msjava\PROJ\msnet\4.0\common\lib\msjava_msnet_nio.jar;\\ms\dist\clienttech\PROJ\transcap\0.2\transcap\lib\FSM.jar;\\ms\dist\3rd\PROJ\MQSeries\windows-prod\Java\lib\com.ibm.mq.jar;\\ms\dist\3rd\PROJ\MQSeries\windows-prod\Java\lib\connector.jar;\\ms\dist\3rd\PROJ\MQSeries\windows-prod\Java\lib\jta.jar;\\ms\dist\mq\PROJ\jcore\2.0\lib\mq_jcore.jar;C:\dev\clienttech\transcap\trunk\src\build\jc\classes;\\ms\dist\clienttech\PROJ\queryadapter\0.9.6\common\lib\clienttech_queryadapter-g.jar;\\ms\dist\msjava\PROJ\xmlutil\1.0\common\lib\msjava_xmlutil-g.jar;\\ms\dist\msjava\PROJ\base\1.1\common\lib\msjava_base-g.jar;\\ms\dist\msjava\PROJ\struts\1.2.9\common\lib\commons-beanutils.jar;C:\dev\pbcustody\transcapfx\trunk\src\lib\beanlib-3.2.1.jar;C:\dev\pbcustody\transcapfx\trunk\src\lib\beanlib-hibernate-3.2.1.jar;\\ms\dist\clienttech\PROJ\products\3.4\common\lib\products_client.jar;\\ms\dev\msjava\hibernateutils\1.0\install\common\lib\msjava_hibernateutils.jar;c:\dev\clienttech\fileimport\trunk\src\classes;c:\dev\clienttech\fileimport\trunk\src\lib\utils.jar;c:\dev\clienttech\fileimport\trunk\src\lib\xlrd.jar;C:\Program Files\AFSMirror\EclipseIDE\3.1\eclipse\plugins\org.junit_3.8.1\junit.jar;\\ms\dist\msjava\PROJ\oreilly\2.1\common\lib\msjava_oreilly.jar;\\ms\dist\msjava\PROJ\javamail\1.3\common\lib\msjava_mail.jar;\\ms\dist\msjava\PROJ\javamail\1.3\common\lib\msjava_pop3.jar;\\ms\dist\msjava\PROJ\javamail\1.3\common\lib\msjava_smtp.jar;\\ms\dist\msjava\PROJ\javamail\1.3\common\lib\msjava_imap.jar;\\ms\dist\msjava\PROJ\javamail\1.3\common\lib\msjava_mailapi.jar;\\ms\dist\msjava\PROJ\oro\2.0\common\lib\jakarta-oro-2.0.jar;\\ms\dist\msjava\PROJ\oro\2.0\common\lib\msjava_oro.jar;\\ms\dist\msjava\PROJ\tomcat\3.2.1\common\lib\ant.jar;\\ms\dist\msjava\PROJ\tomcat\3.2.1\common\lib\jaxp.jar;\\ms\dist\msjava\PROJ\tomcat\3.2.1\common\lib\servlet.jar;\\ms\dist\msjava\PROJ\tomcat\3.2.1\common\lib\parser.jar;\\ms\dist\msjava\PROJ\tomcat\3.2.1\common\lib\webserver.jar;\\ms\dist\msjava\PROJ\tomcat\3.2.1\common\lib\jasper.jar;\\ms\dist\msjava\PROJ\jaf\1.0.2\common\lib\msjava_jaf.jar;\\ms\dist\msjava\PROJ\jconnect\5.5\common\lib\jconn2.jar;\\ms\dist\msjava\PROJ\jconnect\5.5\common\lib\msjava_jconnect.jar;\\ms\dist\msjava\PROJ\xalan\2.0\common\lib\msjava_xalan.jar;\\ms\dist\msjava\PROJ\xerces\2.6\common\lib\msjava_xerces.jar;\\ms\dist\msjava\PROJ\xerces\2.6\common\lib\msjava_xml-apis.jar;\\ms\dist\clienttech\PROJ\climon\1.0\climon\lib\clienttech_climon.jar;\\ms\dist\clienttech\PROJ\dataservice\0.7\common\lib\clienttech_dataservice.jar;\\ms\dist\clienttech\PROJ\dataservice\0.7\common\lib\clienttech_dataservice_jxbFlows.jar;\\ms\dist\msjava\PROJ\mqtk\2.0\common\lib\msjava_mqtk_mqi.jar;\\ms\dist\msjava\PROJ\collections\3.1\commons-collections-3.1.jar;\\ms\dist\clienttech\PROJ\transcap\0.4\common\transcap\lib\Transcap.jar, java.vm.specification.name=Java Virtual Machine Specification, PROPERTY_FILE=C:\dev\pbcustody\transcapfx\trunk\src\config\transcap.DEV.props, FILEIMPORT_INPUT_HTTP_PORT=:13197, java.vm.specification.version=1.0, sun.os.patch.level=Service Pack 2, sun.cpu.endian=little, hibernate.cache.use_query_cache=true, java.io.tmpdir=C:\DOCUME~1\test\LOCALS~1\Temp\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, os.arch=x86, RELEASE=trunk, java.ext.dirs=C:\Program Files\AFSMirror\sunjdk\1.5.0_04\jre\lib\ext, user.dir=C:\dev\pbcustody\transcapfx\trunk\src, line.separator=
, java.vm.name=Java HotSpot(TM) Client VM, hibernate.cache.use_second_level_cache=true, file.encoding=Cp1252, VALIDATION_POOL_SIZE=1, java.specification.version=1.5, VALIDATION_INPUT_HTTP_PORT=:13194, USER=test, hibernate.show_sql=false}
13:56:54,278 DEBUG CacheFactory:39 - instantiating cache region: com.ms.pbcustody.transcapfx.model.TCTransaction usage strategy: read-write
13:56:54,372 WARN EhCacheProvider:103 - Could not find configuration [com.ms.pbcustody.transcapfx.model.TCTransaction]; using defaults.
13:56:54,387 DEBUG EhCacheProvider:106 - started EHCache region: com.ms.pbcustody.transcapfx.model.TCTransaction
13:56:56,325 DEBUG ReflectHelper:220 - reflection optimizer disabled for: com.ms.pbcustody.transcapfx.model.TCTransaction, BulkBeanException: null (property setTransmission)
13:56:56,450 DEBUG AbstractEntityPersister:2447 - Static SQL for entity: com.ms.pbcustody.transcapfx.model.TCTransaction
13:56:56,450 DEBUG AbstractEntityPersister:2449 - Version select: select store_time from TransCapture_beta..tc_transaction where trans_id =?
13:56:56,450 DEBUG AbstractEntityPersister:2450 - Snapshot select: select tctransact_.trans_id, tctransact_.store_time as store2_0_, tctransact_.user_id as user3_0_, tctransact_.transmission_id as transmis4_0_, tctransact_.transaction_type as transact5_0_, tctransact_.transaction_status as transact6_0_, tctransact_.process_flag as process7_0_, tctransact_.authorization_time as authoriz8_0_, tctransact_.processing_time as processing9_0_, tctransact_.completion_time as completion10_0_, tctransact_.login_name as login11_0_, tctransact_.orig_trans_id as orig12_0_, tctransact_.reference_no as reference13_0_, tctransact_.bu_client_id as bu14_0_, tctransact_.last_transaction_status as last15_0_, tctransact_.current_flag as current16_0_, tctransact_.content_type as content17_0_, tctransact_.uuid as uuid0_ from TransCapture_beta..tc_transaction tctransact_ where tctransact_.trans_id=?
13:56:56,466 DEBUG AbstractEntityPersister:2452 - Insert 0: insert into TransCapture_beta..tc_transaction (store_time, user_id, transmission_id, transaction_type, transaction_status, process_flag, authorization_time, processing_time, completion_time, login_name, orig_trans_id, reference_no, bu_client_id, last_transaction_status, current_flag, content_type, uuid, trans_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
13:56:56,466 DEBUG AbstractEntityPersister:2453 - Update 0: update TransCapture_beta..tc_transaction set store_time=?, user_id=?, transmission_id=?, transaction_type=?, transaction_status=?, process_flag=?, authorization_time=?, processing_time=?, completion_time=?, login_name=?, orig_trans_id=?, reference_no=?, bu_client_id=?, last_transaction_status=?, current_flag=?, content_type=?, uuid=? where trans_id=? and store_time=?
13:56:56,466 DEBUG AbstractEntityPersister:2454 - Delete 0: delete from TransCapture_beta..tc_transaction where trans_id=? and store_time=?
13:56:56,466 DEBUG CacheFactory:39 - instantiating cache region: com.ms.pbcustody.transcapfx.model.FXAllocation usage strategy: read-write
13:56:56,466 WARN EhCacheProvider:103 - Could not find configuration [com.ms.pbcustody.transcapfx.model.FXAllocation]; using defaults.
13:56:56,481 DEBUG EhCacheProvider:106 - started EHCache region: com.ms.pbcustody.transcapfx.model.FXAllocation
13:56:56,637 DEBUG ReflectHelper:220 - reflection optimizer disabled for: com.ms.pbcustody.transcapfx.model.FXAllocation, BulkBeanException: null (property setTransaction)
13:56:56,997 DEBUG AbstractEntityPersister:2447 - Static SQL for entity: com.ms.pbcustody.transcapfx.model.FXAllocation
13:56:56,997 DEBUG AbstractEntityPersister:2449 - Version select: select update_time from TransCapture_beta..fx_allocation where trans_id =? and seq_no =?
13:56:56,997 DEBUG AbstractEntityPersister:2450 - Snapshot select: select fxallocati_.trans_id, fxallocati_.seq_no, fxallocati_.update_time as update3_3_, fxallocati_.record_type as record4_3_, fxallocati_.transaction_type as transact5_3_, fxallocati_.transaction_level as transact6_3_, fxallocati_.product_type as product7_3_, fxallocati_.reference_no as reference8_3_, fxallocati_.block_id as block9_3_, fxallocati_.exec_account_no as exec10_3_, fxallocati_.account_no as account11_3_, fxallocati_.exec_broker as exec12_3_, fxallocati_.trade_date as trade13_3_, fxallocati_.settlement_date as settlement14_3_, fxallocati_.buy_ccy as buy15_3_, fxallocati_.sell_ccy as sell16_3_, fxallocati_.buy_quantity as buy17_3_, fxallocati_.sell_quantity as sell18_3_, fxallocati_.fx_rate as fx19_3_, fxallocati_.client_base_equivalent as client20_3_, fxallocati_.hedge_vs_speculative as hedge21_3_, fxallocati_.hearsay_ind as hearsay22_3_, fxallocati_.tax_ind as tax23_3_, fxallocati_.custodian_broker as custodian24_3_, fxallocati_.money_manager as money25_3_, fxallocati_.book_id as book26_3_, fxallocati_.deal_id as deal27_3_, fxallocati_.exch_rate as exch28_3_, fxallocati_.acquisation_date as acquisa29_3_, fxallocati_.comments as comments3_, fxallocati_.link_id as link31_3_ from TransCapture_beta..fx_allocation fxallocati_ where fxallocati_.trans_id=? and fxallocati_.seq_no=?
13:56:57,012 DEBUG AbstractEntityPersister:2452 - Insert 0: insert into TransCapture_beta..fx_allocation (update_time, record_type, transaction_type, transaction_level, product_type, reference_no, block_id, exec_account_no, account_no, exec_broker, trade_date, settlement_date, buy_ccy, sell_ccy, buy_quantity, sell_quantity, fx_rate, client_base_equivalent, hedge_vs_speculative, hearsay_ind, tax_ind, custodian_broker, money_manager, book_id, deal_id, exch_rate, acquisation_date, comments, link_id, trans_id, seq_no) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
13:56:57,012 DEBUG AbstractEntityPersister:2453 - Update 0: update TransCapture_beta..fx_allocation set update_time=?, record_type=?, transaction_type=?, transaction_level=?, product_type=?, reference_no=?, block_id=?, exec_account_no=?, account_no=?, exec_broker=?, trade_date=?, settlement_date=?, buy_ccy=?, sell_ccy=?, buy_quantity=?, sell_quantity=?, fx_rate=?, client_base_equivalent=?, hedge_vs_speculative=?, hearsay_ind=?, tax_ind=?, custodian_broker=?, money_manager=?, book_id=?, deal_id=?, exch_rate=?, acquisation_date=?, comments=?, link_id=? where trans_id=? and seq_no=? and update_time=?
13:56:57,012 DEBUG AbstractEntityPersister:2454 - Delete 0: delete from TransCapture_beta..fx_allocation where trans_id=? and seq_no=? and update_time=?
13:56:57,012 DEBUG CacheFactory:39 - instantiating cache region: com.ms.pbcustody.transcapfx.model.TCTransmission usage strategy: read-write
13:56:57,028 WARN EhCacheProvider:103 - Could not find configuration [com.ms.pbcustody.transcapfx.model.TCTransmission]; using defaults.
13:56:57,028 DEBUG EhCacheProvider:106 - started EHCache region: com.ms.pbcustody.transcapfx.model.TCTransmission
13:56:57,278 DEBUG AbstractEntityPersister:2447 - Static SQL for entity: com.ms.pbcustody.transcapfx.model.TCTransmission
13:56:57,278 DEBUG AbstractEntityPersister:2449 - Version select: select transmission_id from TransCapture_beta..tc_transmission where transmission_id =?
13:56:57,294 DEBUG AbstractEntityPersister:2450 - Snapshot select: select tctransmis_.transmission_id, tctransmis_.user_id as user2_1_, tctransmis_.transmission_status as transmis3_1_, tctransmis_.bu_client_id as bu4_1_, tctransmis_.transmission_mnemonic as transmis5_1_, tctransmis_.transmission_time as transmis6_1_, tctransmis_.posting_time as posting7_1_ from TransCapture_beta..tc_transmission tctransmis_ where tctransmis_.transmission_id=?
13:56:57,294 DEBUG AbstractEntityPersister:2452 - Insert 0: insert into TransCapture_beta..tc_transmission (user_id, transmission_status, bu_client_id, transmission_mnemonic, transmission_time, posting_time, transmission_id) values (?, ?, ?, ?, ?, ?, ?)
13:56:57,309 DEBUG AbstractEntityPersister:2453 - Update 0: update TransCapture_beta..tc_transmission set user_id=?, transmission_status=?, bu_client_id=?, transmission_mnemonic=?, transmission_time=?, posting_time=? where transmission_id=?
13:56:57,309 DEBUG AbstractEntityPersister:2454 - Delete 0: delete from TransCapture_beta..tc_transmission where transmission_id=?
13:56:57,309 DEBUG CacheFactory:39 - instantiating cache region: com.ms.pbcustody.transcapfx.model.FXExecution usage strategy: read-write
13:56:57,309 WARN EhCacheProvider:103 - Could not find configuration [com.ms.pbcustody.transcapfx.model.FXExecution]; using defaults.
13:56:57,325 DEBUG EhCacheProvider:106 - started EHCache region: com.ms.pbcustody.transcapfx.model.FXExecution
13:56:57,497 DEBUG ReflectHelper:220 - reflection optimizer disabled for: com.ms.pbcustody.transcapfx.model.FXExecution, BulkBeanException: null (property setTransaction)
13:56:57,544 DEBUG AbstractEntityPersister:2447 - Static SQL for entity: com.ms.pbcustody.transcapfx.model.FXExecution
13:56:57,544 DEBUG AbstractEntityPersister:2449 - Version select: select update_time from TransCapture_beta..fx_execution where trans_id =? and seq_no =?
13:56:57,544 DEBUG AbstractEntityPersister:2450 - Snapshot select: select fxexecutio_.trans_id, fxexecutio_.seq_no, fxexecutio_.update_time as update3_2_, fxexecutio_.record_type as record4_2_, fxexecutio_.transaction_type as transact5_2_, fxexecutio_.transaction_level as transact6_2_, fxexecutio_.product_type as product7_2_, fxexecutio_.reference_no as reference8_2_, fxexecutio_.block_id as block9_2_, fxexecutio_.exec_account_no as exec10_2_, fxexecutio_.account_no as account11_2_, fxexecutio_.exec_broker as exec12_2_, fxexecutio_.trade_date as trade13_2_, fxexecutio_.settlement_date as settlement14_2_, fxexecutio_.buy_ccy as buy15_2_, fxexecutio_.sell_ccy as sell16_2_, fxexecutio_.buy_quantity as buy17_2_, fxexecutio_.sell_quantity as sell18_2_, fxexecutio_.fx_rate as fx19_2_, fxexecutio_.client_base_equivalent as client20_2_, fxexecutio_.hedge_vs_speculative as hedge21_2_, fxexecutio_.hearsay_ind as hearsay22_2_, fxexecutio_.tax_ind as tax23_2_, fxexecutio_.custodian_broker as custodian24_2_, fxexecutio_.money_manager as money25_2_, fxexecutio_.book_id as book26_2_, fxexecutio_.deal_id as deal27_2_, fxexecutio_.exch_rate as exch28_2_, fxexecutio_.acquisation_date as acquisa29_2_, fxexecutio_.comments as comments2_, fxexecutio_.link_id as link31_2_ from TransCapture_beta..fx_execution fxexecutio_ where fxexecutio_.trans_id=? and fxexecutio_.seq_no=?
13:56:57,559 DEBUG AbstractEntityPersister:2452 - Insert 0: insert into TransCapture_beta..fx_execution (update_time, record_type, transaction_type, transaction_level, product_type, reference_no, block_id, exec_account_no, account_no, exec_broker, trade_date, settlement_date, buy_ccy, sell_ccy, buy_quantity, sell_quantity, fx_rate, client_base_equivalent, hedge_vs_speculative, hearsay_ind, tax_ind, custodian_broker, money_manager, book_id, deal_id, exch_rate, acquisation_date, comments, link_id, trans_id, seq_no) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
13:56:57,559 DEBUG AbstractEntityPersister:2453 - Update 0: update TransCapture_beta..fx_execution set update_time=?, record_type=?, transaction_type=?, transaction_level=?, product_type=?, reference_no=?, block_id=?, exec_account_no=?, account_no=?, exec_broker=?, trade_date=?, settlement_date=?, buy_ccy=?, sell_ccy=?, buy_quantity=?, sell_quantity=?, fx_rate=?, client_base_equivalent=?, hedge_vs_speculative=?, hearsay_ind=?, tax_ind=?, custodian_broker=?, money_manager=?, book_id=?, deal_id=?, exch_rate=?, acquisation_date=?, comments=?, link_id=? where trans_id=? and seq_no=? and update_time=?
13:56:57,575 DEBUG AbstractEntityPersister:2454 - Delete 0: delete from TransCapture_beta..fx_execution where trans_id=? and seq_no=? and update_time=?
13:56:57,575 DEBUG CacheFactory:39 - instantiating cache region: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions usage strategy: read-write
13:56:57,575 WARN EhCacheProvider:103 - Could not find configuration [com.ms.pbcustody.transcapfx.model.TCTransmission.transactions]; using defaults.
13:56:57,684 DEBUG EhCacheProvider:106 - started EHCache region: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:56:57,763 DEBUG AbstractCollectionPersister:511 - Static SQL for collection: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:56:57,763 DEBUG AbstractCollectionPersister:512 - Row insert: update TransCapture_beta..tc_transaction set transmission_id=? where trans_id=?
13:56:57,763 DEBUG AbstractCollectionPersister:514 - Row delete: update TransCapture_beta..tc_transaction set transmission_id=null where transmission_id=? and trans_id=?
13:56:57,763 DEBUG AbstractCollectionPersister:515 - One-shot delete: update TransCapture_beta..tc_transaction set transmission_id=null where transmission_id=?
13:56:57,778 DEBUG CacheFactory:39 - instantiating cache region: com.ms.pbcustody.transcapfx.model.TCTransaction.executions usage strategy: read-write
13:56:57,778 WARN EhCacheProvider:103 - Could not find configuration [com.ms.pbcustody.transcapfx.model.TCTransaction.executions]; using defaults.
13:56:57,794 DEBUG EhCacheProvider:106 - started EHCache region: com.ms.pbcustody.transcapfx.model.TCTransaction.executions
13:56:57,794 DEBUG AbstractCollectionPersister:511 - Static SQL for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.executions
13:56:57,841 DEBUG AbstractCollectionPersister:512 - Row insert: update TransCapture_beta..fx_execution set trans_id=? where trans_id=? and seq_no=?
13:56:57,856 DEBUG AbstractCollectionPersister:514 - Row delete: update TransCapture_beta..fx_execution set trans_id=null where trans_id=? and trans_id=? and seq_no=?
13:56:57,856 DEBUG AbstractCollectionPersister:515 - One-shot delete: update TransCapture_beta..fx_execution set trans_id=null where trans_id=?
13:56:57,856 DEBUG CacheFactory:39 - instantiating cache region: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations usage strategy: read-write
13:56:58,013 WARN EhCacheProvider:103 - Could not find configuration [com.ms.pbcustody.transcapfx.model.TCTransaction.allocations]; using defaults.
13:56:58,013 DEBUG EhCacheProvider:106 - started EHCache region: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations
13:56:58,028 DEBUG AbstractCollectionPersister:511 - Static SQL for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations
13:56:58,028 DEBUG AbstractCollectionPersister:512 - Row insert: update TransCapture_beta..fx_allocation set trans_id=? where trans_id=? and seq_no=?
13:56:58,075 DEBUG AbstractCollectionPersister:514 - Row delete: update TransCapture_beta..fx_allocation set trans_id=null where trans_id=? and trans_id=? and seq_no=?
13:56:58,075 DEBUG AbstractCollectionPersister:515 - One-shot delete: update TransCapture_beta..fx_allocation set trans_id=null where trans_id=?
13:56:58,278 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.TCTransaction: select tctransact0_.trans_id as trans1_0_1_, tctransact0_.store_time as store2_0_1_, tctransact0_.user_id as user3_0_1_, tctransact0_.transmission_id as transmis4_0_1_, tctransact0_.transaction_type as transact5_0_1_, tctransact0_.transaction_status as transact6_0_1_, tctransact0_.process_flag as process7_0_1_, tctransact0_.authorization_time as authoriz8_0_1_, tctransact0_.processing_time as processing9_0_1_, tctransact0_.completion_time as completion10_0_1_, tctransact0_.login_name as login11_0_1_, tctransact0_.orig_trans_id as orig12_0_1_, tctransact0_.reference_no as reference13_0_1_, tctransact0_.bu_client_id as bu14_0_1_, tctransact0_.last_transaction_status as last15_0_1_, tctransact0_.current_flag as current16_0_1_, tctransact0_.content_type as content17_0_1_, tctransact0_.uuid as uuid0_1_, tctransmis1_.transmission_id as transmis1_1_0_, tctransmis1_.user_id as user2_1_0_, tctransmis1_.transmission_status as transmis3_1_0_, tctransmis1_.bu_client_id as bu4_1_0_, tctransmis1_.transmission_mnemonic as transmis5_1_0_, tctransmis1_.transmission_time as transmis6_1_0_, tctransmis1_.posting_time as posting7_1_0_ from TransCapture_beta..tc_transaction tctransact0_ inner join TransCapture_beta..tc_transmission tctransmis1_ on tctransact0_.transmission_id=tctransmis1_.transmission_id where tctransact0_.trans_id=?
13:56:58,294 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.TCTransaction: select tctransact0_.trans_id as trans1_0_1_, tctransact0_.store_time as store2_0_1_, tctransact0_.user_id as user3_0_1_, tctransact0_.transmission_id as transmis4_0_1_, tctransact0_.transaction_type as transact5_0_1_, tctransact0_.transaction_status as transact6_0_1_, tctransact0_.process_flag as process7_0_1_, tctransact0_.authorization_time as authoriz8_0_1_, tctransact0_.processing_time as processing9_0_1_, tctransact0_.completion_time as completion10_0_1_, tctransact0_.login_name as login11_0_1_, tctransact0_.orig_trans_id as orig12_0_1_, tctransact0_.reference_no as reference13_0_1_, tctransact0_.bu_client_id as bu14_0_1_, tctransact0_.last_transaction_status as last15_0_1_, tctransact0_.current_flag as current16_0_1_, tctransact0_.content_type as content17_0_1_, tctransact0_.uuid as uuid0_1_, tctransmis1_.transmission_id as transmis1_1_0_, tctransmis1_.user_id as user2_1_0_, tctransmis1_.transmission_status as transmis3_1_0_, tctransmis1_.bu_client_id as bu4_1_0_, tctransmis1_.transmission_mnemonic as transmis5_1_0_, tctransmis1_.transmission_time as transmis6_1_0_, tctransmis1_.posting_time as posting7_1_0_ from TransCapture_beta..tc_transaction tctransact0_ inner join TransCapture_beta..tc_transmission tctransmis1_ on tctransact0_.transmission_id=tctransmis1_.transmission_id where tctransact0_.trans_id=?
13:56:58,294 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.TCTransaction: select tctransact0_.trans_id as trans1_0_0_, tctransact0_.store_time as store2_0_0_, tctransact0_.user_id as user3_0_0_, tctransact0_.transmission_id as transmis4_0_0_, tctransact0_.transaction_type as transact5_0_0_, tctransact0_.transaction_status as transact6_0_0_, tctransact0_.process_flag as process7_0_0_, tctransact0_.authorization_time as authoriz8_0_0_, tctransact0_.processing_time as processing9_0_0_, tctransact0_.completion_time as completion10_0_0_, tctransact0_.login_name as login11_0_0_, tctransact0_.orig_trans_id as orig12_0_0_, tctransact0_.reference_no as reference13_0_0_, tctransact0_.bu_client_id as bu14_0_0_, tctransact0_.last_transaction_status as last15_0_0_, tctransact0_.current_flag as current16_0_0_, tctransact0_.content_type as content17_0_0_, tctransact0_.uuid as uuid0_0_ from TransCapture_beta..tc_transaction tctransact0_ where tctransact0_.trans_id=?
13:56:58,294 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.TCTransaction: select tctransact0_.trans_id as trans1_0_0_, tctransact0_.store_time as store2_0_0_, tctransact0_.user_id as user3_0_0_, tctransact0_.transmission_id as transmis4_0_0_, tctransact0_.transaction_type as transact5_0_0_, tctransact0_.transaction_status as transact6_0_0_, tctransact0_.process_flag as process7_0_0_, tctransact0_.authorization_time as authoriz8_0_0_, tctransact0_.processing_time as processing9_0_0_, tctransact0_.completion_time as completion10_0_0_, tctransact0_.login_name as login11_0_0_, tctransact0_.orig_trans_id as orig12_0_0_, tctransact0_.reference_no as reference13_0_0_, tctransact0_.bu_client_id as bu14_0_0_, tctransact0_.last_transaction_status as last15_0_0_, tctransact0_.current_flag as current16_0_0_, tctransact0_.content_type as content17_0_0_, tctransact0_.uuid as uuid0_0_ from TransCapture_beta..tc_transaction tctransact0_ where tctransact0_.trans_id=?
13:56:58,403 DEBUG EntityLoader:67 - Static select for action ACTION_MERGE on entity com.ms.pbcustody.transcapfx.model.TCTransaction: select tctransact0_.trans_id as trans1_0_2_, tctransact0_.store_time as store2_0_2_, tctransact0_.user_id as user3_0_2_, tctransact0_.transmission_id as transmis4_0_2_, tctransact0_.transaction_type as transact5_0_2_, tctransact0_.transaction_status as transact6_0_2_, tctransact0_.process_flag as process7_0_2_, tctransact0_.authorization_time as authoriz8_0_2_, tctransact0_.processing_time as processing9_0_2_, tctransact0_.completion_time as completion10_0_2_, tctransact0_.login_name as login11_0_2_, tctransact0_.orig_trans_id as orig12_0_2_, tctransact0_.reference_no as reference13_0_2_, tctransact0_.bu_client_id as bu14_0_2_, tctransact0_.last_transaction_status as last15_0_2_, tctransact0_.current_flag as current16_0_2_, tctransact0_.content_type as content17_0_2_, tctransact0_.uuid as uuid0_2_, executions1_.trans_id as trans1_4_, executions1_.seq_no as seq2_4_, executions1_.trans_id as trans1_2_0_, executions1_.seq_no as seq2_2_0_, executions1_.update_time as update3_2_0_, executions1_.record_type as record4_2_0_, executions1_.transaction_type as transact5_2_0_, executions1_.transaction_level as transact6_2_0_, executions1_.product_type as product7_2_0_, executions1_.reference_no as reference8_2_0_, executions1_.block_id as block9_2_0_, executions1_.exec_account_no as exec10_2_0_, executions1_.account_no as account11_2_0_, executions1_.exec_broker as exec12_2_0_, executions1_.trade_date as trade13_2_0_, executions1_.settlement_date as settlement14_2_0_, executions1_.buy_ccy as buy15_2_0_, executions1_.sell_ccy as sell16_2_0_, executions1_.buy_quantity as buy17_2_0_, executions1_.sell_quantity as sell18_2_0_, executions1_.fx_rate as fx19_2_0_, executions1_.client_base_equivalent as client20_2_0_, executions1_.hedge_vs_speculative as hedge21_2_0_, executions1_.hearsay_ind as hearsay22_2_0_, executions1_.tax_ind as tax23_2_0_, executions1_.custodian_broker as custodian24_2_0_, executions1_.money_manager as money25_2_0_, executions1_.book_id as book26_2_0_, executions1_.deal_id as deal27_2_0_, executions1_.exch_rate as exch28_2_0_, executions1_.acquisation_date as acquisa29_2_0_, executions1_.comments as comments2_0_, executions1_.link_id as link31_2_0_, allocation2_.trans_id as trans1_5_, allocation2_.seq_no as seq2_5_, allocation2_.trans_id as trans1_3_1_, allocation2_.seq_no as seq2_3_1_, allocation2_.update_time as update3_3_1_, allocation2_.record_type as record4_3_1_, allocation2_.transaction_type as transact5_3_1_, allocation2_.transaction_level as transact6_3_1_, allocation2_.product_type as product7_3_1_, allocation2_.reference_no as reference8_3_1_, allocation2_.block_id as block9_3_1_, allocation2_.exec_account_no as exec10_3_1_, allocation2_.account_no as account11_3_1_, allocation2_.exec_broker as exec12_3_1_, allocation2_.trade_date as trade13_3_1_, allocation2_.settlement_date as settlement14_3_1_, allocation2_.buy_ccy as buy15_3_1_, allocation2_.sell_ccy as sell16_3_1_, allocation2_.buy_quantity as buy17_3_1_, allocation2_.sell_quantity as sell18_3_1_, allocation2_.fx_rate as fx19_3_1_, allocation2_.client_base_equivalent as client20_3_1_, allocation2_.hedge_vs_speculative as hedge21_3_1_, allocation2_.hearsay_ind as hearsay22_3_1_, allocation2_.tax_ind as tax23_3_1_, allocation2_.custodian_broker as custodian24_3_1_, allocation2_.money_manager as money25_3_1_, allocation2_.book_id as book26_3_1_, allocation2_.deal_id as deal27_3_1_, allocation2_.exch_rate as exch28_3_1_, allocation2_.acquisation_date as acquisa29_3_1_, allocation2_.comments as comments3_1_, allocation2_.link_id as link31_3_1_ from TransCapture_beta..tc_transaction tctransact0_ left outer join TransCapture_beta..fx_execution executions1_ on tctransact0_.trans_id=executions1_.trans_id left outer join TransCapture_beta..fx_allocation allocation2_ on tctransact0_.trans_id=allocation2_.trans_id where tctransact0_.trans_id=?
13:56:58,434 DEBUG EntityLoader:67 - Static select for action ACTION_REFRESH on entity com.ms.pbcustody.transcapfx.model.TCTransaction: select tctransact0_.trans_id as trans1_0_2_, tctransact0_.store_time as store2_0_2_, tctransact0_.user_id as user3_0_2_, tctransact0_.transmission_id as transmis4_0_2_, tctransact0_.transaction_type as transact5_0_2_, tctransact0_.transaction_status as transact6_0_2_, tctransact0_.process_flag as process7_0_2_, tctransact0_.authorization_time as authoriz8_0_2_, tctransact0_.processing_time as processing9_0_2_, tctransact0_.completion_time as completion10_0_2_, tctransact0_.login_name as login11_0_2_, tctransact0_.orig_trans_id as orig12_0_2_, tctransact0_.reference_no as reference13_0_2_, tctransact0_.bu_client_id as bu14_0_2_, tctransact0_.last_transaction_status as last15_0_2_, tctransact0_.current_flag as current16_0_2_, tctransact0_.content_type as content17_0_2_, tctransact0_.uuid as uuid0_2_, executions1_.trans_id as trans1_4_, executions1_.seq_no as seq2_4_, executions1_.trans_id as trans1_2_0_, executions1_.seq_no as seq2_2_0_, executions1_.update_time as update3_2_0_, executions1_.record_type as record4_2_0_, executions1_.transaction_type as transact5_2_0_, executions1_.transaction_level as transact6_2_0_, executions1_.product_type as product7_2_0_, executions1_.reference_no as reference8_2_0_, executions1_.block_id as block9_2_0_, executions1_.exec_account_no as exec10_2_0_, executions1_.account_no as account11_2_0_, executions1_.exec_broker as exec12_2_0_, executions1_.trade_date as trade13_2_0_, executions1_.settlement_date as settlement14_2_0_, executions1_.buy_ccy as buy15_2_0_, executions1_.sell_ccy as sell16_2_0_, executions1_.buy_quantity as buy17_2_0_, executions1_.sell_quantity as sell18_2_0_, executions1_.fx_rate as fx19_2_0_, executions1_.client_base_equivalent as client20_2_0_, executions1_.hedge_vs_speculative as hedge21_2_0_, executions1_.hearsay_ind as hearsay22_2_0_, executions1_.tax_ind as tax23_2_0_, executions1_.custodian_broker as custodian24_2_0_, executions1_.money_manager as money25_2_0_, executions1_.book_id as book26_2_0_, executions1_.deal_id as deal27_2_0_, executions1_.exch_rate as exch28_2_0_, executions1_.acquisation_date as acquisa29_2_0_, executions1_.comments as comments2_0_, executions1_.link_id as link31_2_0_, allocation2_.trans_id as trans1_5_, allocation2_.seq_no as seq2_5_, allocation2_.trans_id as trans1_3_1_, allocation2_.seq_no as seq2_3_1_, allocation2_.update_time as update3_3_1_, allocation2_.record_type as record4_3_1_, allocation2_.transaction_type as transact5_3_1_, allocation2_.transaction_level as transact6_3_1_, allocation2_.product_type as product7_3_1_, allocation2_.reference_no as reference8_3_1_, allocation2_.block_id as block9_3_1_, allocation2_.exec_account_no as exec10_3_1_, allocation2_.account_no as account11_3_1_, allocation2_.exec_broker as exec12_3_1_, allocation2_.trade_date as trade13_3_1_, allocation2_.settlement_date as settlement14_3_1_, allocation2_.buy_ccy as buy15_3_1_, allocation2_.sell_ccy as sell16_3_1_, allocation2_.buy_quantity as buy17_3_1_, allocation2_.sell_quantity as sell18_3_1_, allocation2_.fx_rate as fx19_3_1_, allocation2_.client_base_equivalent as client20_3_1_, allocation2_.hedge_vs_speculative as hedge21_3_1_, allocation2_.hearsay_ind as hearsay22_3_1_, allocation2_.tax_ind as tax23_3_1_, allocation2_.custodian_broker as custodian24_3_1_, allocation2_.money_manager as money25_3_1_, allocation2_.book_id as book26_3_1_, allocation2_.deal_id as deal27_3_1_, allocation2_.exch_rate as exch28_3_1_, allocation2_.acquisation_date as acquisa29_3_1_, allocation2_.comments as comments3_1_, allocation2_.link_id as link31_3_1_ from TransCapture_beta..tc_transaction tctransact0_ left outer join TransCapture_beta..fx_execution executions1_ on tctransact0_.trans_id=executions1_.trans_id left outer join TransCapture_beta..fx_allocation allocation2_ on tctransact0_.trans_id=allocation2_.trans_id where tctransact0_.trans_id=?
13:56:58,450 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.TCTransmission: select tctransmis0_.transmission_id as transmis1_1_1_, tctransmis0_.user_id as user2_1_1_, tctransmis0_.transmission_status as transmis3_1_1_, tctransmis0_.bu_client_id as bu4_1_1_, tctransmis0_.transmission_mnemonic as transmis5_1_1_, tctransmis0_.transmission_time as transmis6_1_1_, tctransmis0_.posting_time as posting7_1_1_, transactio1_.transmission_id as transmis4_3_, transactio1_.trans_id as trans1_3_, transactio1_.trans_id as trans1_0_0_, transactio1_.store_time as store2_0_0_, transactio1_.user_id as user3_0_0_, transactio1_.transmission_id as transmis4_0_0_, transactio1_.transaction_type as transact5_0_0_, transactio1_.transaction_status as transact6_0_0_, transactio1_.process_flag as process7_0_0_, transactio1_.authorization_time as authoriz8_0_0_, transactio1_.processing_time as processing9_0_0_, transactio1_.completion_time as completion10_0_0_, transactio1_.login_name as login11_0_0_, transactio1_.orig_trans_id as orig12_0_0_, transactio1_.reference_no as reference13_0_0_, transactio1_.bu_client_id as bu14_0_0_, transactio1_.last_transaction_status as last15_0_0_, transactio1_.current_flag as current16_0_0_, transactio1_.content_type as content17_0_0_, transactio1_.uuid as uuid0_0_ from TransCapture_beta..tc_transmission tctransmis0_ left outer join TransCapture_beta..tc_transaction transactio1_ on tctransmis0_.transmission_id=transactio1_.transmission_id where tctransmis0_.transmission_id=?
13:56:58,450 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.TCTransmission: select tctransmis0_.transmission_id as transmis1_1_1_, tctransmis0_.user_id as user2_1_1_, tctransmis0_.transmission_status as transmis3_1_1_, tctransmis0_.bu_client_id as bu4_1_1_, tctransmis0_.transmission_mnemonic as transmis5_1_1_, tctransmis0_.transmission_time as transmis6_1_1_, tctransmis0_.posting_time as posting7_1_1_, transactio1_.transmission_id as transmis4_3_, transactio1_.trans_id as trans1_3_, transactio1_.trans_id as trans1_0_0_, transactio1_.store_time as store2_0_0_, transactio1_.user_id as user3_0_0_, transactio1_.transmission_id as transmis4_0_0_, transactio1_.transaction_type as transact5_0_0_, transactio1_.transaction_status as transact6_0_0_, transactio1_.process_flag as process7_0_0_, transactio1_.authorization_time as authoriz8_0_0_, transactio1_.processing_time as processing9_0_0_, transactio1_.completion_time as completion10_0_0_, transactio1_.login_name as login11_0_0_, transactio1_.orig_trans_id as orig12_0_0_, transactio1_.reference_no as reference13_0_0_, transactio1_.bu_client_id as bu14_0_0_, transactio1_.last_transaction_status as last15_0_0_, transactio1_.current_flag as current16_0_0_, transactio1_.content_type as content17_0_0_, transactio1_.uuid as uuid0_0_ from TransCapture_beta..tc_transmission tctransmis0_ left outer join TransCapture_beta..tc_transaction transactio1_ on tctransmis0_.transmission_id=transactio1_.transmission_id where tctransmis0_.transmission_id=?
13:56:58,450 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.TCTransmission: select tctransmis0_.transmission_id as transmis1_1_0_, tctransmis0_.user_id as user2_1_0_, tctransmis0_.transmission_status as transmis3_1_0_, tctransmis0_.bu_client_id as bu4_1_0_, tctransmis0_.transmission_mnemonic as transmis5_1_0_, tctransmis0_.transmission_time as transmis6_1_0_, tctransmis0_.posting_time as posting7_1_0_ from TransCapture_beta..tc_transmission tctransmis0_ where tctransmis0_.transmission_id=?
13:56:58,466 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.TCTransmission: select tctransmis0_.transmission_id as transmis1_1_0_, tctransmis0_.user_id as user2_1_0_, tctransmis0_.transmission_status as transmis3_1_0_, tctransmis0_.bu_client_id as bu4_1_0_, tctransmis0_.transmission_mnemonic as transmis5_1_0_, tctransmis0_.transmission_time as transmis6_1_0_, tctransmis0_.posting_time as posting7_1_0_ from TransCapture_beta..tc_transmission tctransmis0_ where tctransmis0_.transmission_id=?
13:56:58,481 DEBUG EntityLoader:67 - Static select for action ACTION_MERGE on entity com.ms.pbcustody.transcapfx.model.TCTransmission: select tc

13:56:58,481 DEBUG EntityLoader:67 - Static select for action ACTION_REFRESH on entity com.ms.pbcustody.transcapfx.model.TCTransmission: select tctransmis0_.transmission_id as transmis1_1_2_, tctransmis0_.user_id as user2_1_2_, tctransmis0_.transmission_status as transmis3_1_2_, tctransmis0_.bu_client_id as bu4_1_2_, tctransmis0_.transmission_mnemonic as transmis5_1_2_, tctransmis0_.transmission_time as transmis6_1_2_, tctransmis0_.posting_time as posting7_1_2_, transactio1_.transmission_id as transmis4_4_, transactio1_.trans_id as trans1_4_, transactio1_.trans_id as trans1_0_0_, transactio1_.store_time as store2_0_0_, transactio1_.user_id as user3_0_0_, transactio1_.transmission_id as transmis4_0_0_, transactio1_.transaction_type as transact5_0_0_, transactio1_.transaction_status as transact6_0_0_, transactio1_.process_flag as process7_0_0_, transactio1_.authorization_time as authoriz8_0_0_, transactio1_.processing_time as processing9_0_0_, transactio1_.completion_time as completion10_0_0_, transactio1_.login_name as login11_0_0_, transactio1_.orig_trans_id as orig12_0_0_, transactio1_.reference_no as reference13_0_0_, transactio1_.bu_client_id as bu14_0_0_, transactio1_.last_transaction_status as last15_0_0_, transactio1_.current_flag as current16_0_0_, transactio1_.content_type as content17_0_0_, transactio1_.uuid as uuid0_0_, executions2_.trans_id as trans1_5_, executions2_.seq_no as seq2_5_, executions2_.trans_id as trans1_2_1_, executions2_.seq_no as seq2_2_1_, executions2_.update_time as update3_2_1_, executions2_.record_type as record4_2_1_, executions2_.transaction_type as transact5_2_1_, executions2_.transaction_level as transact6_2_1_, executions2_.product_type as product7_2_1_, executions2_.reference_no as reference8_2_1_, executions2_.block_id as block9_2_1_, executions2_.exec_account_no as exec10_2_1_, executions2_.account_no as account11_2_1_, executions2_.exec_broker as exec12_2_1_, executions2_.trade_date as trade13_2_1_, executions2_.settlement_date as settlement14_2_1_, executions2_.buy_ccy as buy15_2_1_, executions2_.sell_ccy as sell16_2_1_, executions2_.buy_quantity as buy17_2_1_, executions2_.sell_quantity as sell18_2_1_, executions2_.fx_rate as fx19_2_1_, executions2_.client_base_equivalent as client20_2_1_, executions2_.hedge_vs_speculative as hedge21_2_1_, executions2_.hearsay_ind as hearsay22_2_1_, executions2_.tax_ind as tax23_2_1_, executions2_.custodian_broker as custodian24_2_1_, executions2_.money_manager as money25_2_1_, executions2_.book_id as book26_2_1_, executions2_.deal_id as deal27_2_1_, executions2_.exch_rate as exch28_2_1_, executions2_.acquisation_date as acquisa29_2_1_, executions2_.comments as comments2_1_, executions2_.link_id as link31_2_1_ from TransCapture_beta..tc_transmission tctransmis0_ left outer join TransCapture_beta..tc_transaction transactio1_ on tctransmis0_.transmission_id=transactio1_.transmission_id left outer join TransCapture_beta..fx_execution executions2_ on transactio1_.trans_id=executions2_.trans_id where tctransmis0_.transmission_id=?
13:56:58,497 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.FXAllocation: select fxallocati0_.trans_id as trans1_3_2_, fxallocati0_.seq_no as seq2_3_2_, fxallocati0_.update_time as update3_3_2_, fxallocati0_.record_type as record4_3_2_, fxallocati0_.transaction_type as transact5_3_2_, fxallocati0_.transaction_level as transact6_3_2_, fxallocati0_.product_type as product7_3_2_, fxallocati0_.reference_no as reference8_3_2_, fxallocati0_.block_id as block9_3_2_, fxallocati0_.exec_account_no as exec10_3_2_, fxallocati0_.account_no as account11_3_2_, fxallocati0_.exec_broker as exec12_3_2_, fxallocati0_.trade_date as trade13_3_2_, fxallocati0_.settlement_date as settlement14_3_2_, fxallocati0_.buy_ccy as buy15_3_2_, fxallocati0_.sell_ccy as sell16_3_2_, fxallocati0_.buy_quantity as buy17_3_2_, fxallocati0_.sell_quantity as sell18_3_2_, fxallocati0_.fx_rate as fx19_3_2_, fxallocati0_.client_base_equivalent as client20_3_2_, fxallocati0_.hedge_vs_speculative as hedge21_3_2_, fxallocati0_.hearsay_ind as hearsay22_3_2_, fxallocati0_.tax_ind as tax23_3_2_, fxallocati0_.custodian_broker as custodian24_3_2_, fxallocati0_.money_manager as money25_3_2_, fxallocati0_.book_id as book26_3_2_, fxallocati0_.deal_id as deal27_3_2_, fxallocati0_.exch_rate as exch28_3_2_, fxallocati0_.acquisation_date as acquisa29_3_2_, fxallocati0_.comments as comments3_2_, fxallocati0_.link_id as link31_3_2_, tctransact1_.trans_id as trans1_0_0_, tctransact1_.store_time as store2_0_0_, tctransact1_.user_id as user3_0_0_, tctransact1_.transmission_id as transmis4_0_0_, tctransact1_.transaction_type as transact5_0_0_, tctransact1_.transaction_status as transact6_0_0_, tctransact1_.process_flag as process7_0_0_, tctransact1_.authorization_time as authoriz8_0_0_, tctransact1_.processing_time as processing9_0_0_, tctransact1_.completion_time as completion10_0_0_, tctransact1_.login_name as login11_0_0_, tctransact1_.orig_trans_id as orig12_0_0_, tctransact1_.reference_no as reference13_0_0_, tctransact1_.bu_client_id as bu14_0_0_, tctransact1_.last_transaction_status as last15_0_0_, tctransact1_.current_flag as current16_0_0_, tctransact1_.content_type as content17_0_0_, tctransact1_.uuid as uuid0_0_, tctransmis2_.transmission_id as transmis1_1_1_, tctransmis2_.user_id as user2_1_1_, tctransmis2_.transmission_status as transmis3_1_1_, tctransmis2_.bu_client_id as bu4_1_1_, tctransmis2_.transmission_mnemonic as transmis5_1_1_, tctransmis2_.transmission_time as transmis6_1_1_, tctransmis2_.posting_time as posting7_1_1_ from TransCapture_beta..fx_allocation fxallocati0_ inner join TransCapture_beta..tc_transaction tctransact1_ on fxallocati0_.trans_id=tctransact1_.trans_id left outer join TransCapture_beta..tc_transmission tctransmis2_ on tctransact1_.transmission_id=tctransmis2_.transmission_id where fxallocati0_.trans_id=? and fxallocati0_.seq_no=?
13:56:58,622 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.FXAllocation: select fxallocati0_.trans_id as trans1_3_2_, fxallocati0_.seq_no as seq2_3_2_, fxallocati0_.update_time as update3_3_2_, fxallocati0_.record_type as record4_3_2_, fxallocati0_.transaction_type as transact5_3_2_, fxallocati0_.transaction_level as transact6_3_2_, fxallocati0_.product_type as product7_3_2_, fxallocati0_.reference_no as reference8_3_2_, fxallocati0_.block_id as block9_3_2_, fxallocati0_.exec_account_no as exec10_3_2_, fxallocati0_.account_no as account11_3_2_, fxallocati0_.exec_broker as exec12_3_2_, fxallocati0_.trade_date as trade13_3_2_, fxallocati0_.settlement_date as settlement14_3_2_, fxallocati0_.buy_ccy as buy15_3_2_, fxallocati0_.sell_ccy as sell16_3_2_, fxallocati0_.buy_quantity as buy17_3_2_, fxallocati0_.sell_quantity as sell18_3_2_, fxallocati0_.fx_rate as fx19_3_2_, fxallocati0_.client_base_equivalent as client20_3_2_, fxallocati0_.hedge_vs_speculative as hedge21_3_2_, fxallocati0_.hearsay_ind as hearsay22_3_2_, fxallocati0_.tax_ind as tax23_3_2_, fxallocati0_.custodian_broker as custodian24_3_2_, fxallocati0_.money_manager as money25_3_2_, fxallocati0_.book_id as book26_3_2_, fxallocati0_.deal_id as deal27_3_2_, fxallocati0_.exch_rate as exch28_3_2_, fxallocati0_.acquisation_date as acquisa29_3_2_, fxallocati0_.comments as comments3_2_, fxallocati0_.link_id as link31_3_2_, tctransact1_.trans_id as trans1_0_0_, tctransact1_.store_time as store2_0_0_, tctransact1_.user_id as user3_0_0_, tctransact1_.transmission_id as transmis4_0_0_, tctransact1_.transaction_type as transact5_0_0_, tctransact1_.transaction_status as transact6_0_0_, tctransact1_.process_flag as process7_0_0_, tctransact1_.authorization_time as authoriz8_0_0_, tctransact1_.processing_time as processing9_0_0_, tctransact1_.completion_time as completion10_0_0_, tctransact1_.login_name as login11_0_0_, tctransact1_.orig_trans_id as orig12_0_0_, tctransact1_.reference_no as reference13_0_0_, tctransact1_.bu_client_id as bu14_0_0_, tctransact1_.last_transaction_status as last15_0_0_, tctransact1_.current_flag as current16_0_0_, tctransact1_.content_type as content17_0_0_, tctransact1_.uuid as uuid0_0_, tctransmis2_.transmission_id as transmis1_1_1_, tctransmis2_.user_id as user2_1_1_, tctransmis2_.transmission_status as transmis3_1_1_, tctransmis2_.bu_client_id as bu4_1_1_, tctransmis2_.transmission_mnemonic as transmis5_1_1_, tctransmis2_.transmission_time as transmis6_1_1_, tctransmis2_.posting_time as posting7_1_1_ from TransCapture_beta..fx_allocation fxallocati0_ inner join TransCapture_beta..tc_transaction tctransact1_ on fxallocati0_.trans_id=tctransact1_.trans_id left outer join TransCapture_beta..tc_transmission tctransmis2_ on tctransact1_.transmission_id=tctransmis2_.transmission_id where fxallocati0_.trans_id=? and fxallocati0_.seq_no=?
13:56:58,653 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.FXAllocation: select fxallocati0_.trans_id as trans1_3_0_, fxallocati0_.seq_no as seq2_3_0_, fxallocati0_.update_time as update3_3_0_, fxallocati0_.record_type as record4_3_0_, fxallocati0_.transaction_type as transact5_3_0_, fxallocati0_.transaction_level as transact6_3_0_, fxallocati0_.product_type as product7_3_0_, fxallocati0_.reference_no as reference8_3_0_, fxallocati0_.block_id as block9_3_0_, fxallocati0_.exec_account_no as exec10_3_0_, fxallocati0_.account_no as account11_3_0_, fxallocati0_.exec_broker as exec12_3_0_, fxallocati0_.trade_date as trade13_3_0_, fxallocati0_.settlement_date as settlement14_3_0_, fxallocati0_.buy_ccy as buy15_3_0_, fxallocati0_.sell_ccy as sell16_3_0_, fxallocati0_.buy_quantity as buy17_3_0_, fxallocati0_.sell_quantity as sell18_3_0_, fxallocati0_.fx_rate as fx19_3_0_, fxallocati0_.client_base_equivalent as client20_3_0_, fxallocati0_.hedge_vs_speculative as hedge21_3_0_, fxallocati0_.hearsay_ind as hearsay22_3_0_, fxallocati0_.tax_ind as tax23_3_0_, fxallocati0_.custodian_broker as custodian24_3_0_, fxallocati0_.money_manager as money25_3_0_, fxallocati0_.book_id as book26_3_0_, fxallocati0_.deal_id as deal27_3_0_, fxallocati0_.exch_rate as exch28_3_0_, fxallocati0_.acquisation_date as acquisa29_3_0_, fxallocati0_.comments as comments3_0_, fxallocati0_.link_id as link31_3_0_ from TransCapture_beta..fx_allocation fxallocati0_ where fxallocati0_.trans_id=? and fxallocati0_.seq_no=?
13:56:58,653 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.FXAllocation: select fxallocati0_.trans_id as trans1_3_0_, fxallocati0_.seq_no as seq2_3_0_, fxallocati0_.update_time as update3_3_0_, fxallocati0_.record_type as record4_3_0_, fxallocati0_.transaction_type as transact5_3_0_, fxallocati0_.transaction_level as transact6_3_0_, fxallocati0_.product_type as product7_3_0_, fxallocati0_.reference_no as reference8_3_0_, fxallocati0_.block_id as block9_3_0_, fxallocati0_.exec_account_no as exec10_3_0_, fxallocati0_.account_no as account11_3_0_, fxallocati0_.exec_broker as exec12_3_0_, fxallocati0_.trade_date as trade13_3_0_, fxallocati0_.settlement_date as settlement14_3_0_, fxallocati0_.buy_ccy as buy15_3_0_, fxallocati0_.sell_ccy as sell16_3_0_, fxallocati0_.buy_quantity as buy17_3_0_, fxallocati0_.sell_quantity as sell18_3_0_, fxallocati0_.fx_rate as fx19_3_0_, fxallocati0_.client_base_equivalent as client20_3_0_, fxallocati0_.hedge_vs_speculative as hedge21_3_0_, fxallocati0_.hearsay_ind as hearsay22_3_0_, fxallocati0_.tax_ind as tax23_3_0_, fxallocati0_.custodian_broker as custodian24_3_0_, fxallocati0_.money_manager as money25_3_0_, fxallocati0_.book_id as book26_3_0_, fxallocati0_.deal_id as deal27_3_0_, fxallocati0_.exch_rate as exch28_3_0_, fxallocati0_.acquisation_date as acquisa29_3_0_, fxallocati0_.comments as comments3_0_, fxallocati0_.link_id as link31_3_0_ from TransCapture_beta..fx_allocation fxallocati0_ where fxallocati0_.trans_id=? and fxallocati0_.seq_no=?
13:56:58,653 DEBUG EntityLoader:67 - Static select for action ACTION_MERGE on entity com.ms.pbcustody.transcapfx.model.FXAllocation: select fxallocati0_.trans_id as trans1_3_0_, fxallocati0_.seq_no as seq2_3_0_, fxallocati0_.update_time as update3_3_0_, fxallocati0_.record_type as record4_3_0_, fxallocati0_.transaction_type as transact5_3_0_, fxallocati0_.transaction_level as transact6_3_0_, fxallocati0_.product_type as product7_3_0_, fxallocati0_.reference_no as reference8_3_0_, fxallocati0_.block_id as block9_3_0_, fxallocati0_.exec_account_no as exec10_3_0_, fxallocati0_.account_no as account11_3_0_, fxallocati0_.exec_broker as exec12_3_0_, fxallocati0_.trade_date as trade13_3_0_, fxallocati0_.settlement_date as settlement14_3_0_, fxallocati0_.buy_ccy as buy15_3_0_, fxallocati0_.sell_ccy as sell16_3_0_, fxallocati0_.buy_quantity as buy17_3_0_, fxallocati0_.sell_quantity as sell18_3_0_, fxallocati0_.fx_rate as fx19_3_0_, fxallocati0_.client_base_equivalent as client20_3_0_, fxallocati0_.hedge_vs_speculative as hedge21_3_0_, fxallocati0_.hearsay_ind as hearsay22_3_0_, fxallocati0_.tax_ind as tax23_3_0_, fxallocati0_.custodian_broker as custodian24_3_0_, fxallocati0_.money_manager as money25_3_0_, fxallocati0_.book_id as book26_3_0_, fxallocati0_.deal_id as deal27_3_0_, fxallocati0_.exch_rate as exch28_3_0_, fxallocati0_.acquisation_date as acquisa29_3_0_, fxallocati0_.comments as comments3_0_, fxallocati0_.link_id as link31_3_0_ from TransCapture_beta..fx_allocation fxallocati0_ where fxallocati0_.trans_id=? and fxallocati0_.seq_no=?
13:56:58,669 DEBUG EntityLoader:67 - Static select for action ACTION_REFRESH on entity com.ms.pbcustody.transcapfx.model.FXAllocation: select fxallocati0_.trans_id as trans1_3_0_, fxallocati0_.seq_no as seq2_3_0_, fxallocati0_.update_time as update3_3_0_, fxallocati0_.record_type as record4_3_0_, fxallocati0_.transaction_type as transact5_3_0_, fxallocati0_.transaction_level as transact6_3_0_, fxallocati0_.product_type as product7_3_0_, fxallocati0_.reference_no as reference8_3_0_, fxallocati0_.block_id as block9_3_0_, fxallocati0_.exec_account_no as exec10_3_0_, fxallocati0_.account_no as account11_3_0_, fxallocati0_.exec_broker as exec12_3_0_, fxallocati0_.trade_date as trade13_3_0_, fxallocati0_.settlement_date as settlement14_3_0_, fxallocati0_.buy_ccy as buy15_3_0_, fxallocati0_.sell_ccy as sell16_3_0_, fxallocati0_.buy_quantity as buy17_3_0_, fxallocati0_.sell_quantity as sell18_3_0_, fxallocati0_.fx_rate as fx19_3_0_, fxallocati0_.client_base_equivalent as client20_3_0_, fxallocati0_.hedge_vs_speculative as hedge21_3_0_, fxallocati0_.hearsay_ind as hearsay22_3_0_, fxallocati0_.tax_ind as tax23_3_0_, fxallocati0_.custodian_broker as custodian24_3_0_, fxallocati0_.money_manager as money25_3_0_, fxallocati0_.book_id as book26_3_0_, fxallocati0_.deal_id as deal27_3_0_, fxallocati0_.exch_rate as exch28_3_0_, fxallocati0_.acquisation_date as acquisa29_3_0_, fxallocati0_.comments as comments3_0_, fxallocati0_.link_id as link31_3_0_ from TransCapture_beta..fx_allocation fxallocati0_ where fxallocati0_.trans_id=? and fxallocati0_.seq_no=?
13:56:58,684 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.FXExecution: select fxexecutio0_.trans_id as trans1_2_2_, fxexecutio0_.seq_no as seq2_2_2_, fxexecutio0_.update_time as update3_2_2_, fxexecutio0_.record_type as record4_2_2_, fxexecutio0_.transaction_type as transact5_2_2_, fxexecutio0_.transaction_level as transact6_2_2_, fxexecutio0_.product_type as product7_2_2_, fxexecutio0_.reference_no as reference8_2_2_, fxexecutio0_.block_id as block9_2_2_, fxexecutio0_.exec_account_no as exec10_2_2_, fxexecutio0_.account_no as account11_2_2_, fxexecutio0_.exec_broker as exec12_2_2_, fxexecutio0_.trade_date as trade13_2_2_, fxexecutio0_.settlement_date as settlement14_2_2_, fxexecutio0_.buy_ccy as buy15_2_2_, fxexecutio0_.sell_ccy as sell16_2_2_, fxexecutio0_.buy_quantity as buy17_2_2_, fxexecutio0_.sell_quantity as sell18_2_2_, fxexecutio0_.fx_rate as fx19_2_2_, fxexecutio0_.client_base_equivalent as client20_2_2_, fxexecutio0_.hedge_vs_speculative as hedge21_2_2_, fxexecutio0_.hearsay_ind as hearsay22_2_2_, fxexecutio0_.tax_ind as tax23_2_2_, fxexecutio0_.custodian_broker as custodian24_2_2_, fxexecutio0_.money_manager as money25_2_2_, fxexecutio0_.book_id as book26_2_2_, fxexecutio0_.deal_id as deal27_2_2_, fxexecutio0_.exch_rate as exch28_2_2_, fxexecutio0_.acquisation_date as acquisa29_2_2_, fxexecutio0_.comments as comments2_2_, fxexecutio0_.link_id as link31_2_2_, tctransact1_.trans_id as trans1_0_0_, tctransact1_.store_time as store2_0_0_, tctransact1_.user_id as user3_0_0_, tctransact1_.transmission_id as transmis4_0_0_, tctransact1_.transaction_type as transact5_0_0_, tctransact1_.transaction_status as transact6_0_0_, tctransact1_.process_flag as process7_0_0_, tctransact1_.authorization_time as authoriz8_0_0_, tctransact1_.processing_time as processing9_0_0_, tctransact1_.completion_time as completion10_0_0_, tctransact1_.login_name as login11_0_0_, tctransact1_.orig_trans_id as orig12_0_0_, tctransact1_.reference_no as reference13_0_0_, tctransact1_.bu_client_id as bu14_0_0_, tctransact1_.last_transaction_status as last15_0_0_, tctransact1_.current_flag as current16_0_0_, tctransact1_.content_type as content17_0_0_, tctransact1_.uuid as uuid0_0_, tctransmis2_.transmission_id as transmis1_1_1_, tctransmis2_.user_id as user2_1_1_, tctransmis2_.transmission_status as transmis3_1_1_, tctransmis2_.bu_client_id as bu4_1_1_, tctransmis2_.transmission_mnemonic as transmis5_1_1_, tctransmis2_.transmission_time as transmis6_1_1_, tctransmis2_.posting_time as posting7_1_1_ from TransCapture_beta..fx_execution fxexecutio0_ inner join TransCapture_beta..tc_transaction tctransact1_ on fxexecutio0_.trans_id=tctransact1_.trans_id left outer join TransCapture_beta..tc_transmission tctransmis2_ on tctransact1_.transmission_id=tctransmis2_.transmission_id where fxexecutio0_.trans_id=? and fxexecutio0_.seq_no=?
13:56:58,684 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.FXExecution: select fxexecutio0_.trans_id as trans1_2_2_, fxexecutio0_.seq_no as seq2_2_2_, fxexecutio0_.update_time as update3_2_2_, fxexecutio0_.record_type as record4_2_2_, fxexecutio0_.transaction_type as transact5_2_2_, fxexecutio0_.transaction_level as transact6_2_2_, fxexecutio0_.product_type as product7_2_2_, fxexecutio0_.reference_no as reference8_2_2_, fxexecutio0_.block_id as block9_2_2_, fxexecutio0_.exec_account_no as exec10_2_2_, fxexecutio0_.account_no as account11_2_2_, fxexecutio0_.exec_broker as exec12_2_2_, fxexecutio0_.trade_date as trade13_2_2_, fxexecutio0_.settlement_date as settlement14_2_2_, fxexecutio0_.buy_ccy as buy15_2_2_, fxexecutio0_.sell_ccy as sell16_2_2_, fxexecutio0_.buy_quantity as buy17_2_2_, fxexecutio0_.sell_quantity as sell18_2_2_, fxexecutio0_.fx_rate as fx19_2_2_, fxexecutio0_.client_base_equivalent as client20_2_2_, fxexecutio0_.hedge_vs_speculative as hedge21_2_2_, fxexecutio0_.hearsay_ind as hearsay22_2_2_, fxexecutio0_.tax_ind as tax23_2_2_, fxexecutio0_.custodian_broker as custodian24_2_2_, fxexecutio0_.money_manager as money25_2_2_, fxexecutio0_.book_id as book26_2_2_, fxexecutio0_.deal_id as deal27_2_2_, fxexecutio0_.exch_rate as exch28_2_2_, fxexecutio0_.acquisation_date as acquisa29_2_2_, fxexecutio0_.comments as comments2_2_, fxexecutio0_.link_id as link31_2_2_, tctransact1_.trans_id as trans1_0_0_, tctransact1_.store_time as store2_0_0_, tctransact1_.user_id as user3_0_0_, tctransact1_.transmission_id as transmis4_0_0_, tctransact1_.transaction_type as transact5_0_0_, tctransact1_.transaction_status as transact6_0_0_, tctransact1_.process_flag as process7_0_0_, tctransact1_.authorization_time as authoriz8_0_0_, tctransact1_.processing_time as processing9_0_0_, tctransact1_.completion_time as completion10_0_0_, tctransact1_.login_name as login11_0_0_, tctransact1_.orig_trans_id as orig12_0_0_, tctransact1_.reference_no as reference13_0_0_, tctransact1_.bu_client_id as bu14_0_0_, tctransact1_.last_transaction_status as last15_0_0_, tctransact1_.current_flag as current16_0_0_, tctransact1_.content_type as content17_0_0_, tctransact1_.uuid as uuid0_0_, tctransmis2_.transmission_id as transmis1_1_1_, tctransmis2_.user_id as user2_1_1_, tctransmis2_.transmission_status as transmis3_1_1_, tctransmis2_.bu_client_id as bu4_1_1_, tctransmis2_.transmission_mnemonic as transmis5_1_1_, tctransmis2_.transmission_time as transmis6_1_1_, tctransmis2_.posting_time as posting7_1_1_ from TransCapture_beta..fx_execution fxexecutio0_ inner join TransCapture_beta..tc_transaction tctransact1_ on fxexecutio0_.trans_id=tctransact1_.trans_id left outer join TransCapture_beta..tc_transmission tctransmis2_ on tctransact1_.transmission_id=tctransmis2_.transmission_id where fxexecutio0_.trans_id=? and fxexecutio0_.seq_no=?
13:56:58,809 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.FXExecution: select fxexecutio0_.trans_id as trans1_2_0_, fxexecutio0_.seq_no as seq2_2_0_, fxexecutio0_.update_time as update3_2_0_, fxexecutio0_.record_type as record4_2_0_, fxexecutio0_.transaction_type as transact5_2_0_, fxexecutio0_.transaction_level as transact6_2_0_, fxexecutio0_.product_type as product7_2_0_, fxexecutio0_.reference_no as reference8_2_0_, fxexecutio0_.block_id as block9_2_0_, fxexecutio0_.exec_account_no as exec10_2_0_, fxexecutio0_.account_no as account11_2_0_, fxexecutio0_.exec_broker as exec12_2_0_, fxexecutio0_.trade_date as trade13_2_0_, fxexecutio0_.settlement_date as settlement14_2_0_, fxexecutio0_.buy_ccy as buy15_2_0_, fxexecutio0_.sell_ccy as sell16_2_0_, fxexecutio0_.buy_quantity as buy17_2_0_, fxexecutio0_.sell_quantity as sell18_2_0_, fxexecutio0_.fx_rate as fx19_2_0_, fxexecutio0_.client_base_equivalent as client20_2_0_, fxexecutio0_.hedge_vs_speculative as hedge21_2_0_, fxexecutio0_.hearsay_ind as hearsay22_2_0_, fxexecutio0_.tax_ind as tax23_2_0_, fxexecutio0_.custodian_broker as custodian24_2_0_, fxexecutio0_.money_manager as money25_2_0_, fxexecutio0_.book_id as book26_2_0_, fxexecutio0_.deal_id as deal27_2_0_, fxexecutio0_.exch_rate as exch28_2_0_, fxexecutio0_.acquisation_date as acquisa29_2_0_, fxexecutio0_.comments as comments2_0_, fxexecutio0_.link_id as link31_2_0_ from TransCapture_beta..fx_execution fxexecutio0_ where fxexecutio0_.trans_id=? and fxexecutio0_.seq_no=?
13:56:58,856 DEBUG EntityLoader:79 - Static select for entity com.ms.pbcustody.transcapfx.model.FXExecution: select fxexecutio0_.trans_id as trans1_2_0_, fxexecutio0_.seq_no as seq2_2_0_, fxexecutio0_.update_time as update3_2_0_, fxexecutio0_.record_type as record4_2_0_, fxexecutio0_.transaction_type as transact5_2_0_, fxexecutio0_.transaction_level as transact6_2_0_, fxexecutio0_.product_type as product7_2_0_, fxexecutio0_.reference_no as reference8_2_0_, fxexecutio0_.block_id as block9_2_0_, fxexecutio0_.exec_account_no as exec10_2_0_, fxexecutio0_.account_no as account11_2_0_, fxexecutio0_.exec_broker as exec12_2_0_, fxexecutio0_.trade_date as trade13_2_0_, fxexecutio0_.settlement_date as settlement14_2_0_, fxexecutio0_.buy_ccy as buy15_2_0_, fxexecutio0_.sell_ccy as sell16_2_0_, fxexecutio0_.buy_quantity as buy17_2_0_, fxexecutio0_.sell_quantity as sell18_2_0_, fxexecutio0_.fx_rate as fx19_2_0_, fxexecutio0_.client_base_equivalent as client20_2_0_, fxexecutio0_.hedge_vs_speculative as hedge21_2_0_, fxexecutio0_.hearsay_ind as hearsay22_2_0_, fxexecutio0_.tax_ind as tax23_2_0_, fxexecutio0_.custodian_broker as custodian24_2_0_, fxexecutio0_.money_manager as money25_2_0_, fxexecutio0_.book_id as book26_2_0_, fxexecutio0_.deal_id as deal27_2_0_, fxexecutio0_.exch_rate as exch28_2_0_, fxexecutio0_.acquisation_date as acquisa29_2_0_, fxexecutio0_.comments as comments2_0_, fxexecutio0_.link_id as link31_2_0_ from TransCapture_beta..fx_execution fxexecutio0_ where fxexecutio0_.trans_id=? and fxexecutio0_.seq_no=?
13:56:58,872 DEBUG EntityLoader:67 - Static select for action ACTION_MERGE on entity com.ms.pbcustody.transcapfx.model.FXExecution: select fxexecutio0_.trans_id as trans1_2_0_, fxexecutio0_.seq_no as seq2_2_0_, fxexecutio0_.update_time as update3_2_0_, fxexecutio0_.record_type as record4_2_0_, fxexecutio0_.transaction_type as transact5_2_0_, fxexecutio0_.transaction_level as transact6_2_0_, fxexecutio0_.product_type as product7_2_0_, fxexecutio0_.reference_no as reference8_2_0_, fxexecutio0_.block_id as block9_2_0_, fxexecutio0_.exec_account_no as exec10_2_0_, fxexecutio0_.account_no as account11_2_0_, fxexecutio0_.exec_broker as exec12_2_0_, fxexecutio0_.trade_date as trade13_2_0_, fxexecutio0_.settlement_date as settlement14_2_0_, fxexecutio0_.buy_ccy as buy15_2_0_, fxexecutio0_.sell_ccy as sell16_2_0_, fxexecutio0_.buy_quantity as buy17_2_0_, fxexecutio0_.sell_quantity as sell18_2_0_, fxexecutio0_.fx_rate as fx19_2_0_, fxexecutio0_.client_base_equivalent as client20_2_0_, fxexecutio0_.hedge_vs_speculative as hedge21_2_0_, fxexecutio0_.hearsay_ind as hearsay22_2_0_, fxexecutio0_.tax_ind as tax23_2_0_, fxexecutio0_.custodian_broker as custodian24_2_0_, fxexecutio0_.money_manager as money25_2_0_, fxexecutio0_.book_id as book26_2_0_, fxexecutio0_.deal_id as deal27_2_0_, fxexecutio0_.exch_rate as exch28_2_0_, fxexecutio0_.acquisation_date as acquisa29_2_0_, fxexecutio0_.comments as comments2_0_, fxexecutio0_.link_id as link31_2_0_ from TransCapture_beta..fx_execution fxexecutio0_ where fxexecutio0_.trans_id=? and fxexecutio0_.seq_no=?
13:56:58,872 DEBUG EntityLoader:67 - Static select for action ACTION_REFRESH on entity com.ms.pbcustody.transcapfx.model.FXExecution: select fxexecutio0_.trans_id as trans1_2_0_, fxexecutio0_.seq_no as seq2_2_0_, fxexecutio0_.update_time as update3_2_0_, fxexecutio0_.record_type as record4_2_0_, fxexecutio0_.transaction_type as transact5_2_0_, fxexecutio0_.transaction_level as transact6_2_0_, fxexecutio0_.product_type as product7_2_0_, fxexecutio0_.reference_no as reference8_2_0_, fxexecutio0_.block_id as block9_2_0_, fxexecutio0_.exec_account_no as exec10_2_0_, fxexecutio0_.account_no as account11_2_0_, fxexecutio0_.exec_broker as exec12_2_0_, fxexecutio0_.trade_date as trade13_2_0_, fxexecutio0_.settlement_date as settlement14_2_0_, fxexecutio0_.buy_ccy as buy15_2_0_, fxexecutio0_.sell_ccy as sell16_2_0_, fxexecutio0_.buy_quantity as buy17_2_0_, fxexecutio0_.sell_quantity as sell18_2_0_, fxexecutio0_.fx_rate as fx19_2_0_, fxexecutio0_.client_base_equivalent as client20_2_0_, fxexecutio0_.hedge_vs_speculative as hedge21_2_0_, fxexecutio0_.hearsay_ind as hearsay22_2_0_, fxexecutio0_.tax_ind as tax23_2_0_, fxexecutio0_.custodian_broker as custodian24_2_0_, fxexecutio0_.money_manager as money25_2_0_, fxexecutio0_.book_id as book26_2_0_, fxexecutio0_.deal_id as deal27_2_0_, fxexecutio0_.exch_rate as exch28_2_0_, fxexecutio0_.acquisation_date as acquisa29_2_0_, fxexecutio0_.comments as comments2_0_, fxexecutio0_.link_id as link31_2_0_ from TransCapture_beta..fx_execution fxexecutio0_ where fxexecutio0_.trans_id=? and fxexecutio0_.seq_no=?
13:56:58,950 DEBUG OneToManyLoader:64 - Static select for one-to-many com.ms.pbcustody.transcapfx.model.TCTransaction.executions: select executions0_.trans_id as trans1_1_, executions0_.seq_no as seq2_1_, executions0_.trans_id as trans1_2_0_, executions0_.seq_no as seq2_2_0_, executions0_.update_time as update3_2_0_, executions0_.record_type as record4_2_0_, executions0_.transaction_type as transact5_2_0_, executions0_.transaction_level as transact6_2_0_, executions0_.product_type as product7_2_0_, executions0_.reference_no as reference8_2_0_, executions0_.block_id as block9_2_0_, executions0_.exec_account_no as exec10_2_0_, executions0_.account_no as account11_2_0_, executions0_.exec_broker as exec12_2_0_, executions0_.trade_date as trade13_2_0_, executions0_.settlement_date as settlement14_2_0_, executions0_.buy_ccy as buy15_2_0_, executions0_.sell_ccy as sell16_2_0_, executions0_.buy_quantity as buy17_2_0_, executions0_.sell_quantity as sell18_2_0_, executions0_.fx_rate as fx19_2_0_, executions0_.client_base_equivalent as client20_2_0_, executions0_.hedge_vs_speculative as hedge21_2_0_, executions0_.hearsay_ind as hearsay22_2_0_, executions0_.tax_ind as tax23_2_0_, executions0_.custodian_broker as custodian24_2_0_, executions0_.money_manager as money25_2_0_, executions0_.book_id as book26_2_0_, executions0_.deal_id as deal27_2_0_, executions0_.exch_rate as exch28_2_0_, executions0_.acquisation_date as acquisa29_2_0_, executions0_.comments as comments2_0_, executions0_.link_id as link31_2_0_ from TransCapture_beta..fx_execution executions0_ where executions0_.trans_id=?
13:56:58,950 DEBUG OneToManyLoader:64 - Static select for one-to-many com.ms.pbcustody.transcapfx.model.TCTransmission.transactions: select transactio0_.transmission_id as transmis4_1_, transactio0_.trans_id as trans1_1_, transactio0_.trans_id as trans1_0_0_, transactio0_.store_time as store2_0_0_, transactio0_.user_id as user3_0_0_, transactio0_.transmission_id as transmis4_0_0_, transactio0_.transaction_type as transact5_0_0_, transactio0_.transaction_status as transact6_0_0_, transactio0_.process_flag as process7_0_0_, transactio0_.authorization_time as authoriz8_0_0_, transactio0_.processing_time as processing9_0_0_, transactio0_.completion_time as completion10_0_0_, transactio0_.login_name as login11_0_0_, transactio0_.orig_trans_id as orig12_0_0_, transactio0_.reference_no as reference13_0_0_, transactio0_.bu_client_id as bu14_0_0_, transactio0_.last_transaction_status as last15_0_0_, transactio0_.current_flag as current16_0_0_, transactio0_.content_type as content17_0_0_, transactio0_.uuid as uuid0_0_ from TransCapture_beta..tc_transaction transactio0_ where transactio0_.transmission_id=?
13:56:58,997 DEBUG OneToManyLoader:64 - Static select for one-to-many com.ms.pbcustody.transcapfx.model.TCTransaction.allocations: select allocation0_.trans_id as trans1_1_, allocation0_.seq_no as seq2_1_, allocation0_.trans_id as trans1_3_0_, allocation0_.seq_no as seq2_3_0_, allocation0_.update_time as update3_3_0_, allocation0_.record_type as record4_3_0_, allocation0_.transaction_type as transact5_3_0_, allocation0_.transaction_level as transact6_3_0_, allocation0_.product_type as product7_3_0_, allocation0_.reference_no as reference8_3_0_, allocation0_.block_id as block9_3_0_, allocation0_.exec_account_no as exec10_3_0_, allocation0_.account_no as account11_3_0_, allocation0_.exec_broker as exec12_3_0_, allocation0_.trade_date as trade13_3_0_, allocation0_.settlement_date as settlement14_3_0_, allocation0_.buy_ccy as buy15_3_0_, allocation0_.sell_ccy as sell16_3_0_, allocation0_.buy_quantity as buy17_3_0_, allocation0_.sell_quantity as sell18_3_0_, allocation0_.fx_rate as fx19_3_0_, allocation0_.client_base_equivalent as client20_3_0_, allocation0_.hedge_vs_speculative as hedge21_3_0_, allocation0_.hearsay_ind as hearsay22_3_0_, allocation0_.tax_ind as tax23_3_0_, allocation0_.custodian_broker as custodian24_3_0_, allocation0_.money_manager as money25_3_0_, allocation0_.book_id as book26_3_0_, allocation0_.deal_id as deal27_3_0_, allocation0_.exch_rate as exch28_3_0_, allocation0_.acquisation_date as acquisa29_3_0_, allocation0_.comments as comments3_0_, allocation0_.link_id as link31_3_0_ from TransCapture_beta..fx_allocation allocation0_ where allocation0_.trans_id=?
13:56:59,013 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
13:56:59,044 DEBUG SessionFactoryObjectFactory:76 - registered: 108e716a0c82c87e010c82c896050000 (SybaseSession)
13:56:59,044 INFO SessionFactoryObjectFactory:86 - Factory name: SybaseSession
13:56:59,106 INFO NamingHelper:26 - JNDI InitialContext properties:{}
13:56:59,106 DEBUG NamingHelper:48 - binding: SybaseSession
13:56:59,153 DEBUG SessionFactoryImpl:292 - instantiated session factory
13:56:59,216 INFO UpdateTimestampsCache:43 - starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
13:56:59,216 WARN EhCacheProvider:103 - Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
13:56:59,216 DEBUG EhCacheProvider:106 - started EHCache region: org.hibernate.cache.UpdateTimestampsCache
13:56:59,231 INFO StandardQueryCache:51 - starting query cache at region: org.hibernate.cache.StandardQueryCache
13:56:59,263 WARN EhCacheProvider:103 - Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
13:56:59,263 DEBUG EhCacheProvider:106 - started EHCache region: org.hibernate.cache.StandardQueryCache
13:56:59,263 INFO SessionFactoryImpl:353 - Checking 0 named HQL queries
13:56:59,263 INFO SessionFactoryImpl:373 - Checking 0 named SQL queries
13:56:59,497 DEBUG SessionImpl:272 - opened session at timestamp: 4723693237874688
13:56:59,731 DEBUG ThreadLocalSessionContext:282 - allowing method [beginTransaction] in non-transacted context
13:56:59,747 DEBUG JDBCTransaction:54 - begin
13:56:59,747 DEBUG ConnectionManager:313 - opening JDBC connection
13:56:59,747 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
13:56:59,747 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
13:56:59,747 DEBUG JDBCTransaction:59 - current autocommit status: false
13:56:59,747 DEBUG JDBCContext:202 - after transaction begin
13:56:59,763 DEBUG DefaultLoadEventListener:153 - loading entity: [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:56:59,763 DEBUG DefaultLoadEventListener:304 - attempting to resolve: [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:56:59,778 DEBUG ReadWriteCache:75 - Cache lookup: com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B
13:56:59,810 DEBUG EhCache:104 - key: com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B
13:56:59,810 DEBUG EhCache:113 - Element for com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B is null
13:56:59,810 DEBUG ReadWriteCache:91 - Cache miss: com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B
13:56:59,825 DEBUG DefaultLoadEventListener:340 - object not resolved in any cache: [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:56:59,825 DEBUG AbstractEntityPersister:2723 - Fetching entity: [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:56:59,825 DEBUG Loader:1777 - loading entity: [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:56:59,825 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
13:56:59,841 DEBUG SQL:346 - select tctransmis0_.transmission_id as transmis1_1_1_, tctransmis0_.user_id as user2_1_1_, tctransmis0_.transmission_status as transmis3_1_1_, tctransmis0_.bu_client_id as bu4_1_1_, tctransmis0_.transmission_mnemonic as transmis5_1_1_, tctransmis0_.transmission_time as transmis6_1_1_, tctransmis0_.posting_time as posting7_1_1_, transactio1_.transmission_id as transmis4_3_, transactio1_.trans_id as trans1_3_, transactio1_.trans_id as trans1_0_0_, transactio1_.store_time as store2_0_0_, transactio1_.user_id as user3_0_0_, transactio1_.transmission_id as transmis4_0_0_, transactio1_.transaction_type as transact5_0_0_, transactio1_.transaction_status as transact6_0_0_, transactio1_.process_flag as process7_0_0_, transactio1_.authorization_time as authoriz8_0_0_, transactio1_.processing_time as processing9_0_0_, transactio1_.completion_time as completion10_0_0_, transactio1_.login_name as login11_0_0_, transactio1_.orig_trans_id as orig12_0_0_, transactio1_.reference_no as reference13_0_0_, transactio1_.bu_client_id as bu14_0_0_, transactio1_.last_transaction_status as last15_0_0_, transactio1_.current_flag as current16_0_0_, transactio1_.content_type as content17_0_0_, transactio1_.uuid as uuid0_0_ from TransCapture_beta..tc_transmission tctransmis0_ left outer join TransCapture_beta..tc_transaction transactio1_ on tctransmis0_.transmission_id=transactio1_.transmission_id where tctransmis0_.transmission_id=?
13:56:59,841 DEBUG AbstractBatcher:424 - preparing statement
13:56:59,841 DEBUG StringType:79 - binding 'DA687C97C2D94280A76AA04D5CF5DC7B' to parameter: 1
13:56:59,888 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
13:56:59,888 DEBUG Loader:682 - processing result set
13:56:59,888 DEBUG Loader:709 - done processing result set (0 rows)
13:56:59,888 DEBUG AbstractBatcher:334 - about to close ResultSet (open ResultSets: 1, globally: 1)
13:56:59,888 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
13:56:59,903 DEBUG AbstractBatcher:470 - closing statement
13:56:59,919 DEBUG Loader:839 - total objects hydrated: 0
13:56:59,919 DEBUG CollectionLoadContext:262 - 0 collections were found in result set for role: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:56:59,935 DEBUG CollectionLoadContext:272 - 0 collections initialized for role: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:56:59,935 DEBUG StatefulPersistenceContext:820 - initializing non-lazy collections
13:56:59,935 DEBUG Loader:1808 - done entity load
13:57:00,044 DEBUG IdentifierValue:153 - id unsaved-value strategy UNDEFINED
13:57:00,044 DEBUG ReadWriteCache:75 - Cache lookup: com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B
13:57:00,044 DEBUG EhCache:104 - key: com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B
13:57:00,044 DEBUG EhCache:113 - Element for com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B is null
13:57:00,060 DEBUG ReadWriteCache:91 - Cache miss: com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B
13:57:00,060 DEBUG AbstractEntityPersister:975 - Getting current persistent state for: [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:57:00,075 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
13:57:00,075 DEBUG SQL:346 - select tctransmis_.transmission_id, tctransmis_.user_id as user2_1_, tctransmis_.transmission_status as transmis3_1_, tctransmis_.bu_client_id as bu4_1_, tctransmis_.transmission_mnemonic as transmis5_1_, tctransmis_.transmission_time as transmis6_1_, tctransmis_.posting_time as posting7_1_ from TransCapture_beta..tc_transmission tctransmis_ where tctransmis_.transmission_id=?
13:57:00,091 DEBUG AbstractBatcher:424 - preparing statement
13:57:00,091 DEBUG StringType:79 - binding 'DA687C97C2D94280A76AA04D5CF5DC7B' to parameter: 1
13:57:00,122 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
13:57:00,122 DEBUG AbstractBatcher:470 - closing statement
13:57:00,122 DEBUG AbstractSaveEventListener:462 - transient instance of: com.ms.pbcustody.transcapfx.model.TCTransmission
13:57:00,122 DEBUG DefaultSaveOrUpdateEventListener:161 - saving transient instance
13:57:00,122 DEBUG AbstractSaveEventListener:106 - generated identifier: DA687C97C2D94280A76AA04D5CF5DC7B, using strategy: org.hibernate.id.Assigned
13:57:00,122 DEBUG AbstractSaveEventListener:139 - saving [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:57:00,216 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransmission
13:57:00,216 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransmission
13:57:00,388 DEBUG WrapVisitor:87 - Wrapped collection in role: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:57:00,466 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransmission
13:57:00,466 DEBUG Cascade:285 - cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:57:00,481 DEBUG CascadingAction:133 - cascading to saveOrUpdate: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,481 DEBUG AbstractSaveEventListener:462 - transient instance of: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,481 DEBUG DefaultSaveOrUpdateEventListener:161 - saving transient instance
13:57:00,497 DEBUG AbstractSaveEventListener:106 - generated identifier: 647794, using strategy: com.ms.pbcustody.transcapfx.model.TransactionIdGenerator
13:57:00,497 DEBUG AbstractSaveEventListener:139 - saving [com.ms.pbcustody.transcapfx.model.TCTransaction#647794]
13:57:00,528 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,528 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,528 DEBUG Versioning:60 - using initial version: Tue Jul 18 13:56:59 EDT 2006
13:57:00,528 DEBUG WrapVisitor:87 - Wrapped collection in role: com.ms.pbcustody.transcapfx.model.TCTransaction.executions
13:57:00,528 DEBUG WrapVisitor:87 - Wrapped collection in role: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations
13:57:00,544 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,544 DEBUG Cascade:285 - cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.executions
13:57:00,544 DEBUG CascadingAction:133 - cascading to saveOrUpdate: com.ms.pbcustody.transcapfx.model.FXExecution
13:57:00,544 DEBUG VersionValue:87 - version unsaved-value strategy UNDEFINED
13:57:00,544 DEBUG IdentifierValue:153 - id unsaved-value strategy UNDEFINED
13:57:00,560 DEBUG ReadWriteCache:75 - Cache lookup: com.ms.pbcustody.transcapfx.model.FXExecution#com.ms.pbcustody.transcapfx.model.FXExecution@1d33eef
13:57:00,560 DEBUG EhCache:104 - key: com.ms.pbcustody.transcapfx.model.FXExecution#com.ms.pbcustody.transcapfx.model.FXExecution@1d33eef
13:57:00,560 DEBUG EhCache:113 - Element for com.ms.pbcustody.transcapfx.model.FXExecution#com.ms.pbcustody.transcapfx.model.FXExecution@1d33eef is null
13:57:00,560 DEBUG ReadWriteCache:91 - Cache miss: com.ms.pbcustody.transcapfx.model.FXExecution#com.ms.pbcustody.transcapfx.model.FXExecution@1d33eef
13:57:00,560 DEBUG AbstractEntityPersister:975 - Getting current persistent state for: [com.ms.pbcustody.transcapfx.model.FXExecution#component[transactionId,seqNo]{transactionId=null, seqNo=0}]
13:57:00,575 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
13:57:00,575 DEBUG SQL:346 - select fxexecutio_.trans_id, fxexecutio_.seq_no, fxexecutio_.update_time as update3_2_, fxexecutio_.record_type as record4_2_, fxexecutio_.transaction_type as transact5_2_, fxexecutio_.transaction_level as transact6_2_, fxexecutio_.product_type as product7_2_, fxexecutio_.reference_no as reference8_2_, fxexecutio_.block_id as block9_2_, fxexecutio_.exec_account_no as exec10_2_, fxexecutio_.account_no as account11_2_, fxexecutio_.exec_broker as exec12_2_, fxexecutio_.trade_date as trade13_2_, fxexecutio_.settlement_date as settlement14_2_, fxexecutio_.buy_ccy as buy15_2_, fxexecutio_.sell_ccy as sell16_2_, fxexecutio_.buy_quantity as buy17_2_, fxexecutio_.sell_quantity as sell18_2_, fxexecutio_.fx_rate as fx19_2_, fxexecutio_.client_base_equivalent as client20_2_, fxexecutio_.hedge_vs_speculative as hedge21_2_, fxexecutio_.hearsay_ind as hearsay22_2_, fxexecutio_.tax_ind as tax23_2_, fxexecutio_.custodian_broker as custodian24_2_, fxexecutio_.money_manager as money25_2_, fxexecutio_.book_id as book26_2_, fxexecutio_.deal_id as deal27_2_, fxexecutio_.exch_rate as exch28_2_, fxexecutio_.acquisation_date as acquisa29_2_, fxexecutio_.comments as comments2_, fxexecutio_.link_id as link31_2_ from TransCapture_beta..fx_execution fxexecutio_ where fxexecutio_.trans_id=? and fxexecutio_.seq_no=?
13:57:00,575 DEBUG AbstractBatcher:424 - preparing statement
13:57:00,575 DEBUG IntegerType:71 - binding null to parameter: 1
13:57:00,575 DEBUG IntegerType:79 - binding '0' to parameter: 2
13:57:00,591 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
13:57:00,591 DEBUG AbstractBatcher:470 - closing statement
13:57:00,591 DEBUG AbstractSaveEventListener:462 - transient instance of: com.ms.pbcustody.transcapfx.model.FXExecution
13:57:00,591 DEBUG DefaultSaveOrUpdateEventListener:161 - saving transient instance
13:57:00,606 DEBUG AbstractSaveEventListener:106 - generated identifier: component[transactionId,seqNo]{transactionId=null, seqNo=0}, using strategy: org.hibernate.id.Assigned
13:57:00,716 DEBUG AbstractSaveEventListener:139 - saving [com.ms.pbcustody.transcapfx.model.FXExecution#component[transactionId,seqNo]{transactionId=null, seqNo=0}]
13:57:00,716 DEBUG Versioning:60 - using initial version: Tue Jul 18 13:56:59 EDT 2006
13:57:00,731 DEBUG Cascade:300 - done cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.executions
13:57:00,731 DEBUG Cascade:285 - cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations
13:57:00,731 DEBUG Cascade:300 - done cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations
13:57:00,731 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,731 DEBUG Cascade:300 - done cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:57:00,731 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransmission
13:57:00,731 DEBUG JDBCTransaction:103 - commit
13:57:00,731 DEBUG SessionImpl:352 - automatically flushing session
13:57:00,747 DEBUG AbstractFlushingEventListener:58 - flushing session
13:57:00,763 DEBUG AbstractFlushingEventListener:111 - processing flush-time cascades
13:57:00,763 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransmission
13:57:00,778 DEBUG Cascade:285 - cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:57:00,778 DEBUG CascadingAction:133 - cascading to saveOrUpdate: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,778 DEBUG AbstractSaveEventListener:436 - persistent instance of: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,778 DEBUG DefaultSaveOrUpdateEventListener:105 - ignoring persistent instance
13:57:00,778 DEBUG DefaultSaveOrUpdateEventListener:142 - object already associated with session: [com.ms.pbcustody.transcapfx.model.TCTransaction#647794]
13:57:00,778 DEBUG Cascade:300 - done cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions
13:57:00,778 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransmission
13:57:00,778 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,778 DEBUG Cascade:285 - cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.executions
13:57:00,778 DEBUG CascadingAction:133 - cascading to saveOrUpdate: com.ms.pbcustody.transcapfx.model.FXExecution
13:57:00,778 DEBUG AbstractSaveEventListener:436 - persistent instance of: com.ms.pbcustody.transcapfx.model.FXExecution
13:57:00,778 DEBUG DefaultSaveOrUpdateEventListener:105 - ignoring persistent instance
13:57:00,794 DEBUG DefaultSaveOrUpdateEventListener:142 - object already associated with session: [com.ms.pbcustody.transcapfx.model.FXExecution#component[transactionId,seqNo]{transactionId=null, seqNo=0}]
13:57:00,794 DEBUG Cascade:300 - done cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.executions
13:57:00,794 DEBUG Cascade:285 - cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations
13:57:00,794 DEBUG Cascade:300 - done cascade ACTION_SAVE_UPDATE for collection: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations
13:57:00,794 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.ms.pbcustody.transcapfx.model.TCTransaction
13:57:00,794 DEBUG AbstractFlushingEventListener:153 - dirty checking collections
13:57:00,794 DEBUG AbstractFlushingEventListener:170 - Flushing entities and processing referenced collections
13:57:00,841 DEBUG Collections:176 - Collection found: [com.ms.pbcustody.transcapfx.model.TCTransmission.transactions#DA687C97C2D94280A76AA04D5CF5DC7B], was: [<unreferenced>] (initialized)
13:57:00,841 DEBUG Collections:176 - Collection found: [com.ms.pbcustody.transcapfx.model.TCTransaction.executions#647794], was: [<unreferenced>] (initialized)
13:57:00,841 DEBUG Collections:176 - Collection found: [com.ms.pbcustody.transcapfx.model.TCTransaction.allocations#647794], was: [<unreferenced>] (initialized)
13:57:00,856 DEBUG AbstractFlushingEventListener:209 - Processing unreferenced collections
13:57:00,856 DEBUG AbstractFlushingEventListener:223 - Scheduling collection removes/(re)creates/updates
13:57:00,872 DEBUG AbstractFlushingEventListener:85 - Flushed: 3 insertions, 0 updates, 0 deletions to 3 objects
13:57:00,872 DEBUG AbstractFlushingEventListener:91 - Flushed: 3 (re)creations, 0 updates, 0 removals to 3 collections
13:57:00,872 DEBUG Printer:83 - listing entities:
13:57:00,888 DEBUG Printer:90 - com.ms.pbcustody.transcapfx.model.TCTransmission{transactions=[com.ms.pbcustody.transcapfx.model.TCTransaction#647794], transmissionTime=2006-07-18 13:56:59, userId=test, transmissionStatus=OK, postingTime=2006-07-18 13:56:59, transmissionId=DA687C97C2D94280A76AA04D5CF5DC7B, buClientId=PBRKC0000902, transmissionMnemonic=HFBX}
13:57:01,138 DEBUG Printer:90 - com.ms.pbcustody.transcapfx.model.TCTransaction{transactionId=647794, lastTransactionStatus=null, transmission=com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B, userId=test, loginName=test, allocations=[], buClientId=PBRKC0000902, authorizationTime=null, processingTime=null, contentType=FX, currentFlag=Y, transactionStatus=NEWPENDING, processFlag=N, completionTime=null, referenceNo=HF3K006040300831, transactionType=TR, uuid=klXT4ZlYQMOBsFX2Blu19A==, storeTime=2006-07-18 13:56:59, transmissionId=DA687C97C2D94280A76AA04D5CF5DC7B, origTransId=null, executions=[com.ms.pbcustody.transcapfx.model.FXExecution]}
13:57:01,138 DEBUG Printer:90 - com.ms.pbcustody.transcapfx.model.FXExecution{comments=, hedgeVsSpeculative=, updateTime=2006-07-18 13:56:59, buyCcy=GBP, settlementDate=null, referenceNo=HF3K006040300831, executionBroker=MSCO, productType=F, sellCcy=USD, transactionType=null, acquisationDate=null, taxIndicator=null, executionAccountNo=038927000, blockId=null, sellQuantity=0.0, fxRate=0.0, dealId=F, buyQuantity=0.0, transactionLevel=B, hearsayIndicator=null, exchangeRate=0.0, accountNo=038927000, moneyManager=null, bookId=null, custodianBroker=0, tradeDate=null, clientBaseEquivalent=0.0, Transaction=com.ms.pbcustody.transcapfx.model.TCTransaction#647794, recordType=0, linkId=null}
13:57:01,138 DEBUG AbstractFlushingEventListener:289 - executing flush
13:57:01,138 DEBUG ReadWriteCache:113 - Invalidating: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions#DA687C97C2D94280A76AA04D5CF5DC7B
13:57:01,138 DEBUG EhCache:104 - key: com.ms.pbcustody.transcapfx.model.TCTransmission.transactions#DA687C97C2D94280A76AA04D5CF5DC7B
13:57:01,138 DEBUG EhCache:113 - Element for com.ms.pbcustody.transcapfx.model.TCTransmission.transactions#DA687C97C2D94280A76AA04D5CF5DC7B is null
13:57:01,185 DEBUG ReadWriteCache:113 - Invalidating: com.ms.pbcustody.transcapfx.model.TCTransaction.executions#647794
13:57:01,185 DEBUG EhCache:104 - key: com.ms.pbcustody.transcapfx.model.TCTransaction.executions#647794
13:57:01,200 DEBUG EhCache:113 - Element for com.ms.pbcustody.transcapfx.model.TCTransaction.executions#647794 is null
13:57:01,200 DEBUG ReadWriteCache:113 - Invalidating: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations#647794
13:57:01,200 DEBUG EhCache:104 - key: com.ms.pbcustody.transcapfx.model.TCTransaction.allocations#647794
13:57:01,200 DEBUG EhCache:113 - Element for com.ms.pbcustody.transcapfx.model.TCTransaction.allocations#647794 is null
13:57:01,200 DEBUG UpdateTimestampsCache:51 - Pre-invalidating space [TransCapture_beta..tc_transmission]
13:57:01,200 DEBUG AbstractEntityPersister:2034 - Inserting entity: [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:57:01,200 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
13:57:01,200 DEBUG SQL:346 - insert into TransCapture_beta..tc_transmission (user_id, transmission_status, bu_client_id, transmission_mnemonic, transmission_time, posting_time, transmission_id) values (?, ?, ?, ?, ?, ?, ?)
13:57:01,263 DEBUG AbstractBatcher:424 - preparing statement
13:57:01,263 DEBUG AbstractEntityPersister:1821 - Dehydrating entity: [com.ms.pbcustody.transcapfx.model.TCTransmission#DA687C97C2D94280A76AA04D5CF5DC7B]
13:57:01,294 DEBUG StringType:79 - binding 'test' to parameter: 1
13:57:01,294 DEBUG StringType:79 - binding 'OK' to parameter: 2
13:57:01,294 DEBUG StringType:79 - binding 'PBRKC0000902' to parameter: 3
13:57:01,294 DEBUG StringType:79 - binding 'HFBX' to parameter: 4
13:57:01,310 DEBUG TimestampType:79 - binding '2006-07-18 13:56:59' to parameter: 5
13:57:01,310 DEBUG TimestampType:79 - binding '2006-07-18 13:56:59' to parameter: 6
13:57:01,310 DEBUG StringType:79 - binding 'DA687C97C2D94280A76AA04D5CF5DC7B' to parameter: 7
13:57:01,310 DEBUG AbstractBatcher:28 - Adding to batch
13:57:01,325 DEBUG UpdateTimestampsCache:51 - Pre-invalidating space [TransCapture_beta..tc_transaction]
13:57:01,325 DEBUG AbstractEntityPersister:2034 - Inserting entity: [com.ms.pbcustody.transcapfx.model.TCTransaction#647794]
13:57:01,341 DEBUG AbstractEntityPersister:2035 - Version: Tue Jul 18 13:56:59 EDT 2006
13:57:01,341 DEBUG AbstractBatcher:55 - Executing batch size: 1
13:57:01,341 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
13:57:01,341 DEBUG AbstractBatcher:470 - closing statement
13:57:01,341 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
13:57:01,341 DEBUG SQL:346 - insert into TransCapture_beta..tc_transaction (store_time, user_id, transmission_id, transaction_type, transaction_status, process_flag, authorization_time, processing_time, completion_time, login_name, orig_trans_id, reference_no, bu_client_id, last_transaction_status, current_flag, content_type, uuid, trans_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
13:57:01,341 DEBUG AbstractBatcher:424 - preparing statement
13:57:01,341 DEBUG AbstractEntityPersister:1821 - Dehydrating entity: [com.ms.pbcustody.transcapfx.model.TCTransaction#647794]
13:57:01,341 DEBUG TimestampType:79 - binding '2006-07-18 13:56:59' to parameter: 1
13:57:01,356 DEBUG StringType:79 - binding 'test' to parameter: 2
13:57:01,356 DEBUG StringType:79 - binding 'DA687C97C2D94280A76AA04D5CF5DC7B' to parameter: 3
13:57:01,356 DEBUG StringType:79 - binding 'TR' to parameter: 4
13:57:01,356 DEBUG StringType:79 - binding 'NEWPENDING' to parameter: 5
13:57:01,356 DEBUG StringType:79 - binding 'N' to parameter: 6
13:57:01,356 DEBUG TimestampType:71 - binding null to parameter: 7
13:57:01,356 DEBUG TimestampType:71 - binding null to parameter: 8
13:57:01,356 DEBUG TimestampType:71 - binding null to parameter: 9
13:57:01,356 DEBUG StringType:79 - binding 'test' to parameter: 10
13:57:01,356 DEBUG IntegerType:71 - binding null to parameter: 11
13:57:01,356 DEBUG StringType:79 - binding 'HF3K006040300831' to parameter: 12
13:57:01,356 DEBUG StringType:79 - binding 'PBRKC0000902' to parameter: 13
13:57:01,372 DEBUG StringType:71 - binding null to parameter: 14
13:57:01,372 DEBUG StringType:79 - binding 'Y' to parameter: 15
13:57:01,372 DEBUG StringType:79 - binding 'FX' to parameter: 16
13:57:01,372 DEBUG StringType:79 - binding 'klXT4ZlYQMOBsFX2Blu19A==' to parameter: 17
13:57:01,372 DEBUG IntegerType:79 - binding '647794' to parameter: 18
13:57:01,372 DEBUG AbstractBatcher:28 - Adding to batch
13:57:01,372 DEBUG UpdateTimestampsCache:51 - Pre-invalidating space [TransCapture_beta..fx_execution]
13:57:01,372 DEBUG AbstractEntityPersister:2034 - Inserting entity: [com.ms.pbcustody.transcapfx.model.FXExecution#component[transactionId,seqNo]{transactionId=null, seqNo=0}]
13:57:01,388 DEBUG AbstractEntityPersister:2035 - Version: Tue Jul 18 13:56:59 EDT 2006
13:57:01,388 DEBUG AbstractBatcher:55 - Executing batch size: 1
13:57:01,403 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
13:57:01,403 DEBUG AbstractBatcher:470 - closing statement
13:57:01,403 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
13:57:01,403 DEBUG SQL:346 - insert into TransCapture_beta..fx_execution (update_time, record_type, transaction_type, transaction_level, product_type, reference_no, block_id, exec_account_no, account_no, exec_broker, trade_date, settlement_date, buy_ccy, sell_ccy, buy_quantity, sell_quantity, fx_rate, client_base_equivalent, hedge_vs_speculative, hearsay_ind, tax_ind, custodian_broker, money_manager, book_id, deal_id, exch_rate, acquisation_date, comments, link_id, trans_id, seq_no) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
13:57:01,403 DEBUG AbstractBatcher:424 - preparing statement
13:57:01,419 DEBUG AbstractEntityPersister:1821 - Dehydrating entity: [com.ms.pbcustody.transcapfx.model.FXExecution#component[transactionId,seqNo]{transactionId=null, seqNo=0}]
13:57:01,419 DEBUG TimestampType:79 - binding '2006-07-18 13:56:59' to parameter: 1
13:57:01,419 DEBUG IntegerType:79 - binding '0' to parameter: 2
13:57:01,419 DEBUG StringType:71 - binding null to parameter: 3
13:57:01,419 DEBUG StringType:79 - binding 'B' to parameter: 4
13:57:01,419 DEBUG StringType:79 - binding 'F' to parameter: 5
13:57:01,419 DEBUG StringType:79 - binding 'HF3K006040300831' to parameter: 6
13:57:01,419 DEBUG StringType:71 - binding null to parameter: 7
13:57:01,419 DEBUG StringType:79 - binding '038927000' to parameter: 8
13:57:01,419 DEBUG StringType:79 - binding '038927000' to parameter: 9
13:57:01,435 DEBUG StringType:79 - binding 'MSCO' to parameter: 10
13:57:01,435 DEBUG TimestampType:71 - binding null to parameter: 11
13:57:01,435 DEBUG TimestampType:71 - binding null to parameter: 12
13:57:01,435 DEBUG StringType:79 - binding 'GBP' to parameter: 13
13:57:01,435 DEBUG StringType:79 - binding 'USD' to parameter: 14
13:57:01,435 DEBUG DoubleType:79 - binding '0.0' to parameter: 15
13:57:01,435 DEBUG DoubleType:79 - binding '0.0' to parameter: 16
13:57:01,435 DEBUG DoubleType:79 - binding '0.0' to parameter: 17
13:57:01,435 DEBUG DoubleType:79 - binding '0.0' to parameter: 18
13:57:01,435 DEBUG StringType:79 - binding '' to parameter: 19
13:57:01,435 DEBUG StringType:71 - binding null to parameter: 20
13:57:01,450 DEBUG StringType:71 - binding null to parameter: 21
13:57:01,450 DEBUG StringType:79 - binding '0' to parameter: 22
13:57:01,450 DEBUG StringType:71 - binding null to parameter: 23
13:57:01,450 DEBUG StringType:71 - binding null to parameter: 24
13:57:01,450 DEBUG StringType:79 - binding 'F' to parameter: 25
13:57:01,450 DEBUG DoubleType:79 - binding '0.0' to parameter: 26
13:57:01,450 DEBUG TimestampType:71 - binding null to parameter: 27
13:57:01,450 DEBUG StringType:79 - binding '' to parameter: 28
13:57:01,450 DEBUG IntegerType:71 - binding null to parameter: 29
13:57:01,450 DEBUG IntegerType:71 - binding null to parameter: 30
13:57:01,450 DEBUG IntegerType:79 - binding '0' to parameter: 31
13:57:01,450 DEBUG AbstractBatcher:28 - Adding to batch
13:57:01,450 DEBUG AbstractBatcher:55 - Executing batch size: 1
13:57:01,481 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
13:57:01,481 DEBUG AbstractBatcher:470 - closing statement
13:57:01,497 DEBUG JDBCExceptionReporter:63 - Could not execute JDBC batch update [insert into TransCapture_beta..fx_execution (update_time, record_type, transaction_type, transaction_level, product_type, reference_no, block_id, exec_account_no, account_no, exec_broker, trade_date, settlement_date, buy_ccy, sell_ccy, buy_quantity, sell_quantity, fx_rate, client_base_equivalent, hedge_vs_speculative, hearsay_ind, tax_ind, custodian_broker, money_manager, book_id, deal_id, exch_rate, acquisation_date, comments, link_id, trans_id, seq_no) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: The column trans_id in table TransCapture_beta..fx_execution does not allow null values.