Hi
I have a complex application where a sequence of database insert/updates would be triggered by one request. For example, I have the following hbm mappings:
1. ServiceDescription
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="uk.org.mygrid.infomodel.ServiceDescription" table="servicedescription">
<id name="LSID" type="java.lang.String" column="service_id" length="80">
<generator class="assigned"/>
</id>
<property name="serviceName" type="java.lang.String" column="name" length="60" not-null="true"/>
<property name="interfaceWSDL" type="java.lang.String" column="wsdlURL" length="255" not-null="true"/>
<property name="author" type="java.lang.String" column="author" length="50"/>
<property name="locationURL" type="java.lang.String" column="endpoint" length="80"/>
<property name="serviceDescriptionText" type="java.lang.String" column="description" length="80"/>
<property name="metadataLSID" type="java.lang.String" column="metadataLSID" length="80"/>
<!-- associations -->
<!-- bi-directional one-to-many association to Wsporttype -->
<array name="operation" cascade="all">
<key>
<column name="service_id"/>
</key>
<index column="service_ind"/>
<one-to-many class="uk.org.mygrid.infomodel.Operation"/>
</array>
</class>
</hibernate-mapping>
2. Operation
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="uk.org.mygrid.infomodel.Operation" table="operation">
<id name="LSID" type="java.lang.String" column="operation_id" length="80">
<generator class="assigned"/>
</id>
<property name="operationName" type="java.lang.String" column="name" length="20" not-null="true"/>
<property name="portName" type="java.lang.String" column="port" length="30"/>
<property name="operationDescriptionText" type="java.lang.String" column="decription" length="255"/>
<property name="operationTask" type="java.lang.String" column="task" length="50"/>
<property name="operationResource" type="java.lang.String" column="resource" length="50"/>
<property name="operationMethod" type="java.lang.String" column="method" length="50"/>
<property name="operationApplication" type="java.lang.String" column="application" length="50"/>
<property name="metadataLSID" type="java.lang.String" column="metadataLSID" length="80"/>
<!-- associations -->
<!-- one-to-many association to Formalinputparameter -->
<array name="formalinputparameter" cascade="all">
<key>
<column name="operation_id"/>
</key>
<index column="operation_ind"/>
<one-to-many class="uk.org.mygrid.infomodel.FormalInputParameter"/>
</array>
<!-- one-to-many association to Formaloutputparameter -->
<array name="formaloutputparameter" cascade="all">
<key>
<column name="operation_id"/>
</key>
<index column="operation_ind"/>
<one-to-many class="uk.org.mygrid.infomodel.FormalInputParameter"/>
</array>
<!-- bi-directional one-to-one association to OperationContent -->
<one-to-one name="content" class="uk.org.mygrid.infomodel.OperationContent" property-ref="operation" cascade="all"/>
<!-- many-to-one association to Operationtype -->
<many-to-one name="operationtype" class="uk.org.mygrid.infomodel.OperationType" cascade="all">
<column name="operationtype_id"/>
</many-to-one>
</class>
</hibernate-mapping>
3. FormalInputParameter
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="uk.org.mygrid.infomodel.FormalInputParameter" table="formalinputparameter">
<id name="LSID" type="java.lang.String" column="formalinputparameter_id" length="80">
<generator class="assigned"/>
</id>
<property name="parameterName" type="java.lang.String" column="name" length="30"/>
<property name="messageName" type="java.lang.String" column="message" length="100"/>
<property name="parameterDescription" type="java.lang.String" column="description" length="50"/>
<property name="defaultValue" type="java.lang.String" column="defaultValue"/>
<property name="isConfigurationParameter" type="java.lang.Boolean" column="isConfig" length="6"/>
<property name="metadataLSID" type="java.lang.String" column="metadataLSID" length="80"/>
<!-- associations -->
<!-- many-to-one association to DataType -->
<many-to-one name="datatype" class="uk.org.mygrid.infomodel.DataType">
<column name="datatype_id"/>
</many-to-one>
</class>
</hibernate-mapping>
4. FormalOutputParameter
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="uk.org.mygrid.infomodel.FormalOutputParameter" table="formaloutputparameter">
<id name="LSID" type="java.lang.String" column="formaloutputparameter_id" length="80">
<generator class="assigned"/>
</id>
<property name="parameterName" type="java.lang.String" column="name" length="30"/>
<property name="messageName" type="java.lang.String" column="message" length="30"/>
<property name="parameterDescription" type="java.lang.String" column="description" length="50"/>
<property name="metadataLSID" type="java.lang.String" column="metadataLSID" length="80"/>
<!-- associations -->
<!-- many-to-one association to DataType -->
<many-to-one name="datatype" class="uk.org.mygrid.infomodel.DataType">
<column name="datatype_id"/>
</many-to-one>
</class>
</hibernate-mapping>
5. DataType
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="uk.org.mygrid.infomodel.DataType" table="datatype">
<id name="LSID" type="java.lang.String" column="datatype_id" length="80">
<generator class="assigned"/>
</id>
<property name="semanticType" type="java.lang.String" column="semanticType" length="30"/>
<property name="XMLSchemaTypeName" type="java.lang.String" column="XMLSchemaTypeName"/>
<property name="XMLSchemaURI" type="java.lang.String" column="XMLSchemaURI"/>
<property name="collectionFormat" type="java.lang.String" column="collectionFormat" length="30"/>
<property name="collectionSemanticType" type="java.lang.String" column="collectionSemanticType" length="30"/>
<!-- associations -->
<!-- one-to-many association to Format -->
<array name="format" cascade="all">
<key>
<column name="datatype_id"/>
</key>
<index column="datatype_ind"/>
<one-to-many class="uk.org.mygrid.infomodel.Format"/>
</array>
</class>
</hibernate-mapping>
6. OperationType
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="uk.org.mygrid.infomodel.OperationType" table="operationtype">
<id name="LSID" type="java.lang.String" column="operationtype_id" length="80">
<generator class="assigned"/>
</id>
<property name="typeName" type="java.lang.String" column="typeName" length="30"/>
</class>
</hibernate-mapping>
In short, a ServiceDescription can have 1 or more Operations. Each Operation can have 1 or more FormalInputParameter and 1 or more FormalOutputParameter (this will later be 1 to 1). Each Formal input/output parameter can have one DataType. Each Operation can have one OperationType.
Now, I am trying to implement one-way relations, like ServiceDescription -> Operation; Operation -> FormalInputParameter/FormalOutputParameter; Operation -> OperationType (though this is many-to-1); FormalInputParameter/FormalOutputParameter -> DataType and so on. The client will submit one request (in form of an XML document) which will contain all the data in it - and everything will be stored in order. Like, while adding ServiceDescription, the code will try to add Operations, where it will first try to add the input/output parameters within which it will try to add the DataType...The twist is during addition of a DataType or OperationType. Because these two have 1-to-many mapping with input/output parameter and Operation respectively, when OperationType.add is called, first it checks whether anything matching with the requested value exists or not - if it does, that is loaded and associated with the parent; for example if the OperationType.name for Operation A is WSDL, then while adding A, the store is searched for the existence of WSDL. If that is found, A is associated with the existing WSDL, otherwise a new OperationType is created...
But, I am getting weird exceptions - following is the log with DEBUG enabled. I could have sent the code, but then the message would be too big...
Code:
[java] 23:19:29,649 DEBUG OperationMgr:44 - Entering OperationMgr:add
[java] Creating operations...
[java] 23:19:29,649 DEBUG OperationMgr:113 - Entering OperationMgr:associateFormalInputParams
[java] 23:19:29,649 DEBUG FormalInputParameterMgr:33 - Entering FormalInputParameterMgr:add
[java] 23:19:29,649 DEBUG FormalInputParameterMgr:86 - Entering FormalInputParameterMgr:associateDataType
[java] 23:19:29,696 DEBUG DataAccess:75 - Creating object of type FormalInputParameter
[java] 23:19:29,930 DEBUG MyGridLSIDDataService:152 - Assgined LSID: urn:lsid:mygrid.org.uk:formalinputparameter:39d7ccdb80f094ea00e99681b67fcddf
[java] 23:19:29,930 DEBUG SessionImpl:807 - saving [uk.org.mygrid.infomodel.FormalInputParameter#urn:lsid:mygrid.org.uk:formalinputparameter:39d7
ccdb80f094ea00e99681b67fcddf]
[java] 23:19:29,946 DEBUG OperationMgr:136 - Entering OperationMgr:associateFormalOutputParams
[java] 23:19:29,946 DEBUG FormalOutputParameterMgr:32 - Entering FormalInputParameterMgr:add
[java] 23:19:29,946 DEBUG FormalOutputParameterMgr:85 - Entering FormalInputParameterMgr:associateDataType
[java] 23:19:29,946 DEBUG DataAccess:75 - Creating object of type FormalOutputParameter
[java] 23:19:29,946 DEBUG MyGridLSIDDataService:152 - Assgined LSID: urn:lsid:mygrid.org.uk:formaloutputparameter:39d7cd1a80f094ea0082796862bf261
b
[java] 23:19:29,946 DEBUG SessionImpl:807 - saving [uk.org.mygrid.infomodel.FormalOutputParameter#urn:lsid:mygrid.org.uk:formaloutputparameter:39
d7cd1a80f094ea0082796862bf261b]
[java] 23:19:29,946 DEBUG OperationMgr:186 - Entering OperationMgr:createOperationType
[java] 23:19:29,961 DEBUG OperationMgr:204 - Searching optype table for type WSDL_OPERATION
[java] 23:19:29,961 DEBUG OperationTypeMgr:75 - Entering OperationTypeMgr:getByQuery
[java] 23:19:30,008 DEBUG SessionImpl:1497 - find: from OperationType as retType where retType.typeName = ?
[java] 23:19:30,024 DEBUG QueryParameters:105 - parameters: [WSDL_OPERATION]
[java] 23:19:30,040 DEBUG QueryTranslator:147 - compiling query
[java] 23:19:30,071 DEBUG SessionImpl:2210 - flushing session
[java] 23:19:30,086 DEBUG SessionImpl:2403 - Flushing entities and processing referenced collections
[java] 23:19:30,086 DEBUG SessionImpl:2746 - Processing unreferenced collections
[java] 23:19:30,086 DEBUG SessionImpl:2760 - Scheduling collection removes/(re)creates/updates
[java] 23:19:30,102 DEBUG SessionImpl:2234 - Flushed: 2 insertions, 0 updates, 0 deletions to 2 objects
[java] 23:19:30,118 DEBUG SessionImpl:2239 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
[java] 23:19:30,118 DEBUG Printer:75 - listing entities:
[java] 23:19:30,118 DEBUG Printer:82 - uk.org.mygrid.infomodel.FormalOutputParameter{parameterDescription=null, messageName=null, LSID=urn:lsid:m
ygrid.org.uk:formaloutputparameter:39d7cd1a80f094ea0082796862bf261b, metadataLSID=null, datatype=null, parameterName=MIRStoreEntityResponse}
[java] 23:19:30,165 DEBUG Printer:82 - uk.org.mygrid.infomodel.FormalInputParameter{parameterDescription=null, messageName={http://mygrid.org.uk/
2004/MIR}StoreMIREntityRequest, LSID=urn:lsid:mygrid.org.uk:formalinputparameter:39d7ccdb80f094ea00e99681b67fcddf, defaultValue=null, metadataLSID=nul
l, isConfigurationParameter=null, datatype=null, parameterName=MIRStoreEntityRequest}
[java] 23:19:30,165 DEBUG SessionImpl:1782 - Dont need to execute flush
[java] 23:19:30,165 DEBUG QueryTranslator:199 - HQL: from uk.org.mygrid.infomodel.OperationType as retType where retType.typeName = ?
[java] 23:19:30,211 DEBUG QueryTranslator:200 - SQL: select operationt0_.operationtype_id as operatio1_, operationt0_.typeName as typeName from o
perationtype operationt0_ where (operationt0_.typeName=? )
[java] 23:19:30,211 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:30,211 DEBUG SQL:237 - select operationt0_.operationtype_id as operatio1_, operationt0_.typeName as typeName from operationtype oper
ationt0_ where (operationt0_.typeName=? )
[java] 23:19:30,211 DEBUG BatcherImpl:241 - preparing statement
[java] 23:19:30,274 DEBUG StringType:46 - binding 'WSDL_OPERATION' to parameter: 1
[java] 23:19:30,274 DEBUG Loader:197 - processing result set
[java] 23:19:30,274 DEBUG Loader:226 - done processing result set (0 rows)
[java] 23:19:30,274 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:30,274 DEBUG BatcherImpl:261 - closing statement
[java] 23:19:30,274 DEBUG Loader:239 - total objects hydrated: 0
[java] 23:19:30,274 DEBUG SessionImpl:3082 - initializing non-lazy collections
[java] 23:19:30,274 DEBUG OperationTypeMgr:31 - Entering OperationTypeMgr:add
[java] 23:19:30,321 DEBUG DataAccess:75 - Creating object of type OperationType
[java] 23:19:30,321 DEBUG MyGridLSIDDataService:152 - Assgined LSID: urn:lsid:mygrid.org.uk:operationtype:39d7ce9180f094ea01546dbc9694b6d7
[java] 23:19:30,321 DEBUG SessionImpl:807 - saving [uk.org.mygrid.infomodel.OperationType#urn:lsid:mygrid.org.uk:operationtype:39d7ce9180f094ea01
546dbc9694b6d7]
[java] 23:19:30,336 DEBUG DataAccess:75 - Creating object of type Operation
[java] 23:19:30,336 DEBUG MyGridLSIDDataService:152 - Assgined LSID: urn:lsid:mygrid.org.uk:operation:39d7cea080f094ea00322bcee6d11e2f
[java] 23:19:30,383 DEBUG SessionImpl:807 - saving [uk.org.mygrid.infomodel.Operation#urn:lsid:mygrid.org.uk:operation:39d7cea080f094ea00322bcee6
d11e2f]
[java] 23:19:30,383 DEBUG Cascades:497 - processing cascades for: uk.org.mygrid.infomodel.Operation
[java] 23:19:30,383 DEBUG Cascades:113 - cascading to saveOrUpdate()
[java] 23:19:30,383 DEBUG SessionImpl:1343 - saveOrUpdate() persistent instance
[java] 23:19:30,383 DEBUG Cascades:506 - done processing cascades for: uk.org.mygrid.infomodel.Operation
[java] 23:19:30,383 DEBUG Cascades:497 - processing cascades for: uk.org.mygrid.infomodel.Operation
[java] 23:19:30,430 DEBUG Cascades:524 - cascading to collection: uk.org.mygrid.infomodel.Operation.formalinputparameter
[java] 23:19:30,430 DEBUG Cascades:113 - cascading to saveOrUpdate()
[java] 23:19:30,446 DEBUG SessionImpl:1343 - saveOrUpdate() persistent instance
[java] 23:19:30,446 DEBUG Cascades:524 - cascading to collection: uk.org.mygrid.infomodel.Operation.formaloutputparameter
[java] 23:19:30,446 DEBUG Cascades:113 - cascading to saveOrUpdate()
[java] 23:19:30,446 DEBUG SessionImpl:1343 - saveOrUpdate() persistent instance
[java] 23:19:30,446 DEBUG Cascades:506 - done processing cascades for: uk.org.mygrid.infomodel.Operation
[java] 23:19:30,493 DEBUG OperationMgr:161 - Entering OperationMgr:associateContent
[java] 23:19:30,493 INFO OperationMgr:163 - Null content
[java] 23:19:30,493 DEBUG OperationMgr:44 - Entering OperationMgr:add
[java] Creating operations...
[java] 23:19:30,493 DEBUG OperationMgr:113 - Entering OperationMgr:associateFormalInputParams
[java] 23:19:30,493 DEBUG FormalInputParameterMgr:33 - Entering FormalInputParameterMgr:add
[java] 23:19:30,493 DEBUG FormalInputParameterMgr:86 - Entering FormalInputParameterMgr:associateDataType
[java] 23:19:30,493 DEBUG DataAccess:75 - Creating object of type FormalInputParameter
[java] 23:19:30,540 DEBUG MyGridLSIDDataService:152 - Assgined LSID: urn:lsid:mygrid.org.uk:formalinputparameter:39d7cf6c80f094ea01a5db4b518bd558
[java] 23:19:30,540 DEBUG SessionImpl:807 - saving [uk.org.mygrid.infomodel.FormalInputParameter#urn:lsid:mygrid.org.uk:formalinputparameter:39d7
cf6c80f094ea01a5db4b518bd558]
[java] 23:19:30,540 DEBUG OperationMgr:136 - Entering OperationMgr:associateFormalOutputParams
[java] 23:19:30,540 DEBUG FormalOutputParameterMgr:32 - Entering FormalInputParameterMgr:add
[java] 23:19:30,540 DEBUG FormalOutputParameterMgr:85 - Entering FormalInputParameterMgr:associateDataType
[java] 23:19:30,618 DEBUG DataAccess:75 - Creating object of type FormalOutputParameter
[java] 23:19:30,618 DEBUG MyGridLSIDDataService:152 - Assgined LSID: urn:lsid:mygrid.org.uk:formaloutputparameter:39d7cfba80f094ea01f0aeccf570033
9
[java] 23:19:30,618 DEBUG SessionImpl:807 - saving [uk.org.mygrid.infomodel.FormalOutputParameter#urn:lsid:mygrid.org.uk:formaloutputparameter:39
d7cfba80f094ea01f0aeccf5700339]
[java] 23:19:30,618 DEBUG OperationMgr:186 - Entering OperationMgr:createOperationType
[java] 23:19:30,618 DEBUG OperationMgr:204 - Searching optype table for type WSDL_OPERATION
[java] 23:19:30,665 DEBUG OperationTypeMgr:75 - Entering OperationTypeMgr:getByQuery
[java] 23:19:30,665 DEBUG SessionImpl:1497 - find: from OperationType as retType where retType.typeName = ?
[java] 23:19:30,665 DEBUG QueryParameters:105 - parameters: [WSDL_OPERATION]
[java] 23:19:30,665 DEBUG QueryTranslator:147 - compiling query
[java] 23:19:30,665 DEBUG SessionImpl:2210 - flushing session
[java] 23:19:30,665 DEBUG Cascades:497 - processing cascades for: uk.org.mygrid.infomodel.Operation
[java] 23:19:30,680 DEBUG Cascades:524 - cascading to collection: uk.org.mygrid.infomodel.Operation.formalinputparameter
[java] 23:19:30,711 DEBUG Cascades:113 - cascading to saveOrUpdate()
[java] 23:19:30,711 DEBUG SessionImpl:1343 - saveOrUpdate() persistent instance
[java] 23:19:30,711 DEBUG Cascades:524 - cascading to collection: uk.org.mygrid.infomodel.Operation.formaloutputparameter
[java] 23:19:30,727 DEBUG Cascades:113 - cascading to saveOrUpdate()
[java] 23:19:30,727 DEBUG SessionImpl:1343 - saveOrUpdate() persistent instance
[java] 23:19:30,727 DEBUG Cascades:113 - cascading to saveOrUpdate()
[java] 23:19:30,727 DEBUG SessionImpl:1343 - saveOrUpdate() persistent instance
[java] 23:19:30,774 DEBUG Cascades:506 - done processing cascades for: uk.org.mygrid.infomodel.Operation
[java] 23:19:30,774 DEBUG SessionImpl:2403 - Flushing entities and processing referenced collections
[java] 23:19:30,805 DEBUG SessionImpl:2850 - Collection found: [uk.org.mygrid.infomodel.Operation.formalinputparameter#urn:lsid:mygrid.org.uk:ope
ration:39d7cea080f094ea00322bcee6d11e2f], was: [<unreferenced>]
[java] 23:19:30,805 DEBUG SessionImpl:2850 - Collection found: [uk.org.mygrid.infomodel.Operation.formaloutputparameter#urn:lsid:mygrid.org.uk:op
eration:39d7cea080f094ea00322bcee6d11e2f], was: [<unreferenced>]
[java] 23:19:30,821 DEBUG SessionImpl:2746 - Processing unreferenced collections
[java] 23:19:30,821 DEBUG SessionImpl:2760 - Scheduling collection removes/(re)creates/updates
[java] 23:19:30,836 DEBUG SessionImpl:2234 - Flushed: 6 insertions, 0 updates, 0 deletions to 6 objects
[java] 23:19:30,836 DEBUG SessionImpl:2239 - Flushed: 2 (re)creations, 0 updates, 0 removals to 2 collections
[java] 23:19:30,836 DEBUG Printer:75 - listing entities:
[java] 23:19:30,836 DEBUG Printer:82 - uk.org.mygrid.infomodel.Operation{portName=MIRAccessService, LSID=urn:lsid:mygrid.org.uk:operation:39d7cea
080f094ea00322bcee6d11e2f, operationName=storeMIREntity, operationApplication=null, content=null, formaloutputparameter=[FormalOutputParameter#urn:lsi
d:mygrid.org.uk:formaloutputparameter:39d7cd1a80f094ea0082796862bf261b], operationMethod=null, metadataLSID=null, formalinputparameter=[FormalInputPar
ameter#urn:lsid:mygrid.org.uk:formalinputparameter:39d7ccdb80f094ea00e99681b67fcddf], operationDescriptionText=null, operationtype=OperationType#urn:l
sid:mygrid.org.uk:operationtype:39d7ce9180f094ea01546dbc9694b6d7, operationTask=null, operationResource=null}
[java] 23:19:30,883 DEBUG Printer:82 - uk.org.mygrid.infomodel.FormalOutputParameter{parameterDescription=null, messageName=null, LSID=urn:lsid:m
ygrid.org.uk:formaloutputparameter:39d7cfba80f094ea01f0aeccf5700339, metadataLSID=null, datatype=null, parameterName=MIRGetEntityResponse}
[java] 23:19:30,899 DEBUG Printer:82 - uk.org.mygrid.infomodel.FormalOutputParameter{parameterDescription=null, messageName=null, LSID=urn:lsid:m
ygrid.org.uk:formaloutputparameter:39d7cd1a80f094ea0082796862bf261b, metadataLSID=null, datatype=null, parameterName=MIRStoreEntityResponse}
[java] 23:19:30,977 DEBUG Printer:82 - uk.org.mygrid.infomodel.FormalInputParameter{parameterDescription=null, messageName={http://mygrid.org.uk/
2004/MIR}StoreMIREntityRequest, LSID=urn:lsid:mygrid.org.uk:formalinputparameter:39d7ccdb80f094ea00e99681b67fcddf, defaultValue=null, metadataLSID=nul
l, isConfigurationParameter=null, datatype=null, parameterName=MIRStoreEntityRequest}
[java] 23:19:30,977 DEBUG Printer:82 - uk.org.mygrid.infomodel.FormalInputParameter{parameterDescription=null, messageName={http://mygrid.org.uk/
2004/MIR}GetMIREntityRequest, LSID=urn:lsid:mygrid.org.uk:formalinputparameter:39d7cf6c80f094ea01a5db4b518bd558, defaultValue=null, metadataLSID=null,
isConfigurationParameter=null, datatype=null, parameterName=MIRGetEntityRequest}
[java] 23:19:31,008 DEBUG Printer:82 - uk.org.mygrid.infomodel.OperationType{typeName=WSDL_OPERATION, LSID=urn:lsid:mygrid.org.uk:operationtype:3
9d7ce9180f094ea01546dbc9694b6d7}
[java] 23:19:31,008 DEBUG SessionImpl:2264 - changes must be flushed to space: operationtype
[java] 23:19:31,008 DEBUG SessionImpl:1773 - Need to execute flush
[java] 23:19:31,008 DEBUG SessionImpl:2323 - executing flush
[java] 23:19:31,024 DEBUG EntityPersister:453 - Inserting entity: [uk.org.mygrid.infomodel.FormalInputParameter#urn:lsid:mygrid.org.uk:formalinpu
tparameter:39d7ccdb80f094ea00e99681b67fcddf]
[java] 23:19:31,071 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,071 DEBUG SQL:237 - insert into formalinputparameter (name, message, description, defaultValue, isConfig, metadataLSID, datatype_
id, formalinputparameter_id) values (?, ?, ?, ?, ?, ?, ?, ?)
[java] 23:19:31,071 DEBUG BatcherImpl:241 - preparing statement
[java] 23:19:31,071 DEBUG EntityPersister:388 - Dehydrating entity: [uk.org.mygrid.infomodel.FormalInputParameter#urn:lsid:mygrid.org.uk:formalin
putparameter:39d7ccdb80f094ea00e99681b67fcddf]
[java] 23:19:31,133 DEBUG StringType:46 - binding 'MIRStoreEntityRequest' to parameter: 1
[java] 23:19:31,133 DEBUG StringType:46 - binding '{http://mygrid.org.uk/2004/MIR}StoreMIREntityRequest' to parameter: 2
[java] 23:19:31,133 DEBUG StringType:41 - binding null to parameter: 3
[java] 23:19:31,133 DEBUG StringType:41 - binding null to parameter: 4
[java] 23:19:31,133 DEBUG BooleanType:41 - binding null to parameter: 5
[java] 23:19:31,133 DEBUG StringType:41 - binding null to parameter: 6
[java] 23:19:31,133 DEBUG StringType:41 - binding null to parameter: 7
[java] 23:19:31,180 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:formalinputparameter:39d7ccdb80f094ea00e99681b67fcddf' to parameter: 8
[java] 23:19:31,180 DEBUG BatcherImpl:28 - Adding to batch
[java] 23:19:31,180 DEBUG EntityPersister:453 - Inserting entity: [uk.org.mygrid.infomodel.FormalOutputParameter#urn:lsid:mygrid.org.uk:formalout
putparameter:39d7cd1a80f094ea0082796862bf261b]
[java] 23:19:31,180 DEBUG BatcherImpl:50 - Executing batch size: 1
[java] 23:19:31,336 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,336 DEBUG BatcherImpl:261 - closing statement
[java] 23:19:31,352 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,352 DEBUG SQL:237 - insert into formaloutputparameter (name, message, description, metadataLSID, datatype_id, formaloutputparamet
er_id) values (?, ?, ?, ?, ?, ?)
[java] 23:19:31,352 DEBUG BatcherImpl:241 - preparing statement
[java] 23:19:31,352 DEBUG EntityPersister:388 - Dehydrating entity: [uk.org.mygrid.infomodel.FormalOutputParameter#urn:lsid:mygrid.org.uk:formalo
utputparameter:39d7cd1a80f094ea0082796862bf261b]
[java] 23:19:31,352 DEBUG StringType:46 - binding 'MIRStoreEntityResponse' to parameter: 1
[java] 23:19:31,352 DEBUG StringType:41 - binding null to parameter: 2
[java] 23:19:31,352 DEBUG StringType:41 - binding null to parameter: 3
[java] 23:19:31,352 DEBUG StringType:41 - binding null to parameter: 4
[java] 23:19:31,352 DEBUG StringType:41 - binding null to parameter: 5
[java] 23:19:31,352 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:formaloutputparameter:39d7cd1a80f094ea0082796862bf261b' to parameter: 6
[java] 23:19:31,368 DEBUG BatcherImpl:28 - Adding to batch
[java] 23:19:31,415 DEBUG EntityPersister:453 - Inserting entity: [uk.org.mygrid.infomodel.OperationType#urn:lsid:mygrid.org.uk:operationtype:39d
7ce9180f094ea01546dbc9694b6d7]
[java] 23:19:31,415 DEBUG BatcherImpl:50 - Executing batch size: 1
[java] 23:19:31,415 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,415 DEBUG BatcherImpl:261 - closing statement
[java] 23:19:31,415 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,415 DEBUG SQL:237 - insert into operationtype (typeName, operationtype_id) values (?, ?)
[java] 23:19:31,461 DEBUG BatcherImpl:241 - preparing statement
[java] 23:19:31,461 DEBUG EntityPersister:388 - Dehydrating entity: [uk.org.mygrid.infomodel.OperationType#urn:lsid:mygrid.org.uk:operationtype:3
9d7ce9180f094ea01546dbc9694b6d7]
[java] 23:19:31,477 DEBUG StringType:46 - binding 'WSDL_OPERATION' to parameter: 1
[java] 23:19:31,477 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:operationtype:39d7ce9180f094ea01546dbc9694b6d7' to parameter: 2
[java] 23:19:31,477 DEBUG BatcherImpl:28 - Adding to batch
[java] 23:19:31,477 DEBUG EntityPersister:453 - Inserting entity: [uk.org.mygrid.infomodel.Operation#urn:lsid:mygrid.org.uk:operation:39d7cea080f
094ea00322bcee6d11e2f]
[java] 23:19:31,524 DEBUG BatcherImpl:50 - Executing batch size: 1
[java] 23:19:31,524 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,524 DEBUG BatcherImpl:261 - closing statement
[java] 23:19:31,524 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,524 DEBUG SQL:237 - insert into operation (name, port, decription, task, resource, method, application, metadataLSID, operationty
pe_id, operation_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[java] 23:19:31,524 DEBUG BatcherImpl:241 - preparing statement
[java] 23:19:31,586 DEBUG EntityPersister:388 - Dehydrating entity: [uk.org.mygrid.infomodel.Operation#urn:lsid:mygrid.org.uk:operation:39d7cea08
0f094ea00322bcee6d11e2f]
[java] 23:19:31,586 DEBUG StringType:46 - binding 'storeMIREntity' to parameter: 1
[java] 23:19:31,586 DEBUG StringType:46 - binding 'MIRAccessService' to parameter: 2
[java] 23:19:31,586 DEBUG StringType:41 - binding null to parameter: 3
[java] 23:19:31,586 DEBUG StringType:41 - binding null to parameter: 4
[java] 23:19:31,586 DEBUG StringType:41 - binding null to parameter: 5
[java] 23:19:31,649 DEBUG StringType:41 - binding null to parameter: 6
[java] 23:19:31,649 DEBUG StringType:41 - binding null to parameter: 7
[java] 23:19:31,649 DEBUG StringType:41 - binding null to parameter: 8
[java] 23:19:31,649 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:operationtype:39d7ce9180f094ea01546dbc9694b6d7' to parameter: 9
[java] 23:19:31,649 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:operation:39d7cea080f094ea00322bcee6d11e2f' to parameter: 10
[java] 23:19:31,649 DEBUG BatcherImpl:28 - Adding to batch
[java] 23:19:31,649 DEBUG EntityPersister:453 - Inserting entity: [uk.org.mygrid.infomodel.FormalInputParameter#urn:lsid:mygrid.org.uk:formalinpu
tparameter:39d7cf6c80f094ea01a5db4b518bd558]
[java] 23:19:31,696 DEBUG BatcherImpl:50 - Executing batch size: 1
[java] 23:19:31,696 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,711 DEBUG BatcherImpl:261 - closing statement
[java] 23:19:31,711 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,711 DEBUG SQL:237 - insert into formalinputparameter (name, message, description, defaultValue, isConfig, metadataLSID, datatype_
id, formalinputparameter_id) values (?, ?, ?, ?, ?, ?, ?, ?)
[java] 23:19:31,711 DEBUG BatcherImpl:241 - preparing statement
[java] 23:19:31,758 DEBUG EntityPersister:388 - Dehydrating entity: [uk.org.mygrid.infomodel.FormalInputParameter#urn:lsid:mygrid.org.uk:formalin
putparameter:39d7cf6c80f094ea01a5db4b518bd558]
[java] 23:19:31,758 DEBUG StringType:46 - binding 'MIRGetEntityRequest' to parameter: 1
[java] 23:19:31,758 DEBUG StringType:46 - binding '{http://mygrid.org.uk/2004/MIR}GetMIREntityRequest' to parameter: 2
[java] 23:19:31,758 DEBUG StringType:41 - binding null to parameter: 3
[java] 23:19:31,758 DEBUG StringType:41 - binding null to parameter: 4
[java] 23:19:31,758 DEBUG BooleanType:41 - binding null to parameter: 5
[java] 23:19:31,821 DEBUG StringType:41 - binding null to parameter: 6
[java] 23:19:31,821 DEBUG StringType:41 - binding null to parameter: 7
[java] 23:19:31,821 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:formalinputparameter:39d7cf6c80f094ea01a5db4b518bd558' to parameter: 8
[java] 23:19:31,821 DEBUG BatcherImpl:28 - Adding to batch
[java] 23:19:31,821 DEBUG EntityPersister:453 - Inserting entity: [uk.org.mygrid.infomodel.FormalOutputParameter#urn:lsid:mygrid.org.uk:formalout
putparameter:39d7cfba80f094ea01f0aeccf5700339]
[java] 23:19:31,821 DEBUG BatcherImpl:50 - Executing batch size: 1
[java] 23:19:31,868 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,868 DEBUG BatcherImpl:261 - closing statement
[java] 23:19:31,868 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,868 DEBUG SQL:237 - insert into formaloutputparameter (name, message, description, metadataLSID, datatype_id, formaloutputparamet
er_id) values (?, ?, ?, ?, ?, ?)
[java] 23:19:31,868 DEBUG BatcherImpl:241 - preparing statement
[java] 23:19:31,868 DEBUG EntityPersister:388 - Dehydrating entity: [uk.org.mygrid.infomodel.FormalOutputParameter#urn:lsid:mygrid.org.uk:formalo
utputparameter:39d7cfba80f094ea01f0aeccf5700339]
[java] 23:19:31,930 DEBUG StringType:46 - binding 'MIRGetEntityResponse' to parameter: 1
[java] 23:19:31,930 DEBUG StringType:41 - binding null to parameter: 2
[java] 23:19:31,930 DEBUG StringType:41 - binding null to parameter: 3
[java] 23:19:31,930 DEBUG StringType:41 - binding null to parameter: 4
[java] 23:19:31,930 DEBUG StringType:41 - binding null to parameter: 5
[java] 23:19:31,930 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:formaloutputparameter:39d7cfba80f094ea01f0aeccf5700339' to parameter: 6
[java] 23:19:31,946 DEBUG BatcherImpl:28 - Adding to batch
[java] 23:19:31,993 DEBUG BatcherImpl:50 - Executing batch size: 1
[java] 23:19:31,993 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:31,993 DEBUG BatcherImpl:261 - closing statement
[java] 23:19:31,993 DEBUG BasicCollectionPersister:522 - Inserting collection: [uk.org.mygrid.infomodel.Operation.formalinputparameter#urn:lsid:m
ygrid.org.uk:operation:39d7cea080f094ea00322bcee6d11e2f]
[java] 23:19:32,008 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:32,008 DEBUG SQL:237 - update formalinputparameter set operation_id=?, operation_ind=? where formalinputparameter_id=?
[java] 23:19:32,055 DEBUG BatcherImpl:241 - preparing statement
[java] 23:19:32,055 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:operation:39d7cea080f094ea00322bcee6d11e2f' to parameter: 1
[java] 23:19:32,055 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:formalinputparameter:39d7ccdb80f094ea00e99681b67fcddf' to parameter: 3
[java] 23:19:32,055 DEBUG IntegerType:46 - binding '0' to parameter: 2
[java] 23:19:32,055 DEBUG BatcherImpl:28 - Adding to batch
[java] 23:19:32,055 DEBUG BasicCollectionPersister:544 - done inserting collection: 1 rows inserted
[java] 23:19:32,118 DEBUG BasicCollectionPersister:522 - Inserting collection: [uk.org.mygrid.infomodel.Operation.formaloutputparameter#urn:lsid:
mygrid.org.uk:operation:39d7cea080f094ea00322bcee6d11e2f]
[java] 23:19:32,118 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:operation:39d7cea080f094ea00322bcee6d11e2f' to parameter: 1
[java] 23:19:32,118 DEBUG StringType:46 - binding 'urn:lsid:mygrid.org.uk:formaloutputparameter:39d7cd1a80f094ea0082796862bf261b' to parameter: 3
[java] 23:19:32,118 DEBUG IntegerType:46 - binding '0' to parameter: 2
[java] net.sf.hibernate.HibernateException: Batch update row count wrong: 1
[java] 23:19:32,165 DEBUG BatcherImpl:28 - Adding to batch
[java] at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:65)
[java] at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122)
[java] 23:19:32,165 DEBUG BasicCollectionPersister:544 - done inserting collection: 1 rows inserted
[java] 23:19:32,165 DEBUG BatcherImpl:50 - Executing batch size: 2
[java] at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2385)
[java] at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2339)
[java] 23:19:32,165 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
[java] 23:19:32,165 DEBUG BatcherImpl:261 - closing statement
[java] 23:19:32,165 ERROR SessionImpl:2343 - Could not synchronize database state with session
[java] at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1775)
[java] at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1536)
[java] at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1501)
[java] net.sf.hibernate.HibernateException: Batch update row count wrong: 1
[java] at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:65)
[java] at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491)
[java] at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1487)
[java] at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122)
[java] at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2385)
[java] at uk.org.mygrid.mir.domain.OperationTypeMgr.getByQuery(OperationTypeMgr.java:81)
[java] at uk.org.mygrid.mir.domain.OperationMgr.createOperationType(OperationMgr.java:205)
[java] at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2339)
[java] at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1775)
[java] at uk.org.mygrid.mir.domain.OperationMgr.add(OperationMgr.java:50)
[java] at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1536)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.createOperations(ServiceDescriptionMgr.java:95)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.add(ServiceDescriptionMgr.java:36)
[java] at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1501)
[java] at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491)
[java] at uk.org.mygrid.mir.service.MIRAccessServiceBindingImpl.storeMIREntity(MIRAccessServiceBindingImpl.java:97)
[java] at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1487)
[java] at uk.org.mygrid.mir.domain.OperationTypeMgr.getByQuery(OperationTypeMgr.java:81)
[java] at uk.org.mygrid.mir.test.ServiceTest.createWebService(ServiceTest.java:105)
[java] at uk.org.mygrid.mir.test.ServiceTest.main(ServiceTest.java:286)
[java] at uk.org.mygrid.mir.domain.OperationMgr.createOperationType(OperationMgr.java:205)
[java] at uk.org.mygrid.mir.domain.OperationMgr.add(OperationMgr.java:50)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.createOperations(ServiceDescriptionMgr.java:95)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.add(ServiceDescriptionMgr.java:36)
[java] at uk.org.mygrid.mir.service.MIRAccessServiceBindingImpl.storeMIREntity(MIRAccessServiceBindingImpl.java:97)
[java] at uk.org.mygrid.mir.test.ServiceTest.createWebService(ServiceTest.java:105)
[java] at uk.org.mygrid.mir.test.ServiceTest.main(ServiceTest.java:286)
[java] 23:19:32,336 ERROR ServiceDescriptionMgr:99 - Unable to store Operations
[java] uk.org.mygrid.mir.util.PersistenceException: Unable to store WebService
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.add(ServiceDescriptionMgr.java:40)
[java] uk.org.mygrid.mir.util.PersistenceException: Unable to store Operation
[java] at uk.org.mygrid.mir.service.MIRAccessServiceBindingImpl.storeMIREntity(MIRAccessServiceBindingImpl.java:97)
[java] at uk.org.mygrid.mir.domain.OperationMgr.add(OperationMgr.java:71)
[java] at uk.org.mygrid.mir.test.ServiceTest.createWebService(ServiceTest.java:105)
[java] at uk.org.mygrid.mir.test.ServiceTest.main(ServiceTest.java:286)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.createOperations(ServiceDescriptionMgr.java:95)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.add(ServiceDescriptionMgr.java:36)
[java] at uk.org.mygrid.mir.service.MIRAccessServiceBindingImpl.storeMIREntity(MIRAccessServiceBindingImpl.java:97)
[java] Caused by: uk.org.mygrid.mir.util.PersistenceException: Unable to store Operations
[java] at uk.org.mygrid.mir.test.ServiceTest.createWebService(ServiceTest.java:105)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.createOperations(ServiceDescriptionMgr.java:100)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.add(ServiceDescriptionMgr.java:36)
[java] ... 3 more
[java] at uk.org.mygrid.mir.test.ServiceTest.main(ServiceTest.java:286)
[java] Caused by: uk.org.mygrid.mir.util.PersistenceException: Unable to store Operation
[java] Caused by: uk.org.mygrid.mir.util.PersistenceException: Cannot create new type
[java] at uk.org.mygrid.mir.domain.OperationMgr.add(OperationMgr.java:71)
[java] at uk.org.mygrid.mir.domain.ServiceDescriptionMgr.createOperations(ServiceDescriptionMgr.java:95)
[java] at uk.org.mygrid.mir.domain.OperationMgr.createOperationType(OperationMgr.java:216)
[java] at uk.org.mygrid.mir.domain.OperationMgr.add(OperationMgr.java:50)
[java] ... 5 more
[java] ... 4 more
[java] Caused by: uk.org.mygrid.mir.util.PersistenceException: Cannot create new type
[java] Caused by: uk.org.mygrid.mir.util.LookupException: Unable to find given OperationType
[java] at uk.org.mygrid.mir.domain.OperationMgr.createOperationType(OperationMgr.java:216)
[java] at uk.org.mygrid.mir.domain.OperationMgr.add(OperationMgr.java:50)
[java] ... 5 more
[java] at uk.org.mygrid.mir.domain.OperationTypeMgr.getByQuery(OperationTypeMgr.java:91)
[java] Caused by: uk.org.mygrid.mir.util.LookupException: Unable to find given OperationType
[java] at uk.org.mygrid.mir.domain.OperationMgr.createOperationType(OperationMgr.java:205)
[java] ... 6 more
[java] 23:19:32,586 ERROR MIRAccessServiceBindingImpl:156 - Unable to store entity in the MIR
[java] Error processing: Unable to store entity in the MIR
[java] at uk.org.mygrid.mir.domain.OperationTypeMgr.getByQuery(OperationTypeMgr.java:91)
[java] at uk.org.mygrid.mir.domain.OperationMgr.createOperationType(OperationMgr.java:205)
[java] ... 6 more
Please advice - it's very very urgent
Regards
Arijit