Hibernate Community • View topic - save(object) Not using stored procedure

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

save(object) Not using stored procedure

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

TAOSBORNE

Post subject: save(object) Not using stored procedure

Posted: Mon Jul 16, 2007 4:45 pm

Newbie

Joined: Mon Mar 26, 2007 12:47 am
Posts: 2
Location: Plano, Texas

Hibernate version:3.2.1.ga

Mapping documents:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
   "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
   
<hibernate-mapping package="com.countrywide.loanadmin.ace.creditreporting.cushionpolicy.domain">
   <class name="AuditLogImpl" table="MET2DLOGF0">
      <id name="id" column="ID" type="long" access="field">
         <generator class="native"/>
      </id>
      <property name="customerAccountNumber"      column="ACCTNUM"    type="long"       access="field"/>
      <property name="reportingPeriodDate"        column="RPTPER"    type="long"       access="field"/>
      <property name="orgMostRecentPaymentRating" column="ORGPRAT"    type="string"       access="field"/>
      <property name="chgMostRecentPaymentRating" column="CHGPRAT"    type="string"       access="field"/>
      <property name="orgAccountStatus"           column="ORGSTAT"    type="string"       access="field"/>
      <property name="chgAccountStatus"           column="CHGSTAT"    type="string"       access="field"/>
      <property name="orgPastDueAmount"           column="ORGPSDU"    type="big_decimal"    access="field"/>
      <property name="chgPastDueAmount"           column="CHGPSDU"      type="big_decimal"    access="field"/>
      <property name="orgFcraDate"                column="ORGFCRA"    type="string"       access="field"/>
      <property name="chgFcraDate"                column="CHGFCRA"    type="string"       access="field"/>
      <property name="dateUpdated"                column="LSTCHGDTTM" type="calendar"    access="field"/>
      <property name="updatedBy"                  column="LSTCHGUSER" type="string"       access="field"/>
      <sql-insert callable="true" check="none">
      { call ACESP5(?,?,?,?,?,?,?,?,?,?,?,?) }
      </sql-insert>
   </class>
</hibernate-mapping>

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

(Long)sessionFactory.getCurrentSession().save(auditLog);

Name and version of the database you are using:
as400 database V5R3

Code:

<bean id="dataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
      <property name="driverClassName" value="com.ibm.as400.access.AS400JDBCDriver" />
       <property name="url" value="jdbc:as400://AS400DEV;naming=system;" />
        <property name="username" value="tosborne" />
        <property name="password" value="xxxxxxxxxx" />  
   </bean>

When I look at the log files, it shows Hibernate performing it's own INSERT statement instead of calling my stored procedure.

I read the chapter 8 page 361 in the Java Persistance with Hibernate(great book by the way).

Am I missing something?

Top

TAOSBORNE

Post subject: Slight Modifaction to generator value

Posted: Wed Aug 01, 2007 3:30 pm