Hi, I tried to keep it readable, please give attention to the colored lines.
Thanks in advance for any help
regards
Bert Verhees
WARN [main] (JDBCExceptionReporter.java:71) - SQL Error: 1205, SQLState: 41000
ERROR [main] (JDBCExceptionReporter.java:72) - Lock wait timeout exceeded; try restarting transaction
ERROR [main] (AbstractFlushingEventListener.java:277) - Could not synchronize database state with session
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
The problem is that error below occurs, always first at this class, which is a complicated class, (going deep into other classes and properties.
- The error never occurs if I run the Junit test for this class alone (I tried to run it 100 times, without any error).
- It never occurs if I run it in a large serie of tests (about 50), and I write somekind of logging (debug-logging, or only sql-logging.
It only occurs if I run the tests without logging, and not the first time, but after some runs (mostly at the third run)
Another strange thing I saw: After running a test, the tables are still filled with data, it takes about 5 seconds before the database is to the actual state it should be. Maybe the problem is in this latency
I use InnoDB tables and I have transaction-isolation=SERIALIZABLE and innodb_lock_wait=50
The rest on MySQL innodb defaults.
If this error has occured, it is follwed by a serie of other errrors, al the same as this one:
Running zorggemak.dao.orm.openehr.rm.datatypes.uri.DvURIDaoTest
WARN [main] (JDBCExceptionReporter.java:71) - SQL Error: 1217, SQLState: 23000
ERROR [main] (JDBCExceptionReporter.java:72) - Cannot delete or update a parent row: a foreign key constraint fails
ERROR [main] (AbstractFlushingEventListener.java:277) - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
Hibernate version:
3.0.5
Mapping documents:
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="org.openehr.rm.common.archetyped.Locatable" abstract="true" table="locatable">
<id type="long" column="_id" name="_id">
<generator class="identity"/>
</id>
<many-to-one name="archetypeDetails" column="loc_archetype_details_id" cascade="all"/>
<property name="archetypeNodeId" column="loc_archetype_node_id_id" type="string"/>
<many-to-one name="feederAudit" column="loc_feeder_audit_id" cascade="all"/>
<set name="Links" lazy="false" cascade="all">
<key column="links_locatable_id"/>
<one-to-many class="org.openehr.rm.common.archetyped.Link"/>
</set>
<many-to-one name="name" column="loc_name_id" cascade="all"/>
<many-to-one name="parent" column="loc_parent_id" cascade="all"/>
<many-to-one name="uid" column="loc_uid_id" cascade="all"/>
<joined-subclass name="org.openehr.rm.composition.Composition" table="composition">
<key column="composition_id"/>
<many-to-one name="category" column="com_category_id" cascade="all"/>
<many-to-one name="composer" column="com_composer_id" cascade="all"/>
<list name="content" lazy="false" cascade="all">
<key column="content_composition_id"/>
<list-index column="position"/>
<one-to-many class="org.openehr.rm.composition.content.ContentItem"/>
</list>
<many-to-one name="context" column="com_context_id" cascade="all"/>
<many-to-one name="language" column="com_language_id" cascade="all"/>
<many-to-one name="territory" column="com_territory_id" cascade="all"/>
</joined-subclass>
.................
..................
Code between sessionFactory.openSession() and session.close():
Composition c = composition("1.2.840.113554.1.3.41");
//method which returns a Composition object
dao.beginTransaction();
public Session transactionSession
try{
transaction = transactionSession.beginTransaction();
return transaction;
}catch(Exception e){
closeSession();
throw e;
}
dao.save(c);
transactionSession.save(composition);
dao.commit();
try{
transaction.commit();
transactionSession.flush();
}catch(Exception e){
transaction.rollback();
throw e;
}finally{
transactionSession.close();
}
dao.beginTransaction();
dao.removeAll(Composition.class);
Query q = transactionSession.createQuery("from "+_class.getName());
for(Iterator it = q.list().iterator();it.hasNext();){
transactionSession.delete(it.next());
}
dao.commit();
The code in
olive is the code that is called from methods in black.
Please note that the method removeAll is on purpose less optimal, it first finds all obejcts and then deletes them (two tests in one), it never is a problem on the other 50 objects, so I do not expect it to be a problem here
Full stack trace of any exception that occurs:
Running zorggemak.dao.orm.openehr.rm.composition.CompositionDaoTest
WARN [main] (JDBCExceptionReporter.java:71) - SQL Error: 1205, SQLState: 41000
ERROR [main] (JDBCExceptionReporter.java:72) - Lock wait timeout exceeded; try restarting transaction
ERROR [main] (AbstractFlushingEventListener.java:277) - Could not synchronize database state with session
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:74)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:69)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:150)
at org.hibernate.persister.collection.AbstractCollectionPersister.remove(AbstractCollectionPersister.java:845)
at org.hibernate.action.CollectionRemoveAction.execute(CollectionRemoveAction.java:22)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:138)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at zorggemak.dao.orm.DaoSupportImpl.commit(DaoSupportImpl.java:27)
at zorggemak.dao.orm.openehr.rm.composition.CompositionDaoTest.testSave(CompositionDaoTest.java:34)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:210)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:135)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:122)
at org.apache.maven.surefire.Surefire.run(Surefire.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:225)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:747)
Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174)
... 40 more
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 52.906 sec <<< FAILURE!
Name and version of the database you are using:
MySQL 4.1.22
The generated SQL (show_sql=true):
This the working version, because the problem never occurs when logging is made.
Running zorggemak.dao.orm.openehr.rm.composition.CompositionDaoTest
Hibernate: insert into object_id (_value, class) values (?, 'ArchetypeID')
Hibernate: insert into archetyped (reference_model_version, archetype_id) values (?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, dummy, class) values (?, ?, ?, ?, 'PartyReference')
Hibernate: insert into party_proxy (external_ref_id, name, class) values (?, ?, 'PartyIdentified')
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, datetime, value, class) values (?, ?, ?, ?, ?, ?, ?, 'dv_datetime')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, dummy, class) values (?, ?, ?, ?, 'PartyReference')
Hibernate: insert into party_proxy (external_ref_id, name, class) values (?, ?, 'PartyIdentified')
Hibernate: insert into data_value (issuer, id_value, assigner, type, class) values (?, ?, ?, ?, 'DvIdentifier')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into item (item_id) values (?)
Hibernate: insert into element (ele_value_id, ele_null_flavor_id, element_id) values (?, ?, ?)
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into data_structure (data_structure_id) values (?)
Hibernate: insert into item_structure (item_representation_id, item_structure_id) values (?, ?)
Hibernate: insert into item_single (item_single_id) values (?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, datetime, value, class) values (?, ?, ?, ?, ?, ?, ?, 'dv_datetime')
Hibernate: insert into event_context (end_time_id, health_care_facility_id, location, other_context_id, setting_id, start_time_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, dummy, class) values (?, ?, ?, ?, 'PartyReference')
Hibernate: insert into party_proxy (external_ref_id, name, class) values (?, ?, 'PartyIdentified')
Hibernate: insert into data_value (issuer, id_value, assigner, type, class) values (?, ?, ?, ?, 'DvIdentifier')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into data_value (_interval, class) values (?, 'DvInterval')
Hibernate: insert into participation (performer_id, function_id, mode_id, time_id) values (?, ?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into composition (com_category_id, com_composer_id, com_context_id, com_language_id, com_territory_id, composition_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into data_value (value, class) values (?, 'DvEHRURI')
Hibernate: insert into link (meaning_id, type_id, target_id) values (?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into data_value (value, class) values (?, 'DvEHRURI')
Hibernate: insert into link (meaning_id, type_id, target_id) values (?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into data_value (value, class) values (?, 'DvEHRURI')
Hibernate: insert into link (meaning_id, type_id, target_id) values (?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into content_item (content_item_id) values (?)
Hibernate: insert into section (section_id) values (?)
Hibernate: insert into object_id (_value, class) values (?, 'ArchetypeID')
Hibernate: insert into archetyped (reference_model_version, archetype_id) values (?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, dummy, class) values (?, ?, ?, ?, 'PartyReference')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into party_proxy (external_ref_id, name, relationship_id, class) values (?, ?, ?, 'PartyRelated')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, dummy, class) values (?, ?, ?, ?, 'PartyReference')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into party_proxy (external_ref_id, name, relationship_id, class) values (?, ?, ?, 'PartyRelated')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, class) values (?, ?, ?, 'ObjectReference')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into item (item_id) values (?)
Hibernate: insert into element (ele_value_id, ele_null_flavor_id, element_id) values (?, ?, ?)
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into data_structure (data_structure_id) values (?)
Hibernate: insert into item_structure (item_representation_id, item_structure_id) values (?, ?)
Hibernate: insert into item_single (item_single_id) values (?)
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, datetime, value, class) values (?, ?, ?, ?, ?, ?, ?, 'dv_datetime')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into content_item (content_item_id) values (?)
Hibernate: insert into entry (ent_charset_id, ent_language_id, ent_provider_id, ent_subject_id, ent_workflow_id_id, entry_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into care_entry (car_guideline_id_id, car_protocol_id, care_entry_id) values (?, ?, ?)
Hibernate: insert into instruction (ins_expiry_time_id, ins_narrative_id, ins_wf_definition_id, instruction_id) values (?, ?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, dummy, class) values (?, ?, ?, ?, 'PartyReference')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into party_proxy (external_ref_id, name, relationship_id, class) values (?, ?, ?, 'PartyRelated')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into data_value (_interval, class) values (?, 'DvInterval')
Hibernate: insert into participation (performer_id, function_id, mode_id, time_id) values (?, ?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'ArchetypeID')
Hibernate: insert into archetyped (reference_model_version, archetype_id) values (?, ?)
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, dummy, class) values (?, ?, ?, ?, 'PartyReference')
Hibernate: insert into party_proxy (external_ref_id, name, class) values (?, ?, 'PartyIdentified')
Hibernate: insert into object_id (_value, class) values (?, 'HierarchicalObjectID')
Hibernate: insert into object_reference (id, type_string, namespace_string, dummy, class) values (?, ?, ?, ?, 'PartyReference')
Hibernate: insert into party_proxy (external_ref_id, class) values (?, 'PartySelf')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, value, class) values (?, ?, ?, ?, ?, ?, 'DvDuration')
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, datetime, value, class) values (?, ?, ?, ?, ?, ?, ?, 'dv_datetime')
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, value, class) values (?, ?, ?, ?, ?, ?, 'DvDuration')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into data_structure (data_structure_id) values (?)
Hibernate: insert into history (his_duration_id, his_origin_id, his_period_id, his_summary_id, history_id) values (?, ?, ?, ?, ?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into item (item_id) values (?)
Hibernate: insert into element (ele_value_id, ele_null_flavor_id, element_id) values (?, ?, ?)
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into data_structure (data_structure_id) values (?)
Hibernate: insert into item_structure (item_representation_id, item_structure_id) values (?, ?)
Hibernate: insert into item_single (item_single_id) values (?)
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, datetime, value, class) values (?, ?, ?, ?, ?, ?, ?, 'dv_datetime')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into event (eve_data_id, eve_parent_id, eve_state_id, eve_time_id, event_id) values (?, ?, ?, ?, ?)
Hibernate: insert into point_event (point_event_id) values (?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into item (item_id) values (?)
Hibernate: insert into element (ele_value_id, ele_null_flavor_id, element_id) values (?, ?, ?)
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into data_structure (data_structure_id) values (?)
Hibernate: insert into item_structure (item_representation_id, item_structure_id) values (?, ?)
Hibernate: insert into item_single (item_single_id) values (?)
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, datetime, value, class) values (?, ?, ?, ?, ?, ?, ?, 'dv_datetime')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into event (eve_data_id, eve_parent_id, eve_state_id, eve_time_id, event_id) values (?, ?, ?, ?, ?)
Hibernate: insert into point_event (point_event_id) values (?)
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, class) values (?, ?, ?, ?, ?, 'DvText')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into object_id (_value, class) values (?, 'TerminologyID')
Hibernate: insert into data_value (terminology_id, code_string, class) values (?, ?, 'CodePhrase')
Hibernate: insert into data_value (charset_id, formatting, hyperlink_id, language_id, value, defining_code_id, class) values (?, ?, ?, ?, ?, ?, 'DvCodedText')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into item (item_id) values (?)
Hibernate: insert into element (ele_value_id, ele_null_flavor_id, element_id) values (?, ?, ?)
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into data_structure (data_structure_id) values (?)
Hibernate: insert into item_structure (item_representation_id, item_structure_id) values (?, ?)
Hibernate: insert into item_single (item_single_id) values (?)
Hibernate: insert into data_value (normal_range_id, accuracyPercent, accuracy, magnitudeStatus, units, datetime, value, class) values (?, ?, ?, ?, ?, ?, ?, 'dv_datetime')
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into event (eve_data_id, eve_parent_id, eve_state_id, eve_time_id, event_id) values (?, ?, ?, ?, ?)
Hibernate: insert into point_event (point_event_id) values (?)
Hibernate: insert into locatable (loc_archetype_details_id, loc_archetype_node_id_id, loc_feeder_audit_id, loc_name_id, loc_parent_id, loc_uid_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into content_item (content_item_id) values (?)
Hibernate: insert into entry (ent_charset_id, ent_language_id, ent_provider_id, ent_subject_id, ent_workflow_id_id, entry_id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into care_entry (car_guideline_id_id, car_protocol_id, care_entry_id) values (?, ?, ?)
Hibernate: insert into observation (obs_data_id, obs_state_id, observation_id) values (?, ?, ?)
Hibernate: update data_value set party_identified_id=?, position=? where _id=?
Hibernate: update data_value set party_identified_id=?, position=? where _id=?
Hibernate: update link set links_locatable_id=? where _id=?
Hibernate: update link set links_locatable_id=? where _id=?
Hibernate: update link set links_locatable_id=? where _id=?
Hibernate: update event set events_history_id=?, position=? where event_id=?
Hibernate: update event set events_history_id=?, position=? where event_id=?
Hibernate: update event set events_history_id=?, position=? where event_id=?
Hibernate: update participation set event_context_id=?, position=? where _id=?
Hibernate: update content_item set content_composition_id=?, position=? where content_item_id=?
Hibernate: update content_item set items_section_id=?, position=? where content_item_id=?
Hibernate: update content_item set items_section_id=?, position=? where content_item_id=?
Hibernate: update participation set other_participations_entry_id=?, position=? where _id=?
Hibernate: update participation set event_context_id=null, position=null where event_context_id=?
Hibernate: update content_item set content_composition_id=null, position=null where content_composition_id=?
Hibernate: update content_item set items_section_id=null, position=null where items_section_id=?
Hibernate: update participation set other_participations_entry_id=null, position=null where other_participations_entry_id=?
Hibernate: update participation set event_context_id=?, position=? where _id=?
Hibernate: update content_item set content_composition_id=?, position=? where content_item_id=?
Hibernate: update content_item set items_section_id=?, position=? where content_item_id=?
Hibernate: update content_item set items_section_id=?, position=? where content_item_id=?
Hibernate: update participation set other_participations_entry_id=?, position=? where _id=?
Hibernate: select compositio0_.composition_id as column1_, compositio0_1_.loc_archetype_details_id as loc2_12_, compositio0_1_.loc_archetype_node_id_id as loc3_12_, compositio0_1_.loc_feeder_audit_id as loc4_12_, compositio0_1_.loc_name_id as loc5_12_, compositio0_1_.loc_parent_id as loc6_12_, compositio0_1_.loc_uid_id as loc7_12_, compositio0_.com_category_id as com2_16_, compositio0_.com_composer_id as com3_16_, compositio0_.com_context_id as com4_16_, compositio0_.com_language_id as com5_16_, compositio0_.com_territory_id as com6_16_ from composition compositio0_ inner join locatable compositio0_1_ on compositio0_.composition_id=compositio0_1_._id
Hibernate: select content0_.content_composition_id as content2_1_, content0_.content_item_id as content1_1_, content0_.position as position1_, content0_.content_item_id as column1_0_, content0_1_.loc_archetype_details_id as loc2_12_0_, content0_1_.loc_archetype_node_id_id as loc3_12_0_, content0_1_.loc_feeder_audit_id as loc4_12_0_, content0_1_.loc_name_id as loc5_12_0_, content0_1_.loc_parent_id as loc6_12_0_, content0_1_.loc_uid_id as loc7_12_0_, content0_3_.ent_charset_id as ent2_20_0_, content0_3_.ent_language_id as ent3_20_0_, content0_3_.ent_provider_id as ent4_20_0_, content0_3_.ent_subject_id as ent5_20_0_, content0_3_.ent_workflow_id_id as ent6_20_0_, content0_4_.adm_data_id as adm2_21_0_, content0_5_.car_guideline_id_id as car2_22_0_, content0_5_.car_protocol_id as car3_22_0_, content0_6_.act_description_id as act2_23_0_, content0_6_.act_instruction_details_id as act3_23_0_, content0_6_.act_ism_transition_id as act4_23_0_, content0_6_.act_time_id as act5_23_0_, content0_7_.eva_data_id as eva2_24_0_, content0_8_.ins_expiry_time_id as ins2_25_0_, content0_8_.ins_narrative_id as ins3_25_0_, content0_8_.ins_wf_definition_id as ins4_25_0_, content0_9_.obs_data_id as obs2_26_0_, content0_9_.obs_state_id as obs3_26_0_, case when content0_6_.action_id is not null then 11 when content0_7_.evaluation_id is not null then 12 when content0_8_.instruction_id is not null then 13 when content0_9_.observation_id is not null then 14 when content0_4_.admin_entry_id is not null then 9 when content0_5_.care_entry_id is not null then 10 when content0_2_.section_id is not null then 7 when content0_3_.entry_id is not null then 8 when content0_.content_item_id is not null then 6 end as clazz_0_ from content_item content0_ inner join locatable content0_1_ on content0_.content_item_id=content0_1_._id left outer join section content0_2_ on content0_.content_item_id=content0_2_.section_id left outer join entry content0_3_ on content0_.content_item_id=content0_3_.entry_id left outer join admin_entry content0_4_ on content0_.content_item_id=content0_4_.admin_entry_id left outer join care_entry content0_5_ on content0_.content_item_id=content0_5_.care_entry_id left outer join action content0_6_ on content0_.content_item_id=content0_6_.action_id left outer join evaluation content0_7_ on content0_.content_item_id=content0_7_.evaluation_id left outer join instruction content0_8_ on content0_.content_item_id=content0_8_.instruction_id left outer join observation content0_9_ on content0_.content_item_id=content0_9_.observation_id where content0_.content_composition_id=?
Hibernate: select items0_.items_section_id as items4_1_, items0_.content_item_id as content1_1_, items0_.position as position1_, items0_.content_item_id as column1_0_, items0_1_.loc_archetype_details_id as loc2_12_0_, items0_1_.loc_archetype_node_id_id as loc3_12_0_, items0_1_.loc_feeder_audit_id as loc4_12_0_, items0_1_.loc_name_id as loc5_12_0_, items0_1_.loc_parent_id as loc6_12_0_, items0_1_.loc_uid_id as loc7_12_0_, items0_3_.ent_charset_id as ent2_20_0_, items0_3_.ent_language_id as ent3_20_0_, items0_3_.ent_provider_id as ent4_20_0_, items0_3_.ent_subject_id as ent5_20_0_, items0_3_.ent_workflow_id_id as ent6_20_0_, items0_4_.adm_data_id as adm2_21_0_, items0_5_.car_guideline_id_id as car2_22_0_, items0_5_.car_protocol_id as car3_22_0_, items0_6_.act_description_id as act2_23_0_, items0_6_.act_instruction_details_id as act3_23_0_, items0_6_.act_ism_transition_id as act4_23_0_, items0_6_.act_time_id as act5_23_0_, items0_7_.eva_data_id as eva2_24_0_, items0_8_.ins_expiry_time_id as ins2_25_0_, items0_8_.ins_narrative_id as ins3_25_0_, items0_8_.ins_wf_definition_id as ins4_25_0_, items0_9_.obs_data_id as obs2_26_0_, items0_9_.obs_state_id as obs3_26_0_, case when items0_6_.action_id is not null then 11 when items0_7_.evaluation_id is not null then 12 when items0_8_.instruction_id is not null then 13 when items0_9_.observation_id is not null then 14 when items0_4_.admin_entry_id is not null then 9 when items0_5_.care_entry_id is not null then 10 when items0_2_.section_id is not null then 7 when items0_3_.entry_id is not null then 8 when items0_.content_item_id is not null then 6 end as clazz_0_ from content_item items0_ inner join locatable items0_1_ on items0_.content_item_id=items0_1_._id left outer join section items0_2_ on items0_.content_item_id=items0_2_.section_id left outer join entry items0_3_ on items0_.content_item_id=items0_3_.entry_id left outer join admin_entry items0_4_ on items0_.content_item_id=items0_4_.admin_entry_id left outer join care_entry items0_5_ on items0_.content_item_id=items0_5_.care_entry_id left outer join action items0_6_ on items0_.content_item_id=items0_6_.action_id left outer join evaluation items0_7_ on items0_.content_item_id=items0_7_.evaluation_id left outer join instruction items0_8_ on items0_.content_item_id=items0_8_.instruction_id left outer join observation items0_9_ on items0_.content_item_id=items0_9_.observation_id where items0_.items_section_id=?
Hibernate: select otherparti0_.other_participations_entry_id as other8_1_, otherparti0_._id as column1_1_, otherparti0_.position as position1_, otherparti0_._id as column1_0_, otherparti0_.performer_id as performer2_58_0_, otherparti0_.function_id as function3_58_0_, otherparti0_.mode_id as mode4_58_0_, otherparti0_.time_id as time5_58_0_ from participation otherparti0_ where otherparti0_.other_participations_entry_id=?
Hibernate: select links0_.links_locatable_id as links5_1_, links0_._id as column1_1_, links0_._id as column1_0_, links0_.meaning_id as meaning2_11_0_, links0_.type_id as type3_11_0_, links0_.target_id as target4_11_0_ from link links0_ where links0_.links_locatable_id=?
Hibernate: select activities0_.activities_instruction_id as activities4_1_, activities0_.activity_id as activity1_1_, activities0_.position as position1_, activities0_.activity_id as column1_0_, activities0_1_.loc_archetype_details_id as loc2_12_0_, activities0_1_.loc_archetype_node_id_id as loc3_12_0_, activities0_1_.loc_feeder_audit_id as loc4_12_0_, activities0_1_.loc_name_id as loc5_12_0_, activities0_1_.loc_parent_id as loc6_12_0_, activities0_1_.loc_uid_id as loc7_12_0_, activities0_.act_description_id as act2_13_0_, activities0_.act_timing_id as act3_13_0_ from activity activities0_ inner join locatable activities0_1_ on activities0_.activity_id=activities0_1_._id where activities0_.activities_instruction_id=?
Hibernate: select otherparti0_.other_participations_entry_id as other8_1_, otherparti0_._id as column1_1_, otherparti0_.position as position1_, otherparti0_._id as column1_0_, otherparti0_.performer_id as performer2_58_0_, otherparti0_.function_id as function3_58_0_, otherparti0_.mode_id as mode4_58_0_, otherparti0_.time_id as time5_58_0_ from participation otherparti0_ where otherparti0_.other_participations_entry_id=?
Hibernate: select links0_.links_locatable_id as links5_1_, links0_._id as column1_1_, links0_._id as column1_0_, links0_.meaning_id as meaning2_11_0_, links0_.type_id as type3_11_0_, links0_.target_id as target4_11_0_ from link links0_ where links0_.links_locatable_id=?
Hibernate: select links0_.links_locatable_id as links5_1_, links0_._id as column1_1_, links0_._id as column1_0_, links0_.meaning_id as meaning2_11_0_, links0_.type_id as type3_11_0_, links0_.target_id as target4_11_0_ from link links0_ where links0_.links_locatable_id=?
Hibernate: select links0_.links_locatable_id as links5_1_, links0_._id as column1_1_, links0_._id as column1_0_, links0_.meaning_id as meaning2_11_0_, links0_.type_id as type3_11_0_, links0_.target_id as target4_11_0_ from link links0_ where links0_.links_locatable_id=?
Hibernate: select dvtext0_._id as column1_0_, dvtext0_.charset_id as charset7_5_0_, dvtext0_.formatting as formatting5_0_, dvtext0_.hyperlink_id as hyperlink37_5_0_, dvtext0_.language_id as language6_5_0_, dvtext0_.value as value5_0_, dvtext0_.defining_code_id as defining38_5_0_, dvtext0_.class as class0_ from data_value dvtext0_ where dvtext0_._id=? and dvtext0_.class in ('DvText', 'DvCodedText')
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select dvtext0_._id as column1_0_, dvtext0_.charset_id as charset7_5_0_, dvtext0_.formatting as formatting5_0_, dvtext0_.hyperlink_id as hyperlink37_5_0_, dvtext0_.language_id as language6_5_0_, dvtext0_.value as value5_0_, dvtext0_.defining_code_id as defining38_5_0_, dvtext0_.class as class0_ from data_value dvtext0_ where dvtext0_._id=? and dvtext0_.class in ('DvText', 'DvCodedText')
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select dvehruri0_._id as column1_0_, dvehruri0_.value as value5_0_ from data_value dvehruri0_ where dvehruri0_._id=? and dvehruri0_.class='DvEHRURI'
Hibernate: select dvtext0_._id as column1_0_, dvtext0_.charset_id as charset7_5_0_, dvtext0_.formatting as formatting5_0_, dvtext0_.hyperlink_id as hyperlink37_5_0_, dvtext0_.language_id as language6_5_0_, dvtext0_.value as value5_0_, dvtext0_.defining_code_id as defining38_5_0_, dvtext0_.class as class0_ from data_value dvtext0_ where dvtext0_._id=? and dvtext0_.class in ('DvText', 'DvCodedText')
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select dvtext0_._id as column1_0_, dvtext0_.charset_id as charset7_5_0_, dvtext0_.formatting as formatting5_0_, dvtext0_.hyperlink_id as hyperlink37_5_0_, dvtext0_.language_id as language6_5_0_, dvtext0_.value as value5_0_, dvtext0_.defining_code_id as defining38_5_0_, dvtext0_.class as class0_ from data_value dvtext0_ where dvtext0_._id=? and dvtext0_.class in ('DvText', 'DvCodedText')
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select dvehruri0_._id as column1_0_, dvehruri0_.value as value5_0_ from data_value dvehruri0_ where dvehruri0_._id=? and dvehruri0_.class='DvEHRURI'
Hibernate: select dvtext0_._id as column1_0_, dvtext0_.charset_id as charset7_5_0_, dvtext0_.formatting as formatting5_0_, dvtext0_.hyperlink_id as hyperlink37_5_0_, dvtext0_.language_id as language6_5_0_, dvtext0_.value as value5_0_, dvtext0_.defining_code_id as defining38_5_0_, dvtext0_.class as class0_ from data_value dvtext0_ where dvtext0_._id=? and dvtext0_.class in ('DvText', 'DvCodedText')
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select dvtext0_._id as column1_0_, dvtext0_.charset_id as charset7_5_0_, dvtext0_.formatting as formatting5_0_, dvtext0_.hyperlink_id as hyperlink37_5_0_, dvtext0_.language_id as language6_5_0_, dvtext0_.value as value5_0_, dvtext0_.defining_code_id as defining38_5_0_, dvtext0_.class as class0_ from data_value dvtext0_ where dvtext0_._id=? and dvtext0_.class in ('DvText', 'DvCodedText')
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select codephrase0_._id as column1_0_, codephrase0_.terminology_id as terminol3_5_0_, codephrase0_.code_string as code4_5_0_ from data_value codephrase0_ where codephrase0_._id=? and codephrase0_.class='CodePhrase'
Hibernate: select terminolog0_._id as column1_0_, terminolog0_._value as column3_55_0_ from object_id terminolog0_ where terminolog0_._id=? and terminolog0_.class='TerminologyID'
Hibernate: select dvehruri0_._id as column1_0_, dvehruri0_.value as value5_0_ from data_value dvehruri0_ where dvehruri0_._id=? and dvehruri0_.class='DvEHRURI'
Hibernate: select mappings0_.dv_text_id as dv48_1_, mappings0_._id as column1_1_, mappings0_.position as position1_, mappings0_._id as column1_0_, mappings0_.target_id as target41_5_0_, mappings0_.match_ as match42_5_0_, mappings0_.purpose_id as purpose43_5_0_ from data_value mappings0_ where mappings0_.dv_text_id=?
Hibernate: select mappings0_.dv_text_id as dv48_1_, mappings0_._id as column1_1_, mappings0_.position as position1_, mappings0_._id as column1_0_, mappings0_.target_id as target41_5_0_, mappings0_.match_ as match42_5_0_, mappings0_.purpose_id as purpose43_5_0_ from data_value mappings0_ where mappings0_.dv_text_id=?
Hibernate: select mappings0_.dv_text_id as dv48_1_, mappings0_._id as column1_1_, mappings0_.position as position1_, mappings0_._id as column1_0_, mappings0_.target_id as target41_5_0_, mappings0_.match_ as match42_5_0_, mappings0_.purpose_id as purpose43_5_0_ from data_value mappings0_ where mappings0_.dv_text_id=?
Hibernate: select mappings0_.dv_text_id as dv48_1_, mappings0_._id as column1_1_, mappings0_.position as position1_, mappings0_._id as column1_0_, mappings0_.target_id as target41_5_0_, mappings0_.match_ as match42_5_0_, mappings0_.purpose_id as purpose43_
Login
FAQ
Search
