Dear All
I try to use Clob to store string over 4000 in oracle
when db-prepare, I got the complain below
BUILD FAILED
D:\work\eclipse\workspace\ipgoogle\build.xml:892: Schema text failed:
Could not determine type for: org.springframework.
orm.hibernate.support.ClobStringType, for columns:
[org.hibernate.mapping.Column(patentAbstract)]
I use ojdbc14.jar, oracle 10g db, appfuse 1.9.4
Below is the section in applicationContext-hibernate.xml
//-------------------------------
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
......
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">@HIBERNATE-DIALECT@</prop>
<!-- Create/update the database tables automatically
when the JVM starts up-->
<prop key="hibernate.hbm2ddl.auto">update</prop>
<!-- Turn batching off for better error messages under
PostgreSQL -->
<prop key="hibernate.jdbc.batch_size">20</prop>
<prop key="hibernate.show_sql">false</prop>
<prop
key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>
<!--
<prop
key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop>
-->
<prop key="hibernate.jdbc.use_streams_for_binary">true</prop>
<prop key="hibernate.connection.SetBigStringTryClob">true</prop>
<prop key="hibernate.cache.use_second_level_cache">false</prop>
<prop key="c3p0.acquire_increment">1</prop>
<prop key="c3p0.idle_test_period">100</prop> <!--
seconds -->
<prop key="c3p0.max_size">100</prop>
<prop key="c3p0.max_statements">0</prop>
<prop key="c3p0.min_size">10</prop>
<prop key="c3p0.timeout">100</prop> <!-- seconds
-->
</props>
</property>
<property name="lobHandler"><ref bean="oracleLobHandler"/></property>
</bean>
<bean id="oracleLobHandler"
class="org.springframework.jdbc.support.lob.OracleLobHandler"
lazy-init="true">
<property name="nativeJdbcExtractor"><ref
local="nativeJdbcExtractor"/></property>
</bean>
<bean id="nativeJdbcExtractor"
class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor">
</bean>
//---------------------
and below is the xdoclet code
//------------------------
/**
* @hibernate.property length="9000000"
type="org.springframework.orm.hibernate.support.ClobStringType"
*
*/
public String getPatentAbstract() {
return patentAbstract;
}
//-----------------------
If anyone have met or have any idea about it ?
Regards
Chenztw
--
ChenRanHow
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
