# Migration of dialect to Hibernate 6

**URL:** <https://discourse.hibernate.org/t/migration-of-dialect-to-hibernate-6/6956>\
**Category:** Hibernate ORM\
**Created:** [November 25, 2022, 8:16am UTC](https://discourse.hibernate.org/t/migration-of-dialect-to-hibernate-6/6956 "2022-11-25T08:16:21Z")\
**Posts on this page:** 1\
**Showing post:** 16

<div class="post-metadata">

**Author:** ![Uday\_Patil](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/uday_patil/32/2640_2.png) [@Uday\_Patil](https://discourse.hibernate.org/u/Uday_Patil)\
**Post date:** [September 6, 2023, 7:08am UTC](https://discourse.hibernate.org/t/migration-of-dialect-to-hibernate-6/6956/16 "2023-09-06T07:08:05Z")

</div>

We were simply doing below and deserialization was taken care of for **SDO\_ORDINATE\_ARRAY**.  
_DecimalArrayType_ is coming from third party dependency.

```auto
this.registerHibernateType(2003, DecimalArrayType.class.getName());

```

```auto
        <dependency>
            <groupId>com.vladmihalcea</groupId>
            <artifactId>hibernate-types-52</artifactId>
            <version>2.11.1</version>
        </dependency>

```

> **Fully qualified class name:** _com.vladmihalcea.hibernate.type.array.DecimalArrayType_

And for collecting query results in Java, in our projection we were using **BigDecimal[] getOrdinates();** Snapshot below for the projection.

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/hibernate/original/2X/6/60f8e9e134f2894e5ce96096f6692222dc6af6ec.png)

Lastly, you can refer below doc for SDO\_ORDINATE\_ARRAY

> **[Spatial Developer's Guide](https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/spatial-datatypes-metadata.html#GUID-79D7620B-5526-40FD-9604-9642B79908F2)**
>
> The spatial features in Oracle Spatial consist of a set of object data types, type methods, and operators, functions, and procedures that use these types. A geometry is stored as an object, in a single row, in a column of type SDO\_GEOMETRY. Spatial...

---

_[View the full topic](https://discourse.hibernate.org/t/migration-of-dialect-to-hibernate-6/6956)._