]
Steve Ebersole closed HHH-1007.
-------------------------------
Closing stale resolved issues
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>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: