[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1007) Oracle 9 Dialect uses deprecated types

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira