What is the best way of inserting clobs into Oracle via hibernate mapping?
At the moment i have a solution that grabs an Oracle Clob object then populates and finally updates to Oracle . But this makes my code oracle specific.
Normal insterting only adds a portion of the large XML files i'm trying to insert. I've tried with a type of clob, text , string.
Here is the mapping file...
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate mapping DTD/EN" "http://hibernate.sf.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.cedar.preston.mercury.outbox.OutgoingMessage" table="MERCURY_OUTBOX">
<id name="messageId_int" column="MESSAGE_ID">
<generator class="increment"/>
</id>
<property name="messageType" column="TYPE" />
<property name="authCode" column="AUTHORITY_CODE" />
<property name="correlationId" column="CORRELATION_ID" />
<property name="created" column="CREATED" />
<property name="status" column="STATUS" />
<property name="description" column="DESCRIPTION" />
<property name="payPeriod" column="PAY_PERIOD" />
<property name="dazPayload" column="CONTENT" type="text" />
<property name="gtErrorXml" column="ERROR_XML" type="clob" />
<property name="preStatus" column="PREVIOUS_STATUS" />
<property name="preDate1" column="PREVIOUS_STATUS_DATE1" />
<property name="preDate2" column="PREVIOUS_STATUS_DATE2" />
<property name="preDate3" column="PREVIOUS_STATUS_DATE3" />
</class>
</hibernate-mapping>
|