-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 
  Previous topic | Next topic 
Author Message
lsacco
 Post subject: Composite key being serialized but Oracle expects "NUMB
PostPosted: Wed Jan 25, 2006 4:43 pm 
Regular
Regular

Joined: Thu Jul 01, 2004 12:13 am
Posts: 68
Location: San Diego, CA
Hello,

I have a composite key of three foreign keys, which are generated by sequences in those ajoining tables. I watch the SQL flow through: first creates the IDs from the sequences, then calls the INSERT INTOs for the ajoining tables, and then attempts to INSERT INTO the n-ary table.

However, when it tries to do this, Oracle throws an exception saying I'm trying to pass binary data into a number field. I have read a lot of information on this and I believe my mappings are set up properly, but I am not sure why Hibernate isn't extracting the number from the object to send along instead of the whole object. Does anyone see have a better understanding of how I can accomplish this?

Thanks and kind regards,
Lou

Hibernate version:
3.1.1

Mapping documents:
Code:
<hibernate-mapping package="com.qualcomm.pds.common.services.applog.bo">
   <class
      name="LogTypeUser"
      table="LOG_TYPE_USER"
   >
      <composite-id name="id" class="LogTypeUserPK">
         <key-property name="logApp" column="LOG_APP_ID"/>
         <key-property name="logType" column="LOG_TYPE_ID"/>
         <key-property name="logUser" column="LOG_USER_ID"/>
      </composite-id>
      <version name="olvn" column="OLVN" type="java.lang.Long" unsaved-value="null"/>

      <property
         name="notificationInterval"
         column="NOTIFICATION_INTERVAL"
         type="string"
         not-null="true"
         length="20"
      />
      <many-to-one
         name="logApp"
         class="LogApp"
         cascade="save-update"
         insert="false"
         update="false"
      >
      <column name="LOG_APP_ID"/>
      </many-to-one>
      <many-to-one
         name="logType"
         class="LogType"
         insert="false"
         cascade="save-update"
         update="false"
      >      
      <column name="LOG_TYPE_ID"/>
      </many-to-one>
      <many-to-one
         name="logUser"
         class="LogUser"
         cascade="save-update"
         insert="false"
         update="false"
      >
      <column name="LOG_USER_ID"/>
      </many-to-one>
   </class>   
</hibernate-mapping>


Similar mappings for the Set in the ajoining tables as follows:
Code:
      <set name="logTypeUsers" inverse="true" lazy="true">      
         <key>
            <column name="LOG_TYPE_ID"/>
         </key>
         <one-to-many class="LogTypeUser"/>
      </set>

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
Code:
java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

   at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
   at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
   at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1007)
   at org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate(HibernateTemplate.java:788)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)
   at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:786)
   at com.qualcomm.pds.common.services.applog.dao.spring.base.BaseSpringHibernateDAO.flushHibernateSession(BaseSpringHibernateDAO.java:264)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:324)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
   at com.qualcomm.pds.common.services.applog.aspects.ExceptionInterceptor.invoke(ExceptionInterceptor.java:61)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
   at $Proxy3.flushHibernateSession(Unknown Source)
   at com.qualcomm.pds.common.services.applog.service.impl.AppLogSrvcFacade.saveLogTypeUserApp(AppLogSrvcFacade.java:48)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:324)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
   at $Proxy4.saveLogTypeUserApp(Unknown Source)
   at com.qualcomm.pds.common.services.applog.test.AppLogSrvcFacadeTest.testSaveLogType(AppLogSrvcFacadeTest.java:48)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:324)
   at junit.framework.TestCase.runTest(TestCase.java:154)
   at junit.framework.TestCase.runBare(TestCase.java:127)
   at junit.framework.TestResult$1.protect(TestResult.java:106)
   at junit.framework.TestResult.runProtected(TestResult.java:124)
   at junit.framework.TestResult.run(TestResult.java:109)
   at junit.framework.TestCase.run(TestCase.java:118)
   at junit.framework.TestSuite.runTest(TestSuite.java:208)
   at junit.framework.TestSuite.run(TestSuite.java:203)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
12:26:29,328  WARN JDBCExceptionReporter:71 - SQL Error: 932, SQLState: 42000
12:26:29,328 ERROR JDBCExceptionReporter:72 - ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

Name and version of the database you are using:
Oracle 9i
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:
Code:
Hibernate: insert into LOG_TYPE_USER (OLVN, NOTIFICATION_INTERVAL, LOG_APP_ID, LOG_TYPE_ID, LOG_USER_ID) values (?, ?, ?, ?, ?)
12:26:29,000 DEBUG AbstractBatcher:424 - preparing statement
12:26:29,156 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogApp@867f716a]
12:26:29,171 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogType@45f46c99]
12:26:29,171 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogUser@70087a67]
12:26:29,171 DEBUG AbstractEntityPersister:1821 - Dehydrating entity: [com.qualcomm.pds.common.services.applog.bo.LogTypeUser#component[logApp,logType,logUser]{logApp=2c6d8085f3f280b1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1f0f08080808080808081828080f8f280bae3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1f0f08080808080808081828089c98088e8e1f3e8c3efe4e5cc8087e1f0f0cee1ede5f48092cceae1f6e1afece1eee7afd3f4f2e9eee7bbcc8084e4e5f0f4f180fe8082cc8082e9e4f48090cceae1f6e1afece1eee7afccefeee7bbcc808aecefe7c1e3f4e9efeef3f4808fcceae1f6e1aff5f4e9ecafd3e5f4bbcc808becefe7cde5f3f3e1e7e5f3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc808aedefe4f5ece5cee1ede5f180fe8082cc8084efecf6eef180fe8083f8f006fff1eaf48097d0c4d3a0ccefe7e7e9eee7a0e1f0f0ece9e3e1f4e9efeef48084b3b5b2b7f3f2808eeae1f6e1aeece1eee7aeccefeee7bb0b64104c0fa35f828081ca8085f6e1ecf5e5f8f28090eae1f6e1aeece1eee7aecef5ede2e5f2062c159d8b14600b828080f8f08080808080808090f3f280a6eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaed0e5f2f3e9f3f4e5eef4d3e5f4e7c8740210692ae8828081cc8083f3e5f4f180fe8084f8f280b5eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaec1e2f3f4f2e1e3f4d0e5f2f3e9f3f4e5eef4c3efecece5e3f4e9efeee90164ec491bb0b3828087c9808ae3e1e3e8e5e4d3e9fae5da8085e4e9f2f4f9da808be9eee9f4e9e1ece9fae5e4cc8083ebe5f9f48096cceae1f6e1afe9efafd3e5f2e9e1ece9fae1e2ece5bbcc8085eff7eee5f2f48092cceae1f6e1afece1eee7afcfe2eae5e3f4bbcc8084f2efece5f180fe8082cc808ef3f4eff2e5e4d3eee1f0f3e8eff4f180fe808df8f07f7f7f7f8081f0f180fe8085f0f3f28091eae1f6e1aef5f4e9ecaec8e1f3e8cde1f085875a414396e051838082c6808aecefe1e4c6e1e3f4eff2c98089f4e8f2e5f3e8efece4f8f0bfc0808080808081f7888080808280808081f3f280b4e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1e3f4e9efee8080808080808081828080f8f280bde3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1e3f4e9efee8080808080808081828086c98088e8e1f3e8c3efe4e5cc8082e9e4f180fe8083cc8086ecefe7c1f0f0f480b3cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7c1f0f0bbcc808decefe7d2e5f3efecf5f4e9efeef180fe8082cc8087ecefe7d4f9f0e5f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5bbcc8084efecf6eef180fe8083f8f009100f9df3f180fe80888080808080808090f180fe8085f4809dc3efeef4e1e3f4a0cceff5a0d3e1e3e3efa0e6eff2a0e4e5f4e1e9ecf3f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e58080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e58080808080808081828087c98088e8e1f3e8c3efe4e5cc808be4e5f3e3f2e9f0f4e9efeef180fe8082cc8082e9e4f180fe8083cc808aecefe7c1e3f4e9efeef3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc808df0f5f2e7e5c9eef4e5f2f6e1ecf48093cceae1f6e1afece1eee7afc9eef4e5e7e5f2bbf8f0c574ec19f4808dc7e5eee5f2e1eca0c5f2f2eff2f3f180fe80888080808080808090f3f180fe808b7f7f7f7f8081f0f180fe809cf0f3f180fe8090bfc0808080808081f7888080808280808081f180fe8096f180fe8096f8f3f28091eae1f6e1aef5f4e9ecaed4f2e5e5d3e5f45d18d013156d07db838080f8f0f0f78480808081f180fe8096f8f3f180fe808b7f7f7f7f8081f0f180fe809cf0f3f180fe8090bfc0808080808081f7888080808280808081f3f280b6e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f28080808080808081828080f8f280bfe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f28080808080808081828087c98088e8e1f3e8c3efe4e5cc8082e9e4f480bacce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5d5f3e5f2d0cbbbcc8086ecefe7c1f0f0f180fe8094cc8087ecefe7d4f9f0e5f180fe8095cc8087ecefe7d5f3e5f2f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d5f3e5f2bbcc8094eeeff4e9e6e9e3e1f4e9efeec9eef4e5f2f6e1ecf180fe8082cc8084efecf6eef180fe8083f8f00e7ab283f3f280b8e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f2d0cb8080808080808081828080f8f280c1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f2d0cb98dc15ad9caaa6ed828084c98088e8e1f3e8c3efe4e5cc8086ecefe7c1f0f0f180fe8094cc8087ecefe7d4f9f0e5f180fe8095cc8087ecefe7d5f3e5f2f180fe80a8f8f0d27db559f180fe8085f180fe809cf3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d5f3e5f28080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d5f3e5f28080808080808081828088c98088e8e1f3e8c3efe4e5cc8085e5ede1e9ecf180fe8082cc8085e6eee1ede5f180fe8082cc8082e9e4f180fe8083cc8085eceee1ede5f180fe8082cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc8086f5f3e5f2c9e4f180fe8082f8f0f088fae7f48093ecf3e1e3e3efc0f1f5e1ece3efededaee3efedf48083cceff5f3f180fe8088808080808080808ff48085d3e1e3e3eff3f180fe808b7f7f7f7f8081f0f180fe80aff0f3f180fe8090bfc0808080808081f7888080808280808081f180fe80a9f180fe80a9f8f3f180fe80a1f0f78480808081f180fe80a9f8f3f180fe80888080808080808080f48086ecf3e1e3e3eff180fe8085f180fe809cf180fe80aff48087cee9e7e8f4ecf9f180fe80b7f180fe80a9f8f3f180fe80a1f0f78480808081f180fe80a9f8f180fe80b7f3f28091eae1f6e1aeece1eee7aec9eef4e5e7e5f292622024770107b8828081c98085f6e1ecf5e5f8f180fe80898080809ef180fe80b7f180fe8096f8f3f180fe80a1f0f78480808081f180fe8096f8f0f3f180fe808b7f7f7f7f8081f0f180fe8085f0f3f180fe8090bfc0808080808081f7888080808280808081f180fe80a9f180fe80a9f8f3f180fe80a1f0f78480808081f180fe80a9f8f4808dccefe7e7e9eee7c3ece9e5eef4f180fe80b7, logType=2c6d8085f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e58080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e58080808080808081828087c98088e8e1f3e8c3efe4e5cc808be4e5f3e3f2e9f0f4e9efeef48092cceae1f6e1afece1eee7afd3f4f2e9eee7bbcc8082e9e4f48090cceae1f6e1afece1eee7afccefeee7bbcc808aecefe7c1e3f4e9efeef3f4808fcceae1f6e1aff5f4e9ecafd3e5f4bbcc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc808df0f5f2e7e5c9eef4e5f2f6e1ecf48093cceae1f6e1afece1eee7afc9eef4e5e7e5f2bbf8f0c574ec19f4808dc7e5eee5f2e1eca0c5f2f2eff2f3f2808eeae1f6e1aeece1eee7aeccefeee7bb0b64104c0fa35f828081ca8085f6e1ecf5e5f8f28090eae1f6e1aeece1eee7aecef5ede2e5f2062c159d8b14600b828080f8f08080808080808090f3f280a6eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaed0e5f2f3e9f3f4e5eef4d3e5f4e7c8740210692ae8828081cc8083f3e5f4f180fe8084f8f280b5eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaec1e2f3f4f2e1e3f4d0e5f2f3e9f3f4e5eef4c3efecece5e3f4e9efeee90164ec491bb0b3828087c9808ae3e1e3e8e5e4d3e9fae5da8085e4e9f2f4f9da808be9eee9f4e9e1ece9fae5e4cc8083ebe5f9f48096cceae1f6e1afe9efafd3e5f2e9e1ece9fae1e2ece5bbcc8085eff7eee5f2f48092cceae1f6e1afece1eee7afcfe2eae5e3f4bbcc8084f2efece5f180fe8082cc808ef3f4eff2e5e4d3eee1f0f3e8eff4f180fe808df8f07f7f7f7f8081f0f180fe8086f0f3f28091eae1f6e1aef5f4e9ecaec8e1f3e8cde1f085875a414396e051838082c6808aecefe1e4c6e1e3f4eff2c98089f4e8f2e5f3e8efece4f8f0bfc0808080808081f7888080808280808081f3f280b4e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1e3f4e9efee8080808080808081828080f8f280bde3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1e3f4e9efee8080808080808081828086c98088e8e1f3e8c3efe4e5cc8082e9e4f180fe8083cc8086ecefe7c1f0f0f480b3cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7c1f0f0bbcc808decefe7d2e5f3efecf5f4e9efeef180fe8082cc8087ecefe7d4f9f0e5f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5bbcc8084efecf6eef180fe8083f8f009100f9df3f180fe80888080808080808090f3f280b1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1f0f08080808080808081828080f8f280bae3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1f0f08080808080808081828089c98088e8e1f3e8c3efe4e5cc8087e1f0f0cee1ede5f180fe8082cc8084e4e5f0f4f180fe8082cc8082e9e4f180fe8083cc808aecefe7c1e3f4e9efeef3f180fe8084cc808becefe7cde5f3f3e1e7e5f3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc808aedefe4f5ece5cee1ede5f180fe8082cc8084efecf6eef180fe8083f8f006fff1eaf48097d0c4d3a0ccefe7e7e9eee7a0e1f0f0ece9e3e1f4e9efeef48084b3b5b2b7f3f180fe80888080808080808090f3f180fe808b7f7f7f7f8081f0f180fe809af0f3f180fe8090bfc0808080808081f7888080808280808081f180fe8096f180fe8096f8f3f28091eae1f6e1aef5f4e9ecaed4f2e5e5d3e5f45d18d013156d07db838080f8f0f0f78480808081f180fe8096f8f0f3f180fe808b7f7f7f7f8081f0f180fe809af0f3f180fe8090bfc0808080808081f7888080808280808081f3f280b6e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f28080808080808081828080f8f280bfe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f28080808080808081828087c98088e8e1f3e8c3efe4e5cc8082e9e4f480bacce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5d5f3e5f2d0cbbbcc8086ecefe7c1f0f0f180fe8094cc8087ecefe7d4f9f0e5f180fe8095cc8087ecefe7d5f3e5f2f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d5f3e5f2bbcc8094eeeff4e9e6e9e3e1f4e9efeec9eef4e5f2f6e1ecf180fe8082cc8084efecf6eef180fe8083f8f00e7ab283f3f280b8e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f2d0cb8080808080808081828080f8f280c1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f2d0cb98dc15ad9caaa6ed828084c98088e8e1f3e8c3efe4e5cc8086ecefe7c1f0f0f180fe8094cc8087ecefe7d4f9f0e5f180fe8095cc8087ecefe7d5f3e5f2f180fe80a7f8f0d27db559f180fe809af180fe8086f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d5f3e5f28080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d5f3e5f28080808080808081828088c98088e8e1f3e8c3efe4e5cc8085e5ede1e9ecf180fe8082cc8085e6eee1ede5f180fe8082cc8082e9e4f180fe8083cc8085eceee1ede5f180fe8082cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc8086f5f3e5f2c9e4f180fe8082f8f0f088fae7f48093ecf3e1e3e3efc0f1f5e1ece3efededaee3efedf48083cceff5f3f180fe8088808080808080808ff48085d3e1e3e3eff3f180fe808b7f7f7f7f8081f0f180fe80aef0f3f180fe8090bfc0808080808081f7888080808280808081f180fe80a8f180fe80a8f8f3f180fe80a0f0f78480808081f180fe80a8f8f3f180fe80888080808080808080f48086ecf3e1e3e3eff180fe809af180fe8086f180fe80aef48087cee9e7e8f4ecf9f180fe80b6f180fe80a8f8f3f180fe80a0f0f78480808081f180fe80a8f8f4808dccefe7e7e9eee7c3ece9e5eef4f180fe80b6f4809dc3efeef4e1e3f4a0cceff5a0d3e1e3e3efa0e6eff2a0e4e5f4e1e9ecf3f180fe8086f180fe80b6f180fe8096f8f3f180fe80a0f0f78480808081f180fe8096f8f3f180fe808b7f7f7f7f8081f0f180fe8086f0f3f180fe8090bfc0808080808081f7888080808280808081f180fe80a8f180fe80a8f8f3f180fe80a0f0f78480808081f180fe80a8f8f180fe80b6f3f28091eae1f6e1aeece1eee7aec9eef4e5e7e5f292622024770107b8828081c98085f6e1ecf5e5f8f180fe80898080809e, logUser=2c6d8085f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d5f3e5f28080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d5f3e5f28080808080808081828088c98088e8e1f3e8c3efe4e5cc8085e5ede1e9ecf48092cceae1f6e1afece1eee7afd3f4f2e9eee7bbcc8085e6eee1ede5f180fe8082cc8082e9e4f48090cceae1f6e1afece1eee7afccefeee7bbcc8085eceee1ede5f180fe8082cc808cecefe7d4f9f0e5d5f3e5f2f3f4808fcceae1f6e1aff5f4e9ecafd3e5f4bbcc8084efecf6eef180fe8083cc8086f5f3e5f2c9e4f180fe8082f8f0f088fae7f48093ecf3e1e3e3efc0f1f5e1ece3efededaee3efedf48083cceff5f3f2808eeae1f6e1aeece1eee7aeccefeee7bb0b64104c0fa35f828081ca8085f6e1ecf5e5f8f28090eae1f6e1aeece1eee7aecef5ede2e5f2062c159d8b14600b828080f8f0808080808080808ff48085d3e1e3e3eff3f280a6eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaed0e5f2f3e9f3f4e5eef4d3e5f4e7c8740210692ae8828081cc8083f3e5f4f180fe8084f8f280b5eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaec1e2f3f4f2e1e3f4d0e5f2f3e9f3f4e5eef4c3efecece5e3f4e9efeee90164ec491bb0b3828087c9808ae3e1e3e8e5e4d3e9fae5da8085e4e9f2f4f9da808be9eee9f4e9e1ece9fae5e4cc8083ebe5f9f48096cceae1f6e1afe9efafd3e5f2e9e1ece9fae1e2ece5bbcc8085eff7eee5f2f48092cceae1f6e1afece1eee7afcfe2eae5e3f4bbcc8084f2efece5f180fe8082cc808ef3f4eff2e5e4d3eee1f0f3e8eff4f180fe808ef8f07f7f7f7f8081f0f180fe8085f0f3f28091eae1f6e1aef5f4e9ecaec8e1f3e8cde1f085875a414396e051838082c6808aecefe1e4c6e1e3f4eff2c98089f4e8f2e5f3e8efece4f8f0bfc0808080808081f7888080808280808081f3f280b6e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f28080808080808081828080f8f280bfe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f28080808080808081828087c98088e8e1f3e8c3efe4e5cc8082e9e4f480bacce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5d5f3e5f2d0cbbbcc8086ecefe7c1f0f0f480b3cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7c1f0f0bbcc8087ecefe7d4f9f0e5f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5bbcc8087ecefe7d5f3e5f2f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d5f3e5f2bbcc8094eeeff4e9e6e9e3e1f4e9efeec9eef4e5f2f6e1ecf180fe8082cc8084efecf6eef180fe8083f8f00e7ab283f3f280b8e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f2d0cb8080808080808081828080f8f280c1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f2d0cb98dc15ad9caaa6ed828084c98088e8e1f3e8c3efe4e5cc8086ecefe7c1f0f0f180fe8096cc8087ecefe7d4f9f0e5f180fe8097cc8087ecefe7d5f3e5f2f180fe8098f8f0d27db559f3f280b1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1f0f08080808080808081828080f8f280bae3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1f0f08080808080808081828089c98088e8e1f3e8c3efe4e5cc8087e1f0f0cee1ede5f180fe8082cc8084e4e5f0f4f180fe8082cc8082e9e4f180fe8083cc808aecefe7c1e3f4e9efeef3f180fe8084cc808becefe7cde5f3f3e1e7e5f3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc808aedefe4f5ece5cee1ede5f180fe8082cc8084efecf6eef180fe8083f8f006fff1eaf48097d0c4d3a0ccefe7e7e9eee7a0e1f0f0ece9e3e1f4e9efeef48084b3b5b2b7f3f180fe80888080808080808090f3f180fe808c7f7f7f7f8081f0f180fe809ff0f3f180fe8091bfc0808080808081f7888080808280808081f3f280b4e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1e3f4e9efee8080808080808081828080f8f280bde3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1e3f4e9efee8080808080808081828086c98088e8e1f3e8c3efe4e5cc8082e9e4f180fe8083cc8086ecefe7c1f0f0f180fe8096cc808decefe7d2e5f3efecf5f4e9efeef180fe8082cc8087ecefe7d4f9f0e5f180fe8097cc8084efecf6eef180fe8083f8f009100f9df3f180fe80888080808080808090f180fe809ff4809dc3efeef4e1e3f4a0cceff5a0d3e1e3e3efa0e6eff2a0e4e5f4e1e9ecf3f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e58080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e58080808080808081828087c98088e8e1f3e8c3efe4e5cc808be4e5f3e3f2e9f0f4e9efeef180fe8082cc8082e9e4f180fe8083cc808aecefe7c1e3f4e9efeef3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc808df0f5f2e7e5c9eef4e5f2f6e1ecf48093cceae1f6e1afece1eee7afc9eef4e5e7e5f2bbf8f0c574ec19f4808dc7e5eee5f2e1eca0c5f2f2eff2f3f180fe80888080808080808090f3f180fe808c7f7f7f7f8081f0f180fe80adf0f3f180fe8091bfc0808080808081f7888080808280808081f180fe80a7f180fe80a7f8f3f28091eae1f6e1aef5f4e9ecaed4f2e5e5d3e5f45d18d013156d07db838080f8f0f0f78480808081f180fe80a7f8f3f180fe808c7f7f7f7f8081f0f180fe80adf0f3f180fe8091bfc0808080808081f7888080808280808081f180fe8099f180fe8099f8f3f180fe80b2f0f78480808081f180fe8099f8f3f180fe80888080808080808080f3f28091eae1f6e1aeece1eee7aec9eef4e5e7e5f292622024770107b8828081c98085f6e1ecf5e5f8f180fe80898080809ef180fe80b7f180fe80a7f8f3f180fe80b2f0f78480808081f180fe80a7f8f0f3f180fe808c7f7f7f7f8081f0f180fe809ff0f3f180fe8091bfc0808080808081f7888080808280808081f180fe8099f180fe8099f8f3f180fe80b2f0f78480808081f180fe8099f8f4808dccefe7e7e9eee7c3ece9e5eef4f180fe80b7f180fe80adf180fe8085f180fe809ff180fe80adf180fe8085f48087cee9e7e8f4ecf9f180fe80b7f180fe8099f8f3f180fe80b2f0f78480808081f180fe8099f8f180fe80b7f48086ecf3e1e3e3ef}]
12:26:29,187 DEBUG LongType:79 - binding '0' to parameter: 1
12:26:29,187 DEBUG StringType:79 - binding 'Nightly' to parameter: 2
12:26:29,187 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogApp@867f716a]
12:26:29,187 DEBUG SerializableType:79 - binding '2c6d8085f3f280b1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1f0f08080808080808081828080f8f280bae3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1f0f08080808080808081828089c98088e8e1f3e8c3efe4e5cc8087e1f0f0cee1ede5f48092cceae1f6e1afece1eee7afd3f4f2e9eee7bbcc8084e4e5f0f4f180fe8082cc8082e9e4f48090cceae1f6e1afece1eee7afccefeee7bbcc808aecefe7c1e3f4e9efeef3f4808fcceae1f6e1aff5f4e9ecafd3e5f4bbcc808becefe7cde5f3f3e1e7e5f3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc808aedefe4f5ece5cee1ede5f180fe8082cc8084efecf6eef180fe8083f8f006fff1eaf48097d0c4d3a0ccefe7e7e9eee7a0e1f0f0ece9e3e1f4e9efeef48084b3b5b2b7f3f2808eeae1f6e1aeece1eee7aeccefeee7bb0b64104c0fa35f828081ca8085f6e1ecf5e5f8f28090eae1f6e1aeece1eee7aecef5ede2e5f2062c159d8b14600b828080f8f08080808080808090f3f280a6eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaed0e5f2f3e9f3f4e5eef4d3e5f4e7c8740210692ae8828081cc8083f3e5f4f180fe8084f8f280b5eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaec1e2f3f4f2e1e3f4d0e5f2f3e9f3f4e5eef4c3efecece5e3f4e9efeee90164ec491bb0b3828087c9808ae3e1e3e8e5e4d3e9fae5da8085e4e9f2f4f9da808be9eee9f4e9e1ece9fae5e4cc8083ebe5f9f48096cceae1f6e1afe9efafd3e5f2e9e1ece9fae1e2ece5bbcc8085eff7eee5f2f48092cceae1f6e1afece1eee7afcfe2eae5e3f4bbcc8084f2efece5f180fe8082cc808ef3f4eff2e5e4d3eee1f0f3e8eff4f180fe808df8f07f7f7f7f8081f0f180fe8085f0f3f28091eae1f6e1aef5f4e9ecaec8e1f3e8cde1f085875a414396e051838082c6808aecefe1e4c6e1e3f4eff2c98089f4e8f2e5f3e8efece4f8f0bfc0808080808081f7888080808280808081f3f280b4e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1e3f4e9efee8080808080808081828080f8f280bde3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1e3f4e9efee8080808080808081828086c98088e8e1f3e8c3efe4e5cc8082e9e4f180fe8083cc8086ecefe7c1f0f0f480b3cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7c1f0f0bbcc808decefe7d2e5f3efecf5f4e9efeef180fe8082cc8087ecefe7d4f9f0e5f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5bbcc8084efecf6eef180fe8083f8f009100f9df3f180fe80888080808080808090f180fe8085f4809dc3efeef4e1e3f4a0cceff5a0d3e1e3e3efa0e6eff2a0e4e5f4e1e9ecf3f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e58080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e58080808080808081828087c98088e8e1f3e8c3efe4e5cc808be4e5f3e3f2e9f0f4e9efeef180fe8082cc8082e9e4f180fe8083cc808aecefe7c1e3f4e9efeef3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc808df0f5f2e7e5c9eef4e5f2f6e1ecf48093cceae1f6e1afece1eee7afc9eef4e5e7e5f2bbf8f0c574ec19f4808dc7e5eee5f2e1eca0c5f2f2eff2f3f180fe80888080808080808090f3f180fe808b7f7f7f7f8081f0f180fe809cf0f3f180fe8090bfc0808080808081f7888080808280808081f180fe8096f180fe8096f8f3f28091eae1f6e1aef5f4e9ecaed4f2e5e5d3e5f45d18d013156d07db838080f8f0f0f78480808081f180fe8096f8f3f180fe808b7f7f7f7f8081f0f180fe809cf0f3f180fe8090bfc0808080808081f7888080808280808081f3f280b6e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f28080808080808081828080f8f280bfe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f28080808080808081828087c98088e8e1f3e8c3efe4e5cc8082e9e4f480bacce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5d5f3e5f2d0cbbbcc8086ecefe7c1f0f0f180fe8094cc8087ecefe7d4f9f0e5f180fe8095cc8087ecefe7d5f3e5f2f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d5f3e5f2bbcc8094eeeff4e9e6e9e3e1f4e9efeec9eef4e5f2f6e1ecf180fe8082cc8084efecf6eef180fe8083f8f00e7ab283f3f280b8e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f2d0cb8080808080808081828080f8f280c1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f2d0cb98dc15ad9caaa6ed828084c98088e8e1f3e8c3efe4e5cc8086ecefe7c1f0f0f180fe8094cc8087ecefe7d4f9f0e5f180fe8095cc8087ecefe7d5f3e5f2f180fe80a8f8f0d27db559f180fe8085f180fe809cf3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d5f3e5f28080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d5f3e5f28080808080808081828088c98088e8e1f3e8c3efe4e5cc8085e5ede1e9ecf180fe8082cc8085e6eee1ede5f180fe8082cc8082e9e4f180fe8083cc8085eceee1ede5f180fe8082cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc8086f5f3e5f2c9e4f180fe8082f8f0f088fae7f48093ecf3e1e3e3efc0f1f5e1ece3efededaee3efedf48083cceff5f3f180fe8088808080808080808ff48085d3e1e3e3eff3f180fe808b7f7f7f7f8081f0f180fe80aff0f3f180fe8090bfc0808080808081f7888080808280808081f180fe80a9f180fe80a9f8f3f180fe80a1f0f78480808081f180fe80a9f8f3f180fe80888080808080808080f48086ecf3e1e3e3eff180fe8085f180fe809cf180fe80aff48087cee9e7e8f4ecf9f180fe80b7f180fe80a9f8f3f180fe80a1f0f78480808081f180fe80a9f8f180fe80b7f3f28091eae1f6e1aeece1eee7aec9eef4e5e7e5f292622024770107b8828081c98085f6e1ecf5e5f8f180fe80898080809ef180fe80b7f180fe8096f8f3f180fe80a1f0f78480808081f180fe8096f8f0f3f180fe808b7f7f7f7f8081f0f180fe8085f0f3f180fe8090bfc0808080808081f7888080808280808081f180fe80a9f180fe80a9f8f3f180fe80a1f0f78480808081f180fe80a9f8f4808dccefe7e7e9eee7c3ece9e5eef4f180fe80b7' to parameter: 3
12:26:29,187 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogApp@867f716a]
12:26:29,187 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogType@45f46c99]
12:26:29,187 DEBUG SerializableType:79 - binding '2c6d8085f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e58080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e58080808080808081828087c98088e8e1f3e8c3efe4e5cc808be4e5f3e3f2e9f0f4e9efeef48092cceae1f6e1afece1eee7afd3f4f2e9eee7bbcc8082e9e4f48090cceae1f6e1afece1eee7afccefeee7bbcc808aecefe7c1e3f4e9efeef3f4808fcceae1f6e1aff5f4e9ecafd3e5f4bbcc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc808df0f5f2e7e5c9eef4e5f2f6e1ecf48093cceae1f6e1afece1eee7afc9eef4e5e7e5f2bbf8f0c574ec19f4808dc7e5eee5f2e1eca0c5f2f2eff2f3f2808eeae1f6e1aeece1eee7aeccefeee7bb0b64104c0fa35f828081ca8085f6e1ecf5e5f8f28090eae1f6e1aeece1eee7aecef5ede2e5f2062c159d8b14600b828080f8f08080808080808090f3f280a6eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaed0e5f2f3e9f3f4e5eef4d3e5f4e7c8740210692ae8828081cc8083f3e5f4f180fe8084f8f280b5eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaec1e2f3f4f2e1e3f4d0e5f2f3e9f3f4e5eef4c3efecece5e3f4e9efeee90164ec491bb0b3828087c9808ae3e1e3e8e5e4d3e9fae5da8085e4e9f2f4f9da808be9eee9f4e9e1ece9fae5e4cc8083ebe5f9f48096cceae1f6e1afe9efafd3e5f2e9e1ece9fae1e2ece5bbcc8085eff7eee5f2f48092cceae1f6e1afece1eee7afcfe2eae5e3f4bbcc8084f2efece5f180fe8082cc808ef3f4eff2e5e4d3eee1f0f3e8eff4f180fe808df8f07f7f7f7f8081f0f180fe8086f0f3f28091eae1f6e1aef5f4e9ecaec8e1f3e8cde1f085875a414396e051838082c6808aecefe1e4c6e1e3f4eff2c98089f4e8f2e5f3e8efece4f8f0bfc0808080808081f7888080808280808081f3f280b4e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1e3f4e9efee8080808080808081828080f8f280bde3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1e3f4e9efee8080808080808081828086c98088e8e1f3e8c3efe4e5cc8082e9e4f180fe8083cc8086ecefe7c1f0f0f480b3cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7c1f0f0bbcc808decefe7d2e5f3efecf5f4e9efeef180fe8082cc8087ecefe7d4f9f0e5f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5bbcc8084efecf6eef180fe8083f8f009100f9df3f180fe80888080808080808090f3f280b1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1f0f08080808080808081828080f8f280bae3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1f0f08080808080808081828089c98088e8e1f3e8c3efe4e5cc8087e1f0f0cee1ede5f180fe8082cc8084e4e5f0f4f180fe8082cc8082e9e4f180fe8083cc808aecefe7c1e3f4e9efeef3f180fe8084cc808becefe7cde5f3f3e1e7e5f3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc808aedefe4f5ece5cee1ede5f180fe8082cc8084efecf6eef180fe8083f8f006fff1eaf48097d0c4d3a0ccefe7e7e9eee7a0e1f0f0ece9e3e1f4e9efeef48084b3b5b2b7f3f180fe80888080808080808090f3f180fe808b7f7f7f7f8081f0f180fe809af0f3f180fe8090bfc0808080808081f7888080808280808081f180fe8096f180fe8096f8f3f28091eae1f6e1aef5f4e9ecaed4f2e5e5d3e5f45d18d013156d07db838080f8f0f0f78480808081f180fe8096f8f0f3f180fe808b7f7f7f7f8081f0f180fe809af0f3f180fe8090bfc0808080808081f7888080808280808081f3f280b6e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f28080808080808081828080f8f280bfe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f28080808080808081828087c98088e8e1f3e8c3efe4e5cc8082e9e4f480bacce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5d5f3e5f2d0cbbbcc8086ecefe7c1f0f0f180fe8094cc8087ecefe7d4f9f0e5f180fe8095cc8087ecefe7d5f3e5f2f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d5f3e5f2bbcc8094eeeff4e9e6e9e3e1f4e9efeec9eef4e5f2f6e1ecf180fe8082cc8084efecf6eef180fe8083f8f00e7ab283f3f280b8e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f2d0cb8080808080808081828080f8f280c1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f2d0cb98dc15ad9caaa6ed828084c98088e8e1f3e8c3efe4e5cc8086ecefe7c1f0f0f180fe8094cc8087ecefe7d4f9f0e5f180fe8095cc8087ecefe7d5f3e5f2f180fe80a7f8f0d27db559f180fe809af180fe8086f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d5f3e5f28080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d5f3e5f28080808080808081828088c98088e8e1f3e8c3efe4e5cc8085e5ede1e9ecf180fe8082cc8085e6eee1ede5f180fe8082cc8082e9e4f180fe8083cc8085eceee1ede5f180fe8082cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc8086f5f3e5f2c9e4f180fe8082f8f0f088fae7f48093ecf3e1e3e3efc0f1f5e1ece3efededaee3efedf48083cceff5f3f180fe8088808080808080808ff48085d3e1e3e3eff3f180fe808b7f7f7f7f8081f0f180fe80aef0f3f180fe8090bfc0808080808081f7888080808280808081f180fe80a8f180fe80a8f8f3f180fe80a0f0f78480808081f180fe80a8f8f3f180fe80888080808080808080f48086ecf3e1e3e3eff180fe809af180fe8086f180fe80aef48087cee9e7e8f4ecf9f180fe80b6f180fe80a8f8f3f180fe80a0f0f78480808081f180fe80a8f8f4808dccefe7e7e9eee7c3ece9e5eef4f180fe80b6f4809dc3efeef4e1e3f4a0cceff5a0d3e1e3e3efa0e6eff2a0e4e5f4e1e9ecf3f180fe8086f180fe80b6f180fe8096f8f3f180fe80a0f0f78480808081f180fe8096f8f3f180fe808b7f7f7f7f8081f0f180fe8086f0f3f180fe8090bfc0808080808081f7888080808280808081f180fe80a8f180fe80a8f8f3f180fe80a0f0f78480808081f180fe80a8f8f180fe80b6f3f28091eae1f6e1aeece1eee7aec9eef4e5e7e5f292622024770107b8828081c98085f6e1ecf5e5f8f180fe80898080809e' to parameter: 4
12:26:29,187 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogType@45f46c99]
12:26:29,187 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogUser@70087a67]
12:26:29,203 DEBUG SerializableType:79 - binding '2c6d8085f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d5f3e5f28080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d5f3e5f28080808080808081828088c98088e8e1f3e8c3efe4e5cc8085e5ede1e9ecf48092cceae1f6e1afece1eee7afd3f4f2e9eee7bbcc8085e6eee1ede5f180fe8082cc8082e9e4f48090cceae1f6e1afece1eee7afccefeee7bbcc8085eceee1ede5f180fe8082cc808cecefe7d4f9f0e5d5f3e5f2f3f4808fcceae1f6e1aff5f4e9ecafd3e5f4bbcc8084efecf6eef180fe8083cc8086f5f3e5f2c9e4f180fe8082f8f0f088fae7f48093ecf3e1e3e3efc0f1f5e1ece3efededaee3efedf48083cceff5f3f2808eeae1f6e1aeece1eee7aeccefeee7bb0b64104c0fa35f828081ca8085f6e1ecf5e5f8f28090eae1f6e1aeece1eee7aecef5ede2e5f2062c159d8b14600b828080f8f0808080808080808ff48085d3e1e3e3eff3f280a6eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaed0e5f2f3e9f3f4e5eef4d3e5f4e7c8740210692ae8828081cc8083f3e5f4f180fe8084f8f280b5eff2e7aee8e9e2e5f2eee1f4e5aee3efecece5e3f4e9efeeaec1e2f3f4f2e1e3f4d0e5f2f3e9f3f4e5eef4c3efecece5e3f4e9efeee90164ec491bb0b3828087c9808ae3e1e3e8e5e4d3e9fae5da8085e4e9f2f4f9da808be9eee9f4e9e1ece9fae5e4cc8083ebe5f9f48096cceae1f6e1afe9efafd3e5f2e9e1ece9fae1e2ece5bbcc8085eff7eee5f2f48092cceae1f6e1afece1eee7afcfe2eae5e3f4bbcc8084f2efece5f180fe8082cc808ef3f4eff2e5e4d3eee1f0f3e8eff4f180fe808ef8f07f7f7f7f8081f0f180fe8085f0f3f28091eae1f6e1aef5f4e9ecaec8e1f3e8cde1f085875a414396e051838082c6808aecefe1e4c6e1e3f4eff2c98089f4e8f2e5f3e8efece4f8f0bfc0808080808081f7888080808280808081f3f280b6e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f28080808080808081828080f8f280bfe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f28080808080808081828087c98088e8e1f3e8c3efe4e5cc8082e9e4f480bacce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5d5f3e5f2d0cbbbcc8086ecefe7c1f0f0f480b3cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7c1f0f0bbcc8087ecefe7d4f9f0e5f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d4f9f0e5bbcc8087ecefe7d5f3e5f2f480b4cce3efedaff1f5e1ece3efededaff0e4f3afe3efededefeeaff3e5f2f6e9e3e5f3afe1f0f0ecefe7afe2efafccefe7d5f3e5f2bbcc8094eeeff4e9e6e9e3e1f4e9efeec9eef4e5f2f6e1ecf180fe8082cc8084efecf6eef180fe8083f8f00e7ab283f3f280b8e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e5d5f3e5f2d0cb8080808080808081828080f8f280c1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e5d5f3e5f2d0cb98dc15ad9caaa6ed828084c98088e8e1f3e8c3efe4e5cc8086ecefe7c1f0f0f180fe8096cc8087ecefe7d4f9f0e5f180fe8097cc8087ecefe7d5f3e5f2f180fe8098f8f0d27db559f3f280b1e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1f0f08080808080808081828080f8f280bae3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1f0f08080808080808081828089c98088e8e1f3e8c3efe4e5cc8087e1f0f0cee1ede5f180fe8082cc8084e4e5f0f4f180fe8082cc8082e9e4f180fe8083cc808aecefe7c1e3f4e9efeef3f180fe8084cc808becefe7cde5f3f3e1e7e5f3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc808aedefe4f5ece5cee1ede5f180fe8082cc8084efecf6eef180fe8083f8f006fff1eaf48097d0c4d3a0ccefe7e7e9eee7a0e1f0f0ece9e3e1f4e9efeef48084b3b5b2b7f3f180fe80888080808080808090f3f180fe808c7f7f7f7f8081f0f180fe809ff0f3f180fe8091bfc0808080808081f7888080808280808081f3f280b4e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7c1e3f4e9efee8080808080808081828080f8f280bde3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7c1e3f4e9efee8080808080808081828086c98088e8e1f3e8c3efe4e5cc8082e9e4f180fe8083cc8086ecefe7c1f0f0f180fe8096cc808decefe7d2e5f3efecf5f4e9efeef180fe8082cc8087ecefe7d4f9f0e5f180fe8097cc8084efecf6eef180fe8083f8f009100f9df3f180fe80888080808080808090f180fe809ff4809dc3efeef4e1e3f4a0cceff5a0d3e1e3e3efa0e6eff2a0e4e5f4e1e9ecf3f3f280b2e3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaeccefe7d4f9f0e58080808080808081828080f8f280bbe3efedaef1f5e1ece3efededaef0e4f3aee3efededefeeaef3e5f2f6e9e3e5f3aee1f0f0ecefe7aee2efaee2e1f3e5aec2e1f3e5ccefe7d4f9f0e58080808080808081828087c98088e8e1f3e8c3efe4e5cc808be4e5f3e3f2e9f0f4e9efeef180fe8082cc8082e9e4f180fe8083cc808aecefe7c1e3f4e9efeef3f180fe8084cc808cecefe7d4f9f0e5d5f3e5f2f3f180fe8084cc8084efecf6eef180fe8083cc808df0f5f2e7e5c9eef4e5f2f6e1ecf48093cceae1f6e1afece1eee7afc9eef4e5e7e5f2bbf8f0c574ec19f4808dc7e5eee5f2e1eca0c5f2f2eff2f3f180fe80888080808080808090f3f180fe808c7f7f7f7f8081f0f180fe80adf0f3f180fe8091bfc0808080808081f7888080808280808081f180fe80a7f180fe80a7f8f3f28091eae1f6e1aef5f4e9ecaed4f2e5e5d3e5f45d18d013156d07db838080f8f0f0f78480808081f180fe80a7f8f3f180fe808c7f7f7f7f8081f0f180fe80adf0f3f180fe8091bfc0808080808081f7888080808280808081f180fe8099f180fe8099f8f3f180fe80b2f0f78480808081f180fe8099f8f3f180fe80888080808080808080f3f28091eae1f6e1aeece1eee7aec9eef4e5e7e5f292622024770107b8828081c98085f6e1ecf5e5f8f180fe80898080809ef180fe80b7f180fe80a7f8f3f180fe80b2f0f78480808081f180fe80a7f8f0f3f180fe808c7f7f7f7f8081f0f180fe809ff0f3f180fe8091bfc0808080808081f7888080808280808081f180fe8099f180fe8099f8f3f180fe80b2f0f78480808081f180fe8099f8f4808dccefe7e7e9eee7c3ece9e5eef4f180fe80b7f180fe80adf180fe8085f180fe809ff180fe80adf180fe8085f48087cee9e7e8f4ecf9f180fe80b7f180fe8099f8f3f180fe80b2f0f78480808081f180fe8099f8f180fe80b7f48086ecf3e1e3e3ef' to parameter: 5
12:26:29,203 DEBUG SerializationHelper:141 - Starting serialization of object [com.qualcomm.pds.common.services.applog.bo.LogUser@70087a67]
12:26:29,203 DEBUG AbstractBatcher:28 - Adding to batch
12:26:29,203 DEBUG AbstractBatcher:55 - Executing batch size: 1
12:26:29,312 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
12:26:29,312 DEBUG AbstractBatcher:470 - closing statement
Jan 25, 2006 12:26:29 PM com.qualcomm.pds.common.services.applog.aspects.ExceptionInterceptor invoke
SEVERE: ExceptionInterceptor::NestedRuntimeException: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute JDBC batch update; bad SQL grammar [insert into LOG_TYPE_USER (OLVN, NOTIFICATION_INTERVAL, LOG_APP_ID, LOG_TYPE_ID, LOG_USER_ID) values (?, ?, ?, ?, ?)]; nested exception is java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY

Jan 25, 2006 12:26:29 PM com.qualcomm.pds.common.services.applog.aspects.ExceptionInterceptor invoke
FINE: #### The results for method: package java.lang.reflect, Java Platform API Specification, version 1.4.flushHibernateSession ####
1,218 ms. (Hits=1  Avg=1,218 ms. Total=1,218 ms. Min=1,218 ms. Max=1,218 ms. Active=0  Avg Active=1  Max Active=1  First access=1/25/06 12:26:28 PM  Last access=1/25/06 12:26:29 PM  )
12:26:29,328 DEBUG JDBCExceptionReporter:63 - Could not execute JDBC batch update [insert into LOG_TYPE_USER (OLVN, NOTIFICATION_INTERVAL, LOG_APP_ID, LOG_TYPE_ID, LOG_USER_ID) values (?, ?, ?, ?, ?)]
java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
[/code]
Top
 Profile  
 
tenwit
 Post subject:
PostPosted: Wed Jan 25, 2006 5:39 pm 
Expert
Expert

Joined: Thu Dec 23, 2004 9:08 pm
Posts: 2008
Your composite key is composed of whatever's returned from getLogApp, getLogType and getLogUser. These are objects. You want them to be the IDs of those objects. You'll need to get six new methods to LogTypeUser.class: accessors and mutators for LogAddId, LogTypeId and LogUserId. Then specify those in the name attributes of your key-property elements.

I'm a bit surprised that you can use the LOG_APP_ID etc. columns more than once. It must be a special property of keys, because normally you can't use columns more than once. For your many-to-ones, I'd have used the formula element instead of the column element.
Top
 Profile  
 
lsacco
 Post subject:
PostPosted: Wed Jan 25, 2006 6:08 pm 
Regular
Regular

Joined: Thu Jul 01, 2004 12:13 am
Posts: 68
Location: San Diego, CA
Ahhh...the documentation doesn't have the type attribute (the DTD requires it) in it so I construed this to mean the class. But now this yields a new error - cannot insert NULL Key.

So now my mapping looks as follows:

Code:
<hibernate-mapping package="com.qualcomm.pds.common.services.applog.bo">
   <class
      name="LogTypeUser"
      table="LOG_TYPE_USER"
   >
      <composite-id name="id" class="LogTypeUserPK">
         <key-property name="LOG_APP_ID" type="java.lang.Long"/>
         <key-property name="LOG_TYPE_ID" type="java.lang.Long"/>
         <key-property name="LOG_USER_ID" type="java.lang.Long"/>
      </composite-id>
      <version name="olvn" column="OLVN" type="java.lang.Long" unsaved-value="null"/>

      <property
         name="notificationInterval"
         column="NOTIFICATION_INTERVAL"
         type="string"
         not-null="true"
         length="20"
      />
      <many-to-one
         name="logApp"
         class="LogApp"
         cascade="save-update"
         insert="false"
         update="false"
      >
      <column name="LOG_APP_ID"/>
      </many-to-one>
      <many-to-one
         name="logType"
         class="LogType"
         insert="false"
         cascade="save-update"
         update="false"
      >      
      <column name="LOG_TYPE_ID"/>
      </many-to-one>
      <many-to-one
         name="logUser"
         class="LogUser"
         cascade="save-update"
         insert="false"
         update="false"
      >
      <column name="LOG_USER_ID"/>
      </many-to-one>
   </class>   
</hibernate-mapping>


The new error that I'm getting is as below. Since I'm using sequences to generate the keys for the ajoining tables, I'm not sure how I'm going to pull the value for these fields since they are created at runtime. Any suggestions?

The can't do this when setting up the PK class that's for sure:
Code:
LogTypeUserPK logTypeUserPK = new LogTypeUserPK();
        logTypeUserPK.setLOG_APP_ID(logApp.getId());
        logTypeUserPK.setLOG_TYPE_ID(logType.getId());
        logTypeUserPK.setLOG_USER_ID(logUser.getId());
        logTypeUser.setId(logTypeUserPK);


Code:
13:59:20,169 DEBUG SQL:346 - insert into LOG_TYPE_USER (OLVN, NOTIFICATION_INTERVAL, LOG_APP_ID, LOG_TYPE_ID, LOG_USER_ID) values (?, ?, ?, ?, ?)
Hibernate: insert into LOG_TYPE_USER (OLVN, NOTIFICATION_INTERVAL, LOG_APP_ID, LOG_TYPE_ID, LOG_USER_ID) values (?, ?, ?, ?, ?)
13:59:20,169 DEBUG AbstractBatcher:424 - preparing statement
13:59:20,169 DEBUG AbstractEntityPersister:1821 - Dehydrating entity: [com.qualcomm.pds.common.services.applog.bo.LogTypeUser#component[LOG_APP_ID,LOG_TYPE_ID,LOG_USER_ID]{LOG_APP_ID=null, LOG_TYPE_ID=null, LOG_USER_ID=null}]
13:59:20,169 DEBUG LongType:79 - binding '0' to parameter: 1
13:59:20,169 DEBUG StringType:79 - binding 'Nightly' to parameter: 2
13:59:20,169 DEBUG LongType:71 - binding null to parameter: 3
13:59:20,169 DEBUG LongType:71 - binding null to parameter: 4
13:59:20,169 DEBUG LongType:71 - binding null to parameter: 5
13:59:20,169 DEBUG AbstractBatcher:28 - Adding to batch
13:59:20,169 DEBUG AbstractBatcher:55 - Executing batch size: 1
13:59:20,184 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
13:59:20,184 DEBUG AbstractBatcher:470 - closing statement
13:59:20,184 DEBUG JDBCExceptionReporter:63 - Could not execute JDBC batch update [insert into LOG_TYPE_USER (OLVN, NOTIFICATION_INTERVAL, LOG_APP_ID, LOG_TYPE_ID, LOG_USER_ID) values (?, ?, ?, ?, ?)]
java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("PDSCOMMON"."LOG_TYPE_USER"."LOG_USER_ID")
[/code]
Top
 Profile  
 
lsacco
 Post subject:
PostPosted: Wed Jan 25, 2006 7:35 pm 
Regular
Regular

Joined: Thu Jul 01, 2004 12:13 am
Posts: 68
Location: San Diego, CA
After some thought, I realizied it was best to first save the data in the adjoining tables to get the transient objects persistent and with a key value in their ID column. After that I was able to save the n-ary table by populating those key values in the composite-key class (see service layer code below).

I guess I was hoping the cascading would take care of it, but as it turns out, this is probably more desired for the Use Case I have.

Thanks for setting me off in the right direction!

Lou

Code:
        LogUser logUser = logTypeUser.getLogUser();
        logTypeDao.saveOrUpdate(logUser);
        LogApp logApp = logTypeUser.getLogApp();
        logTypeDao.saveOrUpdate(logApp);
        LogType logType = logTypeUser.getLogType();
        logTypeDao.saveOrUpdate(logType);

        LogTypeUserPK logTypeUserPK = new LogTypeUserPK();
        logTypeUserPK.setLOG_APP_ID(logApp.getId());
        logTypeUserPK.setLOG_TYPE_ID(logType.getId());
        logTypeUserPK.setLOG_USER_ID(logUser.getId());
        logTypeUser.setId(logTypeUserPK);
       
        logTypeDao.saveOrUpdate(logTypeUser);
        logTypeDao.flushHibernateSession();
Top
 Profile  
 
tenwit
 Post subject:
PostPosted: Wed Jan 25, 2006 9:04 pm 
Expert
Expert

Joined: Thu Dec 23, 2004 9:08 pm
Posts: 2008
Given that the ID of the LogTypeUser class is wholly dependent on the IDs of the three composing classes, there is no way around saving those composing classes first. I think that the only way you could get Hibernate to cascade the various ids correctly would be to have inverse="false" on one of the sets in the composing classes (LogApp, LogType, LogUser) and to enforce (in business logic) the rule that instances of your chosen class is always after the equivalent instances of the other two classes. Then code along these lines would work:
Code:
  logTypeUser.setApp(app);
  logTypeUser.setType(type);
  logTypeUser.setUser(user);
  sess.saveOrUpdate(app);
  sess.saveOrUpdate(type);
  // LogUser is the class with the inverse="false" set, and cascade on.
  // This call will now cause logTypeUser to be saved, too.
  sess.saveOrUpdate(user);


Don't forget to rate!
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.