# Oracle to postgre migration issue

**URL:** <https://discourse.hibernate.org/t/oracle-to-postgre-migration-issue/4212>\
**Category:** Hibernate ORM\
**Created:** [June 1, 2020, 9:09am UTC](https://discourse.hibernate.org/t/oracle-to-postgre-migration-issue/4212 "2020-06-01T09:09:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sreejesh](https://avatars.discourse-cdn.com/v4/letter/s/9de0a6/32.png) [@sreejesh](https://discourse.hibernate.org/u/sreejesh)\
**Post date:** [June 1, 2020, 9:09am UTC](https://discourse.hibernate.org/t/oracle-to-postgre-migration-issue/4212/1 "2020-06-01T09:09:51Z")

</div>

Hi,  
We are migrating from Oracle to Postgre. We need to have support for both right now. When an entity with a Clob field after deploying with Postgre with text type database column, we got exception  
“org.postgresql.util.PSQLException: Bad value for type long”

Welcome solutions. Thanks.