2008-06-10 12:52:53,812 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] Creating jboss.jdbc:service=metadata
2008-06-10 12:52:53,828 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] Created jboss.jdbc:service=metadata
2008-06-10 12:52:54,582 INFO  [org.jboss.naming.NamingService] [main] JNDI bootstrap JNP=/0.0.0.0:1099, RMI=/0.0.0.0:1098, backlog=50, no client SocketFactory, Server SocketFactory=class org.jboss.net.sockets.DefaultSocketFactory
2008-06-10 12:52:55,023 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] Starting jboss.jdbc:service=metadata
2008-06-10 12:52:55,023 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] Loading standardjbosscmp-jdbc.xml : file:/D:/server/jboss/jboss-4.0.4.GA/server/services-cluster/conf/standardjbosscmp-jdbc.xml
2008-06-10 12:52:55,164 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: FirstSQL/J
2008-06-10 12:52:55,164 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Ingres
2008-06-10 12:52:55,164 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: McKoi
2008-06-10 12:52:55,164 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Firebird
2008-06-10 12:52:55,180 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: InterBase
2008-06-10 12:52:55,180 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: DB2
2008-06-10 12:52:55,180 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Derby
2008-06-10 12:52:55,180 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Oracle9i
2008-06-10 12:52:55,180 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Oracle8
2008-06-10 12:52:55,196 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Oracle7
2008-06-10 12:52:55,196 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Sybase
2008-06-10 12:52:55,196 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: PostgreSQL
2008-06-10 12:52:55,196 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: PostgreSQL 8.0
2008-06-10 12:52:55,196 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: PostgreSQL 7.2
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Hypersonic SQL
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: PointBase
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: SOLID
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: mySQL
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: MS SQLSERVER
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: MS SQLSERVER2000
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: DB2/400
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: SapDB
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: MaxDB
2008-06-10 12:52:55,211 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Cloudscape
2008-06-10 12:52:55,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: InformixDB
2008-06-10 12:52:55,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] added type-mapping: Mimer SQL
2008-06-10 12:52:55,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.MetaDataLibrary] [main] Started jboss.jdbc:service=metadata
2008-06-10 12:52:58,514 INFO  [org.apache.catalina.startup.Embedded] [main] Catalina naming disabled
2008-06-10 12:52:58,592 INFO  [org.apache.catalina.startup.ClusterRuleSetFactory] [main] Unable to find a cluster rule set in the classpath. Will load the default rule set.
2008-06-10 12:52:58,592 INFO  [org.apache.catalina.startup.ClusterRuleSetFactory] [main] Unable to find a cluster rule set in the classpath. Will load the default rule set.
2008-06-10 12:52:58,970 INFO  [org.apache.coyote.http11.Http11BaseProtocol] [main] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
2008-06-10 12:52:58,970 INFO  [org.apache.catalina.startup.Catalina] [main] Initialization processed in 378 ms
2008-06-10 12:52:58,970 INFO  [org.jboss.web.tomcat.tc5.StandardService] [main] Starting service jboss.web
2008-06-10 12:52:58,970 INFO  [org.apache.catalina.core.StandardEngine] [main] Starting Servlet Engine: Apache Tomcat/5.5.17
2008-06-10 12:52:59,048 INFO  [org.apache.catalina.core.StandardHost] [main] XML validation disabled
2008-06-10 12:52:59,064 INFO  [org.apache.catalina.startup.Catalina] [main] Server startup in 94 ms
2008-06-10 12:52:59,237 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] [main] deploy, ctxPath=/invoker, warUrl=.../deploy/httpha-invoker.sar/invoker.war/
2008-06-10 12:52:59,787 INFO  [org.apache.catalina.loader.WebappLoader] [main] Dual registration of jndi stream handler: factory already defined
2008-06-10 12:53:00,432 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] [main] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
2008-06-10 12:53:02,524 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] [main] deploy, ctxPath=/jbossws, warUrl=.../tmp/deploy/tmp5035jbossws-context-exp.war/
2008-06-10 12:53:03,027 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] [main] deploy, ctxPath=/juddi, warUrl=.../deploy/juddi-service.sar/juddi.war/
2008-06-10 12:53:03,200 INFO  [org.apache.juddi.registry.RegistryServlet] [main] Loading jUDDI configuration.
2008-06-10 12:53:03,247 INFO  [org.apache.juddi.registry.RegistryServlet] [main] Resources loaded from: /WEB-INF/juddi.properties
2008-06-10 12:53:03,278 INFO  [org.apache.juddi.registry.RegistryServlet] [main] Initializing jUDDI components.
2008-06-10 12:53:05,008 INFO  [org.jboss.ha.framework.interfaces.HAPartition.DefaultPartition] [main] Initializing
2008-06-10 12:53:05,087 INFO  [STDOUT] [UpHandler (GMS)] 
-------------------------------------------------------
GMS: address is RD-1052206-D:1211 (additional data: 19 bytes)
-------------------------------------------------------
2008-06-10 12:53:07,115 INFO  [org.jboss.ha.framework.interfaces.HAPartition.DefaultPartition] [main] Number of cluster members: 1
2008-06-10 12:53:07,115 INFO  [org.jboss.ha.framework.interfaces.HAPartition.lifecycle.DefaultPartition] [MessageDispatcher up processing thread] New cluster view for partition DefaultPartition (id: 0, delta: 0) : [62.104.243.153:1099]
2008-06-10 12:53:07,131 INFO  [org.jboss.ha.framework.interfaces.HAPartition.DefaultPartition] [main] Other members: 0
2008-06-10 12:53:07,131 INFO  [org.jboss.ha.framework.interfaces.HAPartition.DefaultPartition] [main] Fetching state (will wait for 30000 milliseconds):
2008-06-10 12:53:07,147 INFO  [org.jboss.ha.framework.server.DistributedReplicantManagerImpl.DefaultPartition] [AsynchViewChangeHandler Thread] I am (62.104.243.153:1099) received membershipChanged event:
2008-06-10 12:53:07,147 INFO  [org.jboss.ha.framework.server.DistributedReplicantManagerImpl.DefaultPartition] [AsynchViewChangeHandler Thread] Dead members: 0 ([])
2008-06-10 12:53:07,147 INFO  [org.jboss.ha.framework.server.DistributedReplicantManagerImpl.DefaultPartition] [AsynchViewChangeHandler Thread] New Members : 0 ([])
2008-06-10 12:53:07,147 INFO  [org.jboss.ha.framework.server.DistributedReplicantManagerImpl.DefaultPartition] [AsynchViewChangeHandler Thread] All Members : 1 ([62.104.243.153:1099])
2008-06-10 12:53:07,210 INFO  [org.jboss.ha.jndi.HANamingService] [main] Started ha-jndi bootstrap jnpPort=1100, backlog=50, bindAddress=/0.0.0.0
2008-06-10 12:53:07,210 INFO  [org.jboss.ha.jndi.DetachedHANamingService$AutomaticDiscovery] [main] Listening on /0.0.0.0:1102, group=230.0.0.4, HA-JNDI address=62.104.243.153:1100
2008-06-10 12:53:08,436 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] [main] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
2008-06-10 12:53:09,364 INFO  [org.jboss.resource.deployment.RARDeployment] [main] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
2008-06-10 12:53:09,474 INFO  [org.jboss.resource.deployment.RARDeployment] [main] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
2008-06-10 12:53:09,505 INFO  [org.jboss.resource.deployment.RARDeployment] [main] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
2008-06-10 12:53:09,568 INFO  [org.jboss.resource.deployment.RARDeployment] [main] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
2008-06-10 12:53:09,631 INFO  [org.jboss.resource.deployment.RARDeployment] [main] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar
2008-06-10 12:53:09,678 INFO  [org.jboss.resource.deployment.RARDeployment] [main] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar
2008-06-10 12:53:10,260 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Creating jboss.jdbc:service=metadata,datasource=SystemJaasDS
2008-06-10 12:53:10,260 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Created jboss.jdbc:service=metadata,datasource=SystemJaasDS
2008-06-10 12:53:10,276 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Creating jboss.jdbc:service=metadata,datasource=SystemJmsDS
2008-06-10 12:53:10,276 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Created jboss.jdbc:service=metadata,datasource=SystemJmsDS
2008-06-10 12:53:10,276 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Creating jboss.jdbc:service=metadata,datasource=SystemDefaultDS
2008-06-10 12:53:10,276 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Created jboss.jdbc:service=metadata,datasource=SystemDefaultDS
2008-06-10 12:53:10,323 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] [main] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SystemJaasDS' to JNDI name 'java:SystemJaasDS'
2008-06-10 12:53:10,323 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Starting jboss.jdbc:service=metadata,datasource=SystemJaasDS
2008-06-10 12:53:10,323 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Started jboss.jdbc:service=metadata,datasource=SystemJaasDS
2008-06-10 12:53:10,339 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] [main] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SystemJmsDS' to JNDI name 'java:SystemJmsDS'
2008-06-10 12:53:11,267 INFO  [org.jboss.mq.server.jmx.Queue.CustomerService] [main] Bound to JNDI name: queue/CustomerService
2008-06-10 12:53:11,298 INFO  [org.jboss.mq.il.uil2.UILServerILService] [main] JBossMQ UIL service available at : /0.0.0.0:8093
2008-06-10 12:53:11,581 INFO  [org.jboss.mq.server.jmx.Queue.DLQ] [main] Bound to JNDI name: queue/DLQ
2008-06-10 12:53:11,581 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Starting jboss.jdbc:service=metadata,datasource=SystemJmsDS
2008-06-10 12:53:11,581 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Started jboss.jdbc:service=metadata,datasource=SystemJmsDS
2008-06-10 12:53:11,597 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] [main] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SystemDefaultDS' to JNDI name 'java:SystemDefaultDS'
2008-06-10 12:53:12,588 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Starting jboss.jdbc:service=metadata,datasource=SystemDefaultDS
2008-06-10 12:53:12,588 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData] [main] Started jboss.jdbc:service=metadata,datasource=SystemDefaultDS
2008-06-10 12:53:12,682 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] [main] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=OfferInformation' to JNDI name 'java:OfferInformation'
2008-06-10 12:53:12,792 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] [main] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DBVertrag' to JNDI name 'java:DBVertrag'
2008-06-10 12:53:12,808 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] [main] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DBPlz' to JNDI name 'java:DBPlz'
2008-06-10 12:53:12,918 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] [main] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=ProductInformation' to JNDI name 'java:ProductInformation'
2008-06-10 12:53:13,075 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] [main] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
2008-06-10 12:53:13,138 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] [main] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
2008-06-10 12:53:13,374 INFO  [org.jboss.deployment.EARDeployer] [main] Init J2EE application: file:/D:/server/jboss/jboss-4.0.4.GA/server/services-cluster/deploy/applications/OfferService-dev-v0.2.1.ear
2008-06-10 12:53:13,830 INFO  [org.jboss.ejb.EjbModule] [main] Deploying ProductUsageEntityBean
2008-06-10 12:53:14,050 INFO  [org.jboss.ejb.EjbModule] [main] Deploying ItemCriteriaTypeEntityBean
2008-06-10 12:53:14,066 INFO  [org.jboss.ejb.EjbModule] [main] Deploying ProductUsageItemEntityBean
2008-06-10 12:53:14,066 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProductEntityBean
2008-06-10 12:53:14,081 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProposalItem2OptionsEntityBean
2008-06-10 12:53:14,081 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProposalItemEntityBean
2008-06-10 12:53:14,097 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferOptionEntityBean
2008-06-10 12:53:14,097 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProcessTypeEntityBean
2008-06-10 12:53:14,113 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProposalCriteriaEntityBean
2008-06-10 12:53:14,129 INFO  [org.jboss.ejb.EjbModule] [main] Deploying ContractUsageViewEntityBean
2008-06-10 12:53:14,129 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProductToOfferOptionEntityBean
2008-06-10 12:53:14,144 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProductTypeEntityBean
2008-06-10 12:53:14,144 INFO  [org.jboss.ejb.EjbModule] [main] Deploying PriorityTypeEntityBean
2008-06-10 12:53:14,160 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProposalItemCriteriaEntityBean
2008-06-10 12:53:14,160 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProposalMappingEntityBean
2008-06-10 12:53:14,176 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferTypeEntityBean
2008-06-10 12:53:14,191 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProposalEntityBean
2008-06-10 12:53:14,191 INFO  [org.jboss.ejb.EjbModule] [main] Deploying ContractUsageEntityBean
2008-06-10 12:53:14,223 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferProcessEntityBean
2008-06-10 12:53:14,223 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferTypeGroupEntityBean
2008-06-10 12:53:14,223 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferChannelEntityBean
2008-06-10 12:53:14,239 INFO  [org.jboss.ejb.EjbModule] [main] Deploying ProductUsageMappingEntityBean
2008-06-10 12:53:14,239 INFO  [org.jboss.ejb.EjbModule] [main] Deploying CriteriaTypeEntityBean
2008-06-10 12:53:14,254 INFO  [org.jboss.ejb.EjbModule] [main] Deploying OfferService
2008-06-10 12:53:16,865 INFO  [org.jboss.web.tomcat.tc5.TomcatDeployer] [main] deploy, ctxPath=/OfferServiceBeanService, warUrl=.../tmp/deploy/OfferService-dev-v0.2.1.ear-OfferService-dev-v0.2.1.jar-ws5069.war/
2008-06-10 12:53:17,038 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'ProductUsageEntityBean' to jndi 'local/ProductUsageEntityBean'
2008-06-10 12:53:17,148 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'ItemCriteriaTypeEntityBean' to jndi 'local/ItemCriteriaTypeEntityBean'
2008-06-10 12:53:17,258 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'ProductUsageItemEntityBean' to jndi 'local/ProductUsageItemEntityBean'
2008-06-10 12:53:17,352 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProductEntityBean' to jndi 'local/OfferProductEntityBean'
2008-06-10 12:53:17,447 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProposalItem2OptionsEntityBean' to jndi 'local/OfferProposalItem2OptionsEntityBean'
2008-06-10 12:53:17,557 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProposalItemEntityBean' to jndi 'local/OfferProposalItemEntityBean'
2008-06-10 12:53:17,651 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferOptionEntityBean' to jndi 'local/OfferOptionEntityBean'
2008-06-10 12:53:17,745 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProcessTypeEntityBean' to jndi 'local/OfferProcessTypeEntityBean'
2008-06-10 12:53:17,855 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProposalCriteriaEntityBean' to jndi 'local/OfferProposalCriteriaEntityBean'
2008-06-10 12:53:18,264 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'ContractUsageViewEntityBean' to jndi 'local/ContractUsageViewEntityBean'
2008-06-10 12:53:18,359 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProductToOfferOptionEntityBean' to jndi 'local/OfferProductToOfferOptionEntityBean'
2008-06-10 12:53:18,453 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProductTypeEntityBean' to jndi 'local/OfferProductTypeEntityBean'
2008-06-10 12:53:18,563 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'PriorityTypeEntityBean' to jndi 'local/PriorityTypeEntityBean'
2008-06-10 12:53:18,657 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProposalItemCriteriaEntityBean' to jndi 'local/OfferProposalItemCriteriaEntityBean'
2008-06-10 12:53:18,783 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProposalMappingEntityBean' to jndi 'local/OfferProposalMappingEntityBean'
2008-06-10 12:53:18,893 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferTypeEntityBean' to jndi 'local/OfferTypeEntityBean'
2008-06-10 12:53:18,988 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProposalEntityBean' to jndi 'local/OfferProposalEntityBean'
2008-06-10 12:53:19,098 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'ContractUsageEntityBean' to jndi 'local/ContractUsageEntityBean'
2008-06-10 12:53:19,208 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferProcessEntityBean' to jndi 'local/OfferProcessEntityBean'
2008-06-10 12:53:19,302 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferTypeGroupEntityBean' to jndi 'local/OfferTypeGroupEntityBean'
2008-06-10 12:53:19,396 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'OfferChannelEntityBean' to jndi 'local/OfferChannelEntityBean'
2008-06-10 12:53:19,491 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'ProductUsageMappingEntityBean' to jndi 'local/ProductUsageMappingEntityBean'
2008-06-10 12:53:19,617 INFO  [org.jboss.ejb.plugins.local.BaseLocalProxyFactory] [main] Bound EJB LocalHome 'CriteriaTypeEntityBean' to jndi 'local/CriteriaTypeEntityBean'
2008-06-10 12:53:19,742 INFO  [org.jboss.proxy.ejb.ProxyFactory] [main] Bound EJB Home 'OfferService' to jndi 'ejb/OfferService'
2008-06-10 12:53:19,837 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.ProductUsageEntityBean] [main] Initializing CMP plugin for ProductUsageEntityBean
2008-06-10 12:53:19,884 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.ProductUsageEntityBean] [main] Loading standardjbosscmp-jdbc.xml : file:/D:/server/jboss/jboss-4.0.4.GA/server/services-cluster/conf/standardjbosscmp-jdbc.xml
2008-06-10 12:53:19,978 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.ProductUsageEntityBean] [main] jar:file:/D:/server/jboss/jboss-4.0.4.GA/server/services-cluster/tmp/deploy/tmp5066OfferService-dev-v0.2.1.ear-contents/OfferService-dev-v0.2.1.jar!/META-INF/jbosscmp-jdbc.xml found. Overriding defaults
2008-06-10 12:53:21,032 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.ItemCriteriaTypeEntityBean] [main] Initializing CMP plugin for ItemCriteriaTypeEntityBean
2008-06-10 12:53:21,189 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.ProductUsageItemEntityBean] [main] Initializing CMP plugin for ProductUsageItemEntityBean
2008-06-10 12:53:21,205 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProductEntityBean] [main] Initializing CMP plugin for OfferProductEntityBean
2008-06-10 12:53:21,236 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProposalItem2OptionsEntityBean] [main] Initializing CMP plugin for OfferProposalItem2OptionsEntityBean
2008-06-10 12:53:21,252 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProposalItemEntityBean] [main] Initializing CMP plugin for OfferProposalItemEntityBean
2008-06-10 12:53:21,283 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferOptionEntityBean] [main] Initializing CMP plugin for OfferOptionEntityBean
2008-06-10 12:53:21,299 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProcessTypeEntityBean] [main] Initializing CMP plugin for OfferProcessTypeEntityBean
2008-06-10 12:53:21,315 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProposalCriteriaEntityBean] [main] Initializing CMP plugin for OfferProposalCriteriaEntityBean
2008-06-10 12:53:21,346 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.ContractUsageViewEntityBean] [main] Initializing CMP plugin for ContractUsageViewEntityBean
2008-06-10 12:53:21,362 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProductToOfferOptionEntityBean] [main] Initializing CMP plugin for OfferProductToOfferOptionEntityBean
2008-06-10 12:53:21,394 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProductTypeEntityBean] [main] Initializing CMP plugin for OfferProductTypeEntityBean
2008-06-10 12:53:21,409 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.PriorityTypeEntityBean] [main] Initializing CMP plugin for PriorityTypeEntityBean
2008-06-10 12:53:21,441 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProposalItemCriteriaEntityBean] [main] Initializing CMP plugin for OfferProposalItemCriteriaEntityBean
2008-06-10 12:53:21,456 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProposalMappingEntityBean] [main] Initializing CMP plugin for OfferProposalMappingEntityBean
2008-06-10 12:53:21,472 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferTypeEntityBean] [main] Initializing CMP plugin for OfferTypeEntityBean
2008-06-10 12:53:21,504 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProposalEntityBean] [main] Initializing CMP plugin for OfferProposalEntityBean
2008-06-10 12:53:21,519 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.ContractUsageEntityBean] [main] Initializing CMP plugin for ContractUsageEntityBean
2008-06-10 12:53:21,551 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferProcessEntityBean] [main] Initializing CMP plugin for OfferProcessEntityBean
2008-06-10 12:53:21,566 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferTypeGroupEntityBean] [main] Initializing CMP plugin for OfferTypeGroupEntityBean
2008-06-10 12:53:21,598 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.OfferChannelEntityBean] [main] Initializing CMP plugin for OfferChannelEntityBean
2008-06-10 12:53:21,614 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.ProductUsageMappingEntityBean] [main] Initializing CMP plugin for ProductUsageMappingEntityBean
2008-06-10 12:53:21,645 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.CriteriaTypeEntityBean] [main] Initializing CMP plugin for CriteriaTypeEntityBean
2008-06-10 12:53:22,935 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProcessEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:22,950 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProcessEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PROCESS (PROCESS_TYPE_ID) VALUES (?)
2008-06-10 12:53:22,950 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProcessEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:22,950 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProcessEntityBean] [main] Remove SQL: DELETE FROM OFFER_PROCESS WHERE ID=?
2008-06-10 12:53:23,170 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProcessEntityBean] [main] Table not create as requested: OFFER_PROCESS
2008-06-10 12:53:23,186 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProcessEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProcessEntityBean.ID FROM OFFER_PROCESS t0_OfferProcessEntityBean WHERE t0_OfferProcessEntityBean.ID=?
2008-06-10 12:53:23,186 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProcessEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:23,186 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalItem2OptionsEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:23,186 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalItem2OptionsEntityBean] [main] Insert Entity SQL: INSERT INTO PROPOSAL_ITEM_2_OPTIONS () VALUES ()
2008-06-10 12:53:23,186 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProposalItem2OptionsEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:23,186 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProposalItem2OptionsEntityBean] [main] Remove SQL: DELETE FROM PROPOSAL_ITEM_2_OPTIONS WHERE ID=?
2008-06-10 12:53:23,233 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalItem2OptionsEntityBean] [main] Table not create as requested: PROPOSAL_ITEM_2_OPTIONS
2008-06-10 12:53:23,233 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProposalItem2OptionsEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProposalItem2OptionsEn.ID, t0_OfferProposalItem2OptionsEn.PROPOSAL_ITEM_ID, t0_OfferProposalItem2OptionsEn.OPTION_ID FROM PROPOSAL_ITEM_2_OPTIONS t0_OfferProposalItem2OptionsEn WHERE t0_OfferProposalItem2OptionsEn.ID=?
2008-06-10 12:53:23,233 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProposalItem2OptionsEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:23,249 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ContractUsageEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:23,249 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ContractUsageEntityBean] [main] Insert Entity SQL: INSERT INTO CONTRACT_USAGE () VALUES ()
2008-06-10 12:53:23,249 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.ContractUsageEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:23,249 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.ContractUsageEntityBean] [main] Remove SQL: DELETE FROM CONTRACT_USAGE WHERE ID=?
2008-06-10 12:53:23,281 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ContractUsageEntityBean] [main] Table not create as requested: CONTRACT_USAGE
2008-06-10 12:53:23,281 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.ContractUsageEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_ContractUsageEntityBean.ID FROM CONTRACT_USAGE t0_ContractUsageEntityBean WHERE t0_ContractUsageEntityBean.ID=?
2008-06-10 12:53:23,281 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.ContractUsageEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:23,296 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ContractUsageEntityBean#findContractUsageByContractID] [main] EJB-QL: SELECT OBJECT(a) FROM ContractUsageEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2
2008-06-10 12:53:23,422 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ContractUsageEntityBean#findContractUsageByContractID] [main] SQL: SELECT t0_a.ID FROM CONTRACT_USAGE t0_a WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ?)
2008-06-10 12:53:23,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:23,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PROPOSAL () VALUES ()
2008-06-10 12:53:23,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProposalEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:23,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProposalEntityBean] [main] Remove SQL: DELETE FROM OFFER_PROPOSAL WHERE ID=?
2008-06-10 12:53:23,485 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalEntityBean] [main] Table not create as requested: OFFER_PROPOSAL
2008-06-10 12:53:23,485 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProposalEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProposalEntityBean.ID FROM OFFER_PROPOSAL t0_OfferProposalEntityBean WHERE t0_OfferProposalEntityBean.ID=?
2008-06-10 12:53:23,485 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProposalEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:23,485 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyID] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.partyNo = ?2
2008-06-10 12:53:23,532 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyID] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a WHERE (t0_a.DOMAIN = ? AND t0_a.PARTY_NO = ?)
2008-06-10 12:53:23,532 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferTypeGroupAndOfferType] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.partyNo = ?2 AND a.offerTypeGroupEntity.shortcut = ?3 AND a.offerTypeEntity.shortcut = ?4
2008-06-10 12:53:23,532 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferTypeGroupAndOfferType] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_TYPE_GROUP t1_a_offerTypeGroupEntity, OFFER_TYPE t2_a_offerTypeEntity WHERE (t0_a.DOMAIN = ? AND t0_a.PARTY_NO = ? AND t1_a_offerTypeGroupEntity.SHORTCUT = ? AND t2_a_offerTypeEntity.SHORTCUT = ? AND t0_a.OFFER_TYPE_GROUP_ID=t1_a_offerTypeGroupEntity.ID AND t0_a.OFFER_TYPE_ID=t2_a_offerTypeEntity.ID)
2008-06-10 12:53:23,532 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferTypeGroupAndOfferType] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2 AND a.offerTypeGroupEntity.shortcut = ?3 AND a.offerTypeEntity.shortcut = ?4
2008-06-10 12:53:23,532 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferTypeGroupAndOfferType] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_TYPE_GROUP t1_a_offerTypeGroupEntity, OFFER_TYPE t2_a_offerTypeEntity WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ? AND t1_a_offerTypeGroupEntity.SHORTCUT = ? AND t2_a_offerTypeEntity.SHORTCUT = ? AND t0_a.OFFER_TYPE_GROUP_ID=t1_a_offerTypeGroupEntity.ID AND t0_a.OFFER_TYPE_ID=t2_a_offerTypeEntity.ID)
2008-06-10 12:53:23,564 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferTypeGroupAndOfferTypeAndOfferChannel] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2 AND a.offerTypeGroupEntity.shortcut = ?3 AND a.offerTypeEntity.shortcut = ?4 AND a.offerChannelEntity.shortcut = ?5
2008-06-10 12:53:23,579 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferTypeGroupAndOfferTypeAndOfferChannel] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_TYPE_GROUP t1_a_offerTypeGroupEntity, OFFER_TYPE t2_a_offerTypeEntity, OFFER_CHANNEL t3_a_offerChannelEntity WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ? AND t1_a_offerTypeGroupEntity.SHORTCUT = ? AND t2_a_offerTypeEntity.SHORTCUT = ? AND t3_a_offerChannelEntity.SHORTCUT = ? AND t0_a.OFFER_TYPE_GROUP_ID=t1_a_offerTypeGroupEntity.ID AND t0_a.OFFER_TYPE_ID=t2_a_offerTypeEntity.ID AND t0_a.OFFER_CHANNEL_ID=t3_a_offerChannelEntity.ID)
2008-06-10 12:53:23,579 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferType] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.partyNo = ?2 AND a.offerTypeEntity.iD = ?3
2008-06-10 12:53:23,579 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferType] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_TYPE t1_a_offerTypeEntity WHERE (t0_a.DOMAIN = ? AND t0_a.PARTY_NO = ? AND t1_a_offerTypeEntity.ID = ? AND t0_a.OFFER_TYPE_ID=t1_a_offerTypeEntity.ID)
2008-06-10 12:53:23,579 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractID] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2
2008-06-10 12:53:23,579 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractID] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ?)
2008-06-10 12:53:23,595 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferTypeGroup] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2 AND a.offerTypeGroupEntity.shortcut = ?3
2008-06-10 12:53:23,595 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferTypeGroup] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_TYPE_GROUP t1_a_offerTypeGroupEntity WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ? AND t1_a_offerTypeGroupEntity.SHORTCUT = ? AND t0_a.OFFER_TYPE_GROUP_ID=t1_a_offerTypeGroupEntity.ID)
2008-06-10 12:53:23,595 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferChannel] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2 AND a.offerChannelEntity.shortcut = ?3
2008-06-10 12:53:23,595 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferChannel] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_CHANNEL t1_a_offerChannelEntity WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ? AND t1_a_offerChannelEntity.SHORTCUT = ? AND t0_a.OFFER_CHANNEL_ID=t1_a_offerChannelEntity.ID)
2008-06-10 12:53:23,595 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferTypeGroup] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.partyNo = ?2 AND a.offerTypeGroupEntity.shortcut = ?3
2008-06-10 12:53:23,595 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferTypeGroup] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_TYPE_GROUP t1_a_offerTypeGroupEntity WHERE (t0_a.DOMAIN = ? AND t0_a.PARTY_NO = ? AND t1_a_offerTypeGroupEntity.SHORTCUT = ? AND t0_a.OFFER_TYPE_GROUP_ID=t1_a_offerTypeGroupEntity.ID)
2008-06-10 12:53:23,611 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferChannel] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.partyNo = ?2 AND a.offerChannelEntity.shortcut = ?3
2008-06-10 12:53:23,611 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferChannel] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_CHANNEL t1_a_offerChannelEntity WHERE (t0_a.DOMAIN = ? AND t0_a.PARTY_NO = ? AND t1_a_offerChannelEntity.SHORTCUT = ? AND t0_a.OFFER_CHANNEL_ID=t1_a_offerChannelEntity.ID)
2008-06-10 12:53:23,611 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferTypeGroupAndOfferTypeAndOfferChannel] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.partyNo = ?2 AND a.offerTypeGroupEntity.shortcut = ?3 AND a.offerTypeEntity.shortcut = ?4 AND a.offerChannelEntity.shortcut = ?5
2008-06-10 12:53:23,611 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByPartyIDAndOfferTypeGroupAndOfferTypeAndOfferChannel] [main] SQL: SELECT t0_a.ID FROM OFFER_PROPOSAL t0_a, OFFER_TYPE_GROUP t1_a_offerTypeGroupEntity, OFFER_TYPE t2_a_offerTypeEntity, OFFER_CHANNEL t3_a_offerChannelEntity WHERE (t0_a.DOMAIN = ? AND t0_a.PARTY_NO = ? AND t1_a_offerTypeGroupEntity.SHORTCUT = ? AND t2_a_offerTypeEntity.SHORTCUT = ? AND t3_a_offerChannelEntity.SHORTCUT = ? AND t0_a.OFFER_TYPE_GROUP_ID=t1_a_offerTypeGroupEntity.ID AND t0_a.OFFER_TYPE_ID=t2_a_offerTypeEntity.ID AND t0_a.OFFER_CHANNEL_ID=t3_a_offerChannelEntity.ID)
2008-06-10 12:53:23,611 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferType] [main] JBossQL: SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2 AND a.offerTypeEntity.iD = ?3
2008-06-10 12:53:23,626 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferType] [main] SQL: SELECT t0_a.ID, t0_a.DOMAIN, t0_a.CONTRACT_NO, t0_a.PARTY_NO, t0_a.OFFER_PERIOD, t0_a.VALID_FROM, t0_a.VALID_TO, t0_a.PROPOSAL_PERMISSION, t0_a.OFFER_CHANNEL_ID, t0_a.OFFER_TYPE_GROUP_ID, t0_a.OFFER_TYPE_ID, t1_a_offerProposalItems.ID, t1_a_offerProposalItems.PROPOSAL_ID, t1_a_offerProposalItems.POSITION, t1_a_offerProposalItems.RANK_AFFINITY, t1_a_offerProposalItems.RANK_MARGIN, t1_a_offerProposalItems.RANK_PRIORITY, t1_a_offerProposalItems.PROCESS_ID, t2_a_offerProposalItems_offerP.ID, t2_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID, t2_a_offerProposalItems_offerP.CRITERIA_TYPE_ID, t2_a_offerProposalItems_offerP.CRITERIA_VALUE, t3_a_offerProposalItems_proces.ID, t3_a_offerProposalItems_proces.PROCESS_LABEL, t3_a_offerProposalItems_proces.PROCESS_DESCRIPTION, t3_a_offerProposalItems_proces.PROCESS_TYPE_ID, t4_a_offerProposalItems_proces.ID, t4_a_offerProposalItems_proces.SHORTCUT, t4_a_offerProposalItems_proces.LABEL, t4_a_offerProposalItems_proces.DESCRIPTION, t5_a_offerProposalItems_offerP.ID, t5_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID, t5_a_offerProposalItems_offerP.PRODUCT_MAPPING_ID, t6_a_offerProposalItems_offerP.ID, t6_a_offerProposalItems_offerP.OPTIONAL, t6_a_offerProposalItems_offerP.SELECTED, t6_a_offerProposalItems_offerP.PRODUCT_ID, t6_a_offerProposalItems_offerP.OPTION_ID, t7_a_offerProposalItems_offerP.ID, t7_a_offerProposalItems_offerP.PRODUCT_VARIANT_ID, t7_a_offerProposalItems_offerP.PRODUCT_EXTERNAL_REFERENCE, t7_a_offerProposalItems_offerP.PRODUCT_LABEL, t7_a_offerProposalItems_offerP.PRODUCT_PROVIDER, t7_a_offerProposalItems_offerP.PRODUCT_DESCRIPTION, t7_a_offerProposalItems_offerP.PRODUCT_TYPE_ID, t8_a_offerProposalItems_offerP.ID, t8_a_offerProposalItems_offerP.SHORTCUT, t8_a_offerProposalItems_offerP.LABEL, t8_a_offerProposalItems_offerP.DESCRIPTION, t9_a_offerProposalItems_offerP.ID, t9_a_offerProposalItems_offerP.OPTION_NUMBER, t9_a_offerProposalItems_offerP.OPTION_EXTERNAL_REFERENCE, t9_a_offerProposalItems_offerP.OPTION_LABEL, t10_a_offerProposalCriteria.ID, t10_a_offerProposalCriteria.PROPOSAL_ID, t10_a_offerProposalCriteria.CRITERIA_TYPE_ID, t10_a_offerProposalCriteria.CRITERIA_VALUE, t11_a_offerChannelEntity.ID, t11_a_offerChannelEntity.SHORTCUT, t12_a_offerTypeGroupEntity.ID, t12_a_offerTypeGroupEntity.SHORTCUT, t13_a_offerTypeEntity.ID, t13_a_offerTypeEntity.SHORTCUT FROM OFFER_PROPOSAL t0_a LEFT OUTER JOIN OFFER_PROPOSAL_ITEM t1_a_offerProposalItems ON t0_a.ID=t1_a_offerProposalItems.PROPOSAL_ID LEFT OUTER JOIN OFFER_PROPOSAL_ITEM_CRITERIA t2_a_offerProposalItems_offerP ON t1_a_offerProposalItems.ID=t2_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID LEFT OUTER JOIN OFFER_PROCESS t3_a_offerProposalItems_proces ON t1_a_offerProposalItems.PROCESS_ID=t3_a_offerProposalItems_proces.ID LEFT OUTER JOIN OFFER_PROCESS_TYPE t4_a_offerProposalItems_proces ON t3_a_offerProposalItems_proces.PROCESS_TYPE_ID=t4_a_offerProposalItems_proces.ID LEFT OUTER JOIN OFFER_PROPOSAL_MAPPING t5_a_offerProposalItems_offerP ON t1_a_offerProposalItems.ID=t5_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID LEFT OUTER JOIN OFFER_PRODUCT_2_OFFER_OPTION t6_a_offerProposalItems_offerP ON t5_a_offerProposalItems_offerP.PRODUCT_MAPPING_ID=t6_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PRODUCT t7_a_offerProposalItems_offerP ON t6_a_offerProposalItems_offerP.PRODUCT_ID=t7_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PRODUCT_TYPE t8_a_offerProposalItems_offerP ON t7_a_offerProposalItems_offerP.PRODUCT_TYPE_ID=t8_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_OPTION t9_a_offerProposalItems_offerP ON t6_a_offerProposalItems_offerP.OPTION_ID=t9_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PROPOSAL_CRITERIA t10_a_offerProposalCriteria ON t0_a.ID=t10_a_offerProposalCriteria.PROPOSAL_ID LEFT OUTER JOIN OFFER_CHANNEL t11_a_offerChannelEntity ON t0_a.OFFER_CHANNEL_ID=t11_a_offerChannelEntity.ID LEFT OUTER JOIN OFFER_TYPE_GROUP t12_a_offerTypeGroupEntity ON t0_a.OFFER_TYPE_GROUP_ID=t12_a_offerTypeGroupEntity.ID LEFT OUTER JOIN OFFER_TYPE t13_a_offerTypeEntity ON t0_a.OFFER_TYPE_ID=t13_a_offerTypeEntity.ID WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ? AND t13_a_offerTypeEntity.ID = ? AND t0_a.OFFER_TYPE_ID=t13_a_offerTypeEntity.ID)
2008-06-10 12:53:23,626 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalMappingEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:23,626 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalMappingEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PROPOSAL_MAPPING (PRODUCT_MAPPING_ID) VALUES (?)
2008-06-10 12:53:23,626 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProposalMappingEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:23,626 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProposalMappingEntityBean] [main] Remove SQL: DELETE FROM OFFER_PROPOSAL_MAPPING WHERE ID=?
2008-06-10 12:53:23,705 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalMappingEntityBean] [main] Table not create as requested: OFFER_PROPOSAL_MAPPING
2008-06-10 12:53:23,705 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProposalMappingEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProposalMappingEntityB.ID FROM OFFER_PROPOSAL_MAPPING t0_OfferProposalMappingEntityB WHERE t0_OfferProposalMappingEntityB.ID=?
2008-06-10 12:53:23,705 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProposalMappingEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:23,705 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.PriorityTypeEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:23,705 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.PriorityTypeEntityBean] [main] Insert Entity SQL: INSERT INTO PRIORITY_TYPE () VALUES ()
2008-06-10 12:53:23,705 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.PriorityTypeEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:23,705 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.PriorityTypeEntityBean] [main] Remove SQL: DELETE FROM PRIORITY_TYPE WHERE ID=?
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PriorityTypeEntityBean] [main] Table not create as requested: PRIORITY_TYPE
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.PriorityTypeEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_PriorityTypeEntityBean.ID FROM PRIORITY_TYPE t0_PriorityTypeEntityBean WHERE t0_PriorityTypeEntityBean.ID=?
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.PriorityTypeEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.PriorityTypeEntityBean#findAll] [main] EJB-QL: SELECT OBJECT(a) FROM PriorityTypeEntityBean AS a
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.PriorityTypeEntityBean#findAll] [main] SQL: SELECT t0_a.ID FROM PRIORITY_TYPE t0_a
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferTypeGroupEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferTypeGroupEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_TYPE_GROUP () VALUES ()
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferTypeGroupEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:23,752 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferTypeGroupEntityBean] [main] Remove SQL: DELETE FROM OFFER_TYPE_GROUP WHERE ID=?
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferTypeGroupEntityBean] [main] Table not create as requested: OFFER_TYPE_GROUP
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferTypeGroupEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferTypeGroupEntityBean.ID FROM OFFER_TYPE_GROUP t0_OfferTypeGroupEntityBean WHERE t0_OfferTypeGroupEntityBean.ID=?
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferTypeGroupEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferTypeGroupEntityBean#findAll] [main] EJB-QL: SELECT OBJECT(a) FROM OfferTypeGroupEntityBean AS a
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferTypeGroupEntityBean#findAll] [main] SQL: SELECT t0_a.ID FROM OFFER_TYPE_GROUP t0_a
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.CriteriaTypeEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.CriteriaTypeEntityBean] [main] Insert Entity SQL: INSERT INTO CRITERIA_TYPE () VALUES ()
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.CriteriaTypeEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:23,799 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.CriteriaTypeEntityBean] [main] Remove SQL: DELETE FROM CRITERIA_TYPE WHERE ID=?
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.CriteriaTypeEntityBean] [main] Table not create as requested: CRITERIA_TYPE
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.CriteriaTypeEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_CriteriaTypeEntityBean.ID FROM CRITERIA_TYPE t0_CriteriaTypeEntityBean WHERE t0_CriteriaTypeEntityBean.ID=?
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.CriteriaTypeEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [main] EJB-QL: SELECT OBJECT(a) FROM CriteriaTypeEntityBean AS a
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [main] SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ProductUsageMappingEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ProductUsageMappingEntityBean] [main] Insert Entity SQL: INSERT INTO PRODUCT_USAGE_MAPPING (PRODUCT_MAPPING_ID, PRODUCT_USAGE_ITEM_ID) VALUES (?, ?)
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.ProductUsageMappingEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:23,847 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.ProductUsageMappingEntityBean] [main] Remove SQL: DELETE FROM PRODUCT_USAGE_MAPPING WHERE ID=?
2008-06-10 12:53:23,894 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ProductUsageMappingEntityBean] [main] Table not create as requested: PRODUCT_USAGE_MAPPING
2008-06-10 12:53:24,193 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.ProductUsageMappingEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_ProductUsageMappingEntityBe.ID FROM PRODUCT_USAGE_MAPPING t0_ProductUsageMappingEntityBe WHERE t0_ProductUsageMappingEntityBe.ID=?
2008-06-10 12:53:24,193 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.ProductUsageMappingEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:24,208 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ProductUsageEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:24,208 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ProductUsageEntityBean] [main] Insert Entity SQL: INSERT INTO PRODUCT_USAGE () VALUES ()
2008-06-10 12:53:24,208 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.ProductUsageEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:24,208 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.ProductUsageEntityBean] [main] Remove SQL: DELETE FROM PRODUCT_USAGE WHERE ID=?
2008-06-10 12:53:24,240 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ProductUsageEntityBean] [main] Table not create as requested: PRODUCT_USAGE
2008-06-10 12:53:24,334 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.ProductUsageEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_ProductUsageEntityBean.ID FROM PRODUCT_USAGE t0_ProductUsageEntityBean WHERE t0_ProductUsageEntityBean.ID=?
2008-06-10 12:53:24,334 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.ProductUsageEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:24,334 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.ProductUsageEntityBean#findProductUsageByContractID] [main] JBossQL: SELECT OBJECT(a) FROM ProductUsageEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2
2008-06-10 12:53:24,334 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.ProductUsageEntityBean#findProductUsageByContractID] [main] SQL: SELECT t0_a.ID FROM PRODUCT_USAGE t0_a WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ?)
2008-06-10 12:53:24,350 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ProductUsageItemEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:24,350 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ProductUsageItemEntityBean] [main] Insert Entity SQL: INSERT INTO PRODUCT_USAGE_ITEM () VALUES ()
2008-06-10 12:53:24,350 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.ProductUsageItemEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:24,350 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.ProductUsageItemEntityBean] [main] Remove SQL: DELETE FROM PRODUCT_USAGE_ITEM WHERE ID=?
2008-06-10 12:53:24,381 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ProductUsageItemEntityBean] [main] Table not create as requested: PRODUCT_USAGE_ITEM
2008-06-10 12:53:24,539 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.ProductUsageItemEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_ProductUsageItemEntityBean.ID FROM PRODUCT_USAGE_ITEM t0_ProductUsageItemEntityBean WHERE t0_ProductUsageItemEntityBean.ID=?
2008-06-10 12:53:24,539 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.ProductUsageItemEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:24,554 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalItemEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:24,554 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalItemEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PROPOSAL_ITEM (PROCESS_ID) VALUES (?)
2008-06-10 12:53:24,554 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProposalItemEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:24,554 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProposalItemEntityBean] [main] Remove SQL: DELETE FROM OFFER_PROPOSAL_ITEM WHERE ID=?
2008-06-10 12:53:24,601 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalItemEntityBean] [main] Table not create as requested: OFFER_PROPOSAL_ITEM
2008-06-10 12:53:24,727 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProposalItemEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProposalItemEntityBean.ID FROM OFFER_PROPOSAL_ITEM t0_OfferProposalItemEntityBean WHERE t0_OfferProposalItemEntityBean.ID=?
2008-06-10 12:53:24,774 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProposalItemEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:24,806 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProductToOfferOptionEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:24,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProductToOfferOptionEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PRODUCT_2_OFFER_OPTION (PRODUCT_ID, OPTION_ID) VALUES (?, ?)
2008-06-10 12:53:24,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProductToOfferOptionEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:24,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProductToOfferOptionEntityBean] [main] Remove SQL: DELETE FROM OFFER_PRODUCT_2_OFFER_OPTION WHERE ID=?
2008-06-10 12:53:24,869 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductToOfferOptionEntityBean] [main] Table not create as requested: OFFER_PRODUCT_2_OFFER_OPTION
2008-06-10 12:53:24,916 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProductToOfferOptionEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProductToOfferOptionEn.ID FROM OFFER_PRODUCT_2_OFFER_OPTION t0_OfferProductToOfferOptionEn WHERE t0_OfferProductToOfferOptionEn.ID=?
2008-06-10 12:53:24,916 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProductToOfferOptionEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:24,916 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProductTypeEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:24,916 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProductTypeEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PRODUCT_TYPE () VALUES ()
2008-06-10 12:53:24,916 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProductTypeEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:24,916 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProductTypeEntityBean] [main] Remove SQL: DELETE FROM OFFER_PRODUCT_TYPE WHERE ID=?
2008-06-10 12:53:24,963 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductTypeEntityBean] [main] Table not create as requested: OFFER_PRODUCT_TYPE
2008-06-10 12:53:24,963 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProductTypeEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProductTypeEntityBean.ID FROM OFFER_PRODUCT_TYPE t0_OfferProductTypeEntityBean WHERE t0_OfferProductTypeEntityBean.ID=?
2008-06-10 12:53:24,963 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProductTypeEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:24,963 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferProductTypeEntityBean#findIDByShortcut] [main] EJB-QL: SELECT OBJECT(a) FROM OfferProductTypeEntityBean AS a WHERE a.shortcut = ?1
2008-06-10 12:53:24,963 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferProductTypeEntityBean#findIDByShortcut] [main] SQL: SELECT t0_a.ID FROM OFFER_PRODUCT_TYPE t0_a WHERE (t0_a.SHORTCUT = ?)
2008-06-10 12:53:24,979 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalCriteriaEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:24,979 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalCriteriaEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PROPOSAL_CRITERIA () VALUES ()
2008-06-10 12:53:24,979 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProposalCriteriaEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:24,979 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProposalCriteriaEntityBean] [main] Remove SQL: DELETE FROM OFFER_PROPOSAL_CRITERIA WHERE ID=?
2008-06-10 12:53:25,010 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalCriteriaEntityBean] [main] Table not create as requested: OFFER_PROPOSAL_CRITERIA
2008-06-10 12:53:25,010 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProposalCriteriaEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProposalCriteriaEntity.ID FROM OFFER_PROPOSAL_CRITERIA t0_OfferProposalCriteriaEntity WHERE t0_OfferProposalCriteriaEntity.ID=?
2008-06-10 12:53:25,026 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProposalCriteriaEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,026 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferTypeEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:25,026 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferTypeEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_TYPE () VALUES ()
2008-06-10 12:53:25,026 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferTypeEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:25,026 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferTypeEntityBean] [main] Remove SQL: DELETE FROM OFFER_TYPE WHERE ID=?
2008-06-10 12:53:25,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferTypeEntityBean] [main] Table not create as requested: OFFER_TYPE
2008-06-10 12:53:25,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferTypeEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferTypeEntityBean.ID FROM OFFER_TYPE t0_OfferTypeEntityBean WHERE t0_OfferTypeEntityBean.ID=?
2008-06-10 12:53:25,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferTypeEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferTypeEntityBean#findAll] [main] EJB-QL: SELECT OBJECT(a) FROM OfferTypeEntityBean AS a
2008-06-10 12:53:25,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferTypeEntityBean#findAll] [main] SQL: SELECT t0_a.ID FROM OFFER_TYPE t0_a
2008-06-10 12:53:25,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferTypeEntityBean#findIDByShortcut] [main] EJB-QL: SELECT OBJECT(a) FROM OfferTypeEntityBean AS a WHERE a.shortcut = ?1
2008-06-10 12:53:25,168 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferTypeEntityBean#findIDByShortcut] [main] SQL: SELECT t0_a.ID FROM OFFER_TYPE t0_a WHERE (t0_a.SHORTCUT = ?)
2008-06-10 12:53:25,183 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ContractUsageViewEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:25,183 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ContractUsageViewEntityBean] [main] Insert Entity SQL: INSERT INTO V_CONTRACT_USAGE_DETAIL () VALUES ()
2008-06-10 12:53:25,183 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.ContractUsageViewEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:25,183 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.ContractUsageViewEntityBean] [main] Remove SQL: DELETE FROM V_CONTRACT_USAGE_DETAIL WHERE ID=?
2008-06-10 12:53:25,230 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ContractUsageViewEntityBean] [main] Table not create as requested: V_CONTRACT_USAGE_DETAIL
2008-06-10 12:53:25,230 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.ContractUsageViewEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_ContractUsageViewEntityBean.ID, t0_ContractUsageViewEntityBean.CONTRACT_USAGE_ID, t0_ContractUsageViewEntityBean.DOMAIN, t0_ContractUsageViewEntityBean.CONTRACT_NO, t0_ContractUsageViewEntityBean.SEGMENT_1_GROUP, t0_ContractUsageViewEntityBean.SEGMENT_1, t0_ContractUsageViewEntityBean.SEGMENT_2_GROUP, t0_ContractUsageViewEntityBean.SEGMENT_2, t0_ContractUsageViewEntityBean.SEGMENT_3_GROUP, t0_ContractUsageViewEntityBean.SEGMENT_3, t0_ContractUsageViewEntityBean.SEGMENT_4_GROUP, t0_ContractUsageViewEntityBean.SEGMENT_4, t0_ContractUsageViewEntityBean.DURATION, t0_ContractUsageViewEntityBean.CONNECTION, t0_ContractUsageViewEntityBean.COST, t0_ContractUsageViewEntityBean.PRICE, t0_ContractUsageViewEntityBean.GAIN, t0_ContractUsageViewEntityBean.QUOTA FROM V_CONTRACT_USAGE_DETAIL t0_ContractUsageViewEntityBean WHERE t0_ContractUsageViewEntityBean.ID=?
2008-06-10 12:53:25,230 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.ContractUsageViewEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,230 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ContractUsageViewEntityBean#findContractUsageByContractID] [main] EJB-QL: SELECT OBJECT(a) FROM ContractUsageViewEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2
2008-06-10 12:53:25,230 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ContractUsageViewEntityBean#findContractUsageByContractID] [main] SQL: SELECT t0_a.ID, t0_a.CONTRACT_USAGE_ID, t0_a.DOMAIN, t0_a.CONTRACT_NO, t0_a.SEGMENT_1_GROUP, t0_a.SEGMENT_1, t0_a.SEGMENT_2_GROUP, t0_a.SEGMENT_2, t0_a.SEGMENT_3_GROUP, t0_a.SEGMENT_3, t0_a.SEGMENT_4_GROUP, t0_a.SEGMENT_4, t0_a.DURATION, t0_a.CONNECTION, t0_a.COST, t0_a.PRICE, t0_a.GAIN, t0_a.QUOTA FROM V_CONTRACT_USAGE_DETAIL t0_a WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ?)
2008-06-10 12:53:25,246 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProductEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:25,246 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProductEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PRODUCT (PRODUCT_TYPE_ID) VALUES (?)
2008-06-10 12:53:25,246 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProductEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:25,246 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProductEntityBean] [main] Remove SQL: DELETE FROM OFFER_PRODUCT WHERE ID=?
2008-06-10 12:53:25,278 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductEntityBean] [main] Table not create as requested: OFFER_PRODUCT
2008-06-10 12:53:25,293 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProductEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProductEntityBean.ID FROM OFFER_PRODUCT t0_OfferProductEntityBean WHERE t0_OfferProductEntityBean.ID=?
2008-06-10 12:53:25,293 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProductEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,293 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferOptionEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:25,293 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferOptionEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_OPTION () VALUES ()
2008-06-10 12:53:25,293 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferOptionEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:25,293 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferOptionEntityBean] [main] Remove SQL: DELETE FROM OFFER_OPTION WHERE ID=?
2008-06-10 12:53:25,325 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferOptionEntityBean] [main] Table not create as requested: OFFER_OPTION
2008-06-10 12:53:25,325 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferOptionEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferOptionEntityBean.ID FROM OFFER_OPTION t0_OfferOptionEntityBean WHERE t0_OfferOptionEntityBean.ID=?
2008-06-10 12:53:25,340 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferOptionEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,340 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProcessTypeEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:25,340 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProcessTypeEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PROCESS_TYPE () VALUES ()
2008-06-10 12:53:25,340 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProcessTypeEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:25,340 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProcessTypeEntityBean] [main] Remove SQL: DELETE FROM OFFER_PROCESS_TYPE WHERE ID=?
2008-06-10 12:53:25,372 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProcessTypeEntityBean] [main] Table not create as requested: OFFER_PROCESS_TYPE
2008-06-10 12:53:25,372 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProcessTypeEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProcessTypeEntityBean.ID FROM OFFER_PROCESS_TYPE t0_OfferProcessTypeEntityBean WHERE t0_OfferProcessTypeEntityBean.ID=?
2008-06-10 12:53:25,372 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProcessTypeEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,388 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferProcessTypeEntityBean#findAll] [main] EJB-QL: SELECT OBJECT(a) FROM OfferProcessTypeEntityBean AS a
2008-06-10 12:53:25,388 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferProcessTypeEntityBean#findAll] [main] SQL: SELECT t0_a.ID FROM OFFER_PROCESS_TYPE t0_a
2008-06-10 12:53:25,388 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ItemCriteriaTypeEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:25,388 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.ItemCriteriaTypeEntityBean] [main] Insert Entity SQL: INSERT INTO ITEM_CRITERIA_TYPE () VALUES ()
2008-06-10 12:53:25,388 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.ItemCriteriaTypeEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:25,388 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.ItemCriteriaTypeEntityBean] [main] Remove SQL: DELETE FROM ITEM_CRITERIA_TYPE WHERE ID=?
2008-06-10 12:53:25,419 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ItemCriteriaTypeEntityBean] [main] Table not create as requested: ITEM_CRITERIA_TYPE
2008-06-10 12:53:25,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.ItemCriteriaTypeEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_ItemCriteriaTypeEntityBean.ID FROM ITEM_CRITERIA_TYPE t0_ItemCriteriaTypeEntityBean WHERE t0_ItemCriteriaTypeEntityBean.ID=?
2008-06-10 12:53:25,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.ItemCriteriaTypeEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [main] EJB-QL: SELECT OBJECT(a) FROM ItemCriteriaTypeEntityBean AS a
2008-06-10 12:53:25,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [main] SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:25,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferChannelEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:25,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferChannelEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_CHANNEL () VALUES ()
2008-06-10 12:53:25,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferChannelEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:25,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferChannelEntityBean] [main] Remove SQL: DELETE FROM OFFER_CHANNEL WHERE ID=?
2008-06-10 12:53:25,466 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferChannelEntityBean] [main] Table not create as requested: OFFER_CHANNEL
2008-06-10 12:53:25,466 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferChannelEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferChannelEntityBean.ID FROM OFFER_CHANNEL t0_OfferChannelEntityBean WHERE t0_OfferChannelEntityBean.ID=?
2008-06-10 12:53:25,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferChannelEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferChannelEntityBean#findAll] [main] EJB-QL: SELECT OBJECT(a) FROM OfferChannelEntityBean AS a
2008-06-10 12:53:25,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferChannelEntityBean#findAll] [main] SQL: SELECT t0_a.ID FROM OFFER_CHANNEL t0_a
2008-06-10 12:53:25,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalItemCriteriaEntityBean] [main] Create will not be allowed because pk field iDis read only.
2008-06-10 12:53:25,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand.OfferProposalItemCriteriaEntityBean] [main] Insert Entity SQL: INSERT INTO OFFER_PROPOSAL_ITEM_CRITERIA () VALUES ()
2008-06-10 12:53:25,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.OfferProposalItemCriteriaEntityBean] [main] entity-command: [commandName=informix-serial,commandClass=class org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand,attributes={}]
2008-06-10 12:53:25,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.OfferProposalItemCriteriaEntityBean] [main] Remove SQL: DELETE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE ID=?
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalItemCriteriaEntityBean] [main] Table not create as requested: OFFER_PROPOSAL_ITEM_CRITERIA
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferProposalItemCriteriaEntityBean#findByPrimaryKey] [main] SQL: SELECT t0_OfferProposalItemCriteriaEn.ID FROM OFFER_PROPOSAL_ITEM_CRITERIA t0_OfferProposalItemCriteriaEn WHERE t0_OfferProposalItemCriteriaEn.ID=?
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.OfferProposalItemCriteriaEntityBean] [main] Added findByPrimaryKey query command for local home interface
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProcessEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=Process-belongs-to-OfferProposalItem
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProcessEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=Process-has-ProcessType
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ContractUsageEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=ContractUsageContractUsageView
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalOfferProposalCriteria
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalOfferProposalItem
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposal-has-OfferTypeGroup
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposal-has-OfferChannel
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposal-has-OfferType
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalMappingEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalMappingItemOfferProposalItem
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalMappingEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalMapping-has-OfferProductOptionMapping
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferTypeGroupEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferTypeGroup-belongs-to-OfferProposal
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ProductUsageMappingEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=ProductUsageMapping-has-OfferProductOptionMapping
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ProductUsageMappingEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=ProductUsageMappingItem-belongs-to-ProductUsageItem
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ProductUsageEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=ProductUsageProductUsageItem
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ProductUsageItemEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=ProductUsageItemProductUsage
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ProductUsageItemEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=ProductUsageItem-has-ProductUsageMappingItem
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalItemEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalItem-has-Process
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalItemEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalItemOfferProposalMappingItem
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalItemEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalItemOfferProposal
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalItemEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalItemOfferProposalItemCriteria
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductToOfferOptionEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProductOptionMapping-belongs-to-ProductUsageMapping
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductToOfferOptionEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProductOptionMapping-has-OfferProduct
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductToOfferOptionEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProductOptionMapping-belongs-to-OfferProposalMapping
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductToOfferOptionEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProductOptionMapping-has-OfferOption
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductTypeEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProductType-belongs-to-OfferProduct
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalCriteriaEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalCriteriaOfferProposal
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferTypeEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferType-belongs-to-OfferProposal
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ContractUsageViewEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=ContractUsageViewContractUsage
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProduct-has-OfferProductType
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProductEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProduct-belongs-to-OfferProductOptionMapping
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferOptionEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferOption-belongs-to-OfferProductOptionMapping
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProcessTypeEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=ProcessType-belongs-to-Process
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferChannelEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferChannel-belongs-to-OfferProposal
2008-06-10 12:53:25,529 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.OfferProposalItemCriteriaEntityBean] [main] Foreign key constraint not added as requested: relationshipRolename=OfferProposalItemCriteriaOfferProposalItem
2008-06-10 12:53:25,529 INFO  [org.jboss.ejb.EJBDeployer] [main] Deployed: file:/D:/server/jboss/jboss-4.0.4.GA/server/services-cluster/tmp/deploy/tmp5066OfferService-dev-v0.2.1.ear-contents/OfferService-dev-v0.2.1.jar
2008-06-10 12:53:26,237 INFO  [org.jboss.deployment.EARDeployer] [main] Started J2EE application: file:/D:/server/jboss/jboss-4.0.4.GA/server/services-cluster/deploy/applications/OfferService-dev-v0.2.1.ear
2008-06-10 12:53:26,347 INFO  [org.apache.coyote.http11.Http11BaseProtocol] [main] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
2008-06-10 12:53:26,536 INFO  [org.apache.jk.common.ChannelSocket] [main] JK: ajp13 listening on /0.0.0.0:8009
2008-06-10 12:53:26,536 INFO  [org.apache.jk.server.JkMain] [main] Jk running ID=0 time=0/95  config=null
2008-06-10 12:53:26,567 INFO  [org.jboss.system.server.Server] [main] JBoss (MX MicroKernel) [4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000)] Started in 39s:281ms
2008-06-10 12:53:51,884 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OfferTypeEntityBean#findIDByShortcut] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM OFFER_TYPE t0_a WHERE (t0_a.SHORTCUT = ?)
2008-06-10 12:53:51,994 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT FROM OFFER_TYPE WHERE (ID=?)
2008-06-10 12:53:52,089 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.OfferProposalEntityBean#findOfferProposalByContractIDAndOfferType] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID, t0_a.DOMAIN, t0_a.CONTRACT_NO, t0_a.PARTY_NO, t0_a.OFFER_PERIOD, t0_a.VALID_FROM, t0_a.VALID_TO, t0_a.PROPOSAL_PERMISSION, t0_a.OFFER_CHANNEL_ID, t0_a.OFFER_TYPE_GROUP_ID, t0_a.OFFER_TYPE_ID, t1_a_offerProposalItems.ID, t1_a_offerProposalItems.PROPOSAL_ID, t1_a_offerProposalItems.POSITION, t1_a_offerProposalItems.RANK_AFFINITY, t1_a_offerProposalItems.RANK_MARGIN, t1_a_offerProposalItems.RANK_PRIORITY, t1_a_offerProposalItems.PROCESS_ID, t2_a_offerProposalItems_offerP.ID, t2_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID, t2_a_offerProposalItems_offerP.CRITERIA_TYPE_ID, t2_a_offerProposalItems_offerP.CRITERIA_VALUE, t3_a_offerProposalItems_proces.ID, t3_a_offerProposalItems_proces.PROCESS_LABEL, t3_a_offerProposalItems_proces.PROCESS_DESCRIPTION, t3_a_offerProposalItems_proces.PROCESS_TYPE_ID, t4_a_offerProposalItems_proces.ID, t4_a_offerProposalItems_proces.SHORTCUT, t4_a_offerProposalItems_proces.LABEL, t4_a_offerProposalItems_proces.DESCRIPTION, t5_a_offerProposalItems_offerP.ID, t5_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID, t5_a_offerProposalItems_offerP.PRODUCT_MAPPING_ID, t6_a_offerProposalItems_offerP.ID, t6_a_offerProposalItems_offerP.OPTIONAL, t6_a_offerProposalItems_offerP.SELECTED, t6_a_offerProposalItems_offerP.PRODUCT_ID, t6_a_offerProposalItems_offerP.OPTION_ID, t7_a_offerProposalItems_offerP.ID, t7_a_offerProposalItems_offerP.PRODUCT_VARIANT_ID, t7_a_offerProposalItems_offerP.PRODUCT_EXTERNAL_REFERENCE, t7_a_offerProposalItems_offerP.PRODUCT_LABEL, t7_a_offerProposalItems_offerP.PRODUCT_PROVIDER, t7_a_offerProposalItems_offerP.PRODUCT_DESCRIPTION, t7_a_offerProposalItems_offerP.PRODUCT_TYPE_ID, t8_a_offerProposalItems_offerP.ID, t8_a_offerProposalItems_offerP.SHORTCUT, t8_a_offerProposalItems_offerP.LABEL, t8_a_offerProposalItems_offerP.DESCRIPTION, t9_a_offerProposalItems_offerP.ID, t9_a_offerProposalItems_offerP.OPTION_NUMBER, t9_a_offerProposalItems_offerP.OPTION_EXTERNAL_REFERENCE, t9_a_offerProposalItems_offerP.OPTION_LABEL, t10_a_offerProposalCriteria.ID, t10_a_offerProposalCriteria.PROPOSAL_ID, t10_a_offerProposalCriteria.CRITERIA_TYPE_ID, t10_a_offerProposalCriteria.CRITERIA_VALUE, t11_a_offerChannelEntity.ID, t11_a_offerChannelEntity.SHORTCUT, t12_a_offerTypeGroupEntity.ID, t12_a_offerTypeGroupEntity.SHORTCUT, t13_a_offerTypeEntity.ID, t13_a_offerTypeEntity.SHORTCUT FROM OFFER_PROPOSAL t0_a LEFT OUTER JOIN OFFER_PROPOSAL_ITEM t1_a_offerProposalItems ON t0_a.ID=t1_a_offerProposalItems.PROPOSAL_ID LEFT OUTER JOIN OFFER_PROPOSAL_ITEM_CRITERIA t2_a_offerProposalItems_offerP ON t1_a_offerProposalItems.ID=t2_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID LEFT OUTER JOIN OFFER_PROCESS t3_a_offerProposalItems_proces ON t1_a_offerProposalItems.PROCESS_ID=t3_a_offerProposalItems_proces.ID LEFT OUTER JOIN OFFER_PROCESS_TYPE t4_a_offerProposalItems_proces ON t3_a_offerProposalItems_proces.PROCESS_TYPE_ID=t4_a_offerProposalItems_proces.ID LEFT OUTER JOIN OFFER_PROPOSAL_MAPPING t5_a_offerProposalItems_offerP ON t1_a_offerProposalItems.ID=t5_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID LEFT OUTER JOIN OFFER_PRODUCT_2_OFFER_OPTION t6_a_offerProposalItems_offerP ON t5_a_offerProposalItems_offerP.PRODUCT_MAPPING_ID=t6_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PRODUCT t7_a_offerProposalItems_offerP ON t6_a_offerProposalItems_offerP.PRODUCT_ID=t7_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PRODUCT_TYPE t8_a_offerProposalItems_offerP ON t7_a_offerProposalItems_offerP.PRODUCT_TYPE_ID=t8_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_OPTION t9_a_offerProposalItems_offerP ON t6_a_offerProposalItems_offerP.OPTION_ID=t9_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PROPOSAL_CRITERIA t10_a_offerProposalCriteria ON t0_a.ID=t10_a_offerProposalCriteria.PROPOSAL_ID LEFT OUTER JOIN OFFER_CHANNEL t11_a_offerChannelEntity ON t0_a.OFFER_CHANNEL_ID=t11_a_offerChannelEntity.ID LEFT OUTER JOIN OFFER_TYPE_GROUP t12_a_offerTypeGroupEntity ON t0_a.OFFER_TYPE_GROUP_ID=t12_a_offerTypeGroupEntity.ID LEFT OUTER JOIN OFFER_TYPE t13_a_offerTypeEntity ON t0_a.OFFER_TYPE_ID=t13_a_offerTypeEntity.ID WHERE (t0_a.DOMAIN = ? AND t0_a.CONTRACT_NO = ? AND t13_a_offerTypeEntity.ID = ? AND t0_a.OFFER_TYPE_ID=t13_a_offerTypeEntity.ID)
2008-06-10 12:53:52,639 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT DOMAIN, CONTRACT_NO, PARTY_NO, OFFER_PERIOD, VALID_FROM, VALID_TO, PROPOSAL_PERMISSION, OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?)
2008-06-10 12:53:52,686 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM WHERE (PROPOSAL_ID=?)
2008-06-10 12:53:53,142 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,189 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:53,221 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,284 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,331 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,378 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,441 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,504 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_LABEL, PROCESS_DESCRIPTION, PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:53,551 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM OFFER_PROCESS_TYPE WHERE (ID=?)
2008-06-10 12:53:53,614 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:53,661 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:53,708 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,756 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:53,787 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,834 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:53,866 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,913 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:53,976 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,023 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,070 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,117 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:54,180 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:54,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:54,274 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,322 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:54,353 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,400 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:54,432 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,479 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,526 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,573 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,636 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,683 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:54,731 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:54,778 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:54,841 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,888 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:54,919 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:54,951 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:54,982 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:55,045 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:55,124 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,171 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,218 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,281 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,328 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,375 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,485 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,532 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,580 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.ItemCriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:53:55,643 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:55,690 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:55,768 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:55,816 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:55,894 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:55,941 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:56,020 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:56,067 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:56,130 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:56,193 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:56,256 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:56,319 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:56,382 INFO  [STDOUT] [RMI TCP Connection(3)-62.104.243.153] leer
2008-06-10 12:53:56,382 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:56,445 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:56,507 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:56,555 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:56,602 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:56,649 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:56,712 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:56,759 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:56,806 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:56,853 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:56,885 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:56,916 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:56,948 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,011 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,058 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,105 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,152 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,215 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:57,262 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:57,309 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:57,372 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,404 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:57,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,482 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:57,514 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,561 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,608 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,671 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,718 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,765 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:57,813 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:57,876 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:57,923 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:57,954 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:57,986 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:58,033 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:58,064 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:58,111 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:58,190 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:58,237 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:58,300 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:58,363 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:58,426 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:58,489 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:58,552 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:58,599 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:58,677 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:58,725 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:58,788 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ITEM_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
2008-06-10 12:53:58,850 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ItemCriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM ITEM_CRITERIA_TYPE t0_a
2008-06-10 12:53:58,913 INFO  [STDOUT] [RMI TCP Connection(3)-62.104.243.153] leer
2008-06-10 12:53:58,913 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:58,961 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,008 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,055 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,102 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,149 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:59,212 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:59,259 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:59,306 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,354 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:59,385 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,417 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:59,448 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,495 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,558 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,605 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,652 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,700 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:59,763 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:59,810 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:53:59,857 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,904 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:59,935 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:53:59,967 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:53:59,998 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,061 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,108 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,156 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,219 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,266 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:00,313 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:00,360 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:00,423 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,454 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:00,486 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,549 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:00,580 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,627 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,675 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,737 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,785 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:00,832 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:00,879 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:00,942 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:00,989 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,052 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:01,083 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,131 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:01,162 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,209 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,272 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,319 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,366 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,414 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:01,477 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:01,524 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:01,571 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,618 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:01,650 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,681 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:01,712 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,775 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,822 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,870 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,917 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:01,980 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:02,027 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:02,074 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:02,121 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,168 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:02,200 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,247 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:02,279 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,326 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,373 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,420 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,483 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,530 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:02,577 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:02,640 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:02,687 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,719 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:02,750 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,797 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:02,829 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,876 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,923 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:02,986 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,033 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,080 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:03,143 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:03,191 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:03,238 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,285 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:03,316 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,364 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:03,395 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,442 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,505 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,552 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,599 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,662 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:03,709 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:03,757 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:03,804 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,851 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:03,882 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:03,930 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:03,961 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,008 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,055 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,118 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,166 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,213 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:04,276 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:04,323 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:04,370 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,417 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:04,449 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,480 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:04,511 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,559 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,622 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,669 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,716 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,763 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:04,826 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:04,873 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:04,936 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:04,967 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:04,999 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,046 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:05,078 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,125 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,172 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,219 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,282 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,329 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:05,376 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:05,424 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:05,486 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,518 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:05,549 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,596 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:05,628 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,675 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,738 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,785 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,848 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:05,895 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:05,942 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:05,990 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:06,053 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,084 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:06,115 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,163 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:06,194 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,241 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,288 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,351 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,398 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,446 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:06,493 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:06,556 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:06,603 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,634 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:06,666 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,713 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:06,744 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,792 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,854 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,902 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:06,949 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,012 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:07,059 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:07,106 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:07,153 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,200 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:07,232 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,279 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:07,311 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,358 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,405 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,452 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,499 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,562 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:07,609 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:07,656 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:07,704 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,751 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:07,782 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,829 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:07,861 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,908 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:07,955 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,002 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,065 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,112 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:08,160 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:08,207 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:08,270 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,301 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:08,333 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,380 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:08,411 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,458 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,506 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,569 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,616 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,663 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:08,710 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:08,757 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:08,820 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,852 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:08,883 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:08,930 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:08,962 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:09,009 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:09,056 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:09,119 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:09,166 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:09,213 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:09,276 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:09,323 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProcessEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
2008-06-10 12:54:09,370 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
2008-06-10 12:54:09,418 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalItemEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSAL_ITEM_ID=?)
2008-06-10 12:54:09,449 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.OfferProposalEntityBean] [RMI TCP Connection(3)-62.104.243.153] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_CRITERIA WHERE (PROPOSAL_ID=?)
2008-06-10 12:54:09,496 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
2008-06-10 12:54:09,559 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:54:09,622 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:09,669 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:09,716 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:09,779 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:09,827 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:09,874 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:09,921 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:09,984 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:10,031 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.CriteriaTypeEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?)
2008-06-10 12:54:10,078 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
2008-06-10 12:54:10,141 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:54:10,204 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
2008-06-10 12:54:10,251 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:54:10,314 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
2008-06-10 12:54:10,361 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:54:10,424 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
2008-06-10 12:54:10,471 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:54:10,518 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
2008-06-10 12:54:10,581 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:54:10,628 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
2008-06-10 12:54:10,691 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:54:10,739 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferProposalCriteriaEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID, CRITERIA_VALUE FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
2008-06-10 12:54:10,801 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CriteriaTypeEntityBean#findAll] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_a.ID FROM CRITERIA_TYPE t0_a
2008-06-10 12:54:10,864 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferChannelEntityBean#findByPrimaryKey] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_OfferChannelEntityBean.ID FROM OFFER_CHANNEL t0_OfferChannelEntityBean WHERE t0_OfferChannelEntityBean.ID=?
2008-06-10 12:54:10,912 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferChannelEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT FROM OFFER_CHANNEL WHERE (ID=?)
2008-06-10 12:54:10,959 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferTypeEntityBean#findByPrimaryKey] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_OfferTypeEntityBean.ID FROM OFFER_TYPE t0_OfferTypeEntityBean WHERE t0_OfferTypeEntityBean.ID=?
2008-06-10 12:54:11,022 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.OfferTypeGroupEntityBean#findByPrimaryKey] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT t0_OfferTypeGroupEntityBean.ID FROM OFFER_TYPE_GROUP t0_OfferTypeGroupEntityBean WHERE t0_OfferTypeGroupEntityBean.ID=?
2008-06-10 12:54:11,069 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.OfferTypeGroupEntityBean] [RMI TCP Connection(3)-62.104.243.153] Executing SQL: SELECT SHORTCUT FROM OFFER_TYPE_GROUP WHERE (ID=?)