Oracle 9 Dialect uses deprecated types -------------------------------------- Key: HHH-1007 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1007 Project: Hibernate Core Issue Type: Improvement Components: core Affects Versions: 3.1 beta 2 Environment: Java 5, Oracle 9i Reporter: Derek Hulley Assignee: Steve Ebersole Priority: Minor The Oracle9Dialect uses Oracle types "long" and "long raw". Both of these have been deprecated, and should be replaced with "CLOB" and "BLOB". http://www.ss64.com/orasyntax/datatypes.html The reason why this matters is that an Oracle table may not have more than one column of type "long", including "long raw". As a consequence, the following will work with MySQL, but fail with Oracle 9i. ... <composite-element class="org.alfresco.repo.domain.PropertyValue" > <property name="actualType" column="actual_type" type="string" length="15" not-null="true" /> <property name="multiValued" column="multi_valued" type="boolean" not-null="true" /> <property name="persistedType" column="persisted_type" type="string" length="15" not-null="true" /> <property name="booleanValue" column="boolean_value" type="boolean" /> <property name="longValue" column="long_value" type="long" /> <property name="floatValue" column="float_value" type="float" /> <property name="doubleValue" column="double_value" type="double" /> <property name="stringValue" column="string_value" type="string" length="16384"/> <!-- FAILURE --> <property name="serializableValue" column="serializable_value" type="serializable" length="16384"/> <!-- FAILURE --> </composite-element>