PostgreSQL and Hibernate CLOB

postgresql-and-hibernate-clob

When you need a SQL data type that can hold more than 255 characters, you are likely to use some large character data type such as CLOB, BLOB. It is easy to find the right type if you know what exactly the database you will stick to. However, when we use Hibernate, it provides the annotations that support the cross-platform data type translation.

Story

I like to use H2 embedded database as a starting point when I start a new project, but later on, when I switch to use PostgreSQL, I was prompted org.postgresql.jdbc.PgConnection.createClob() is not yet implemented.

I have one property in my class is a String type, as I marked as @Lob and wish Hibernate will take care of the rest for me, but NO. I still get the same exception.

Solution

To solve this, I need to add the additional @Type(org.hibernate.type.TextType) annotation to the property as well, and then it works nicely with PostgreSQL in addition to H2.

Lesson Learnt

  • org.hibernate.type.TextType - A type that maps an SQL LONGVARCHAR to a Java String
  • @Type - use this to define one of the Hibernate mappings to gain cross-platform support.

Comments

Post a Comment

Popular posts from this blog

Creating a Library Project for Spring Boot

creating-a-library-project-for-spring-bootThis article introduces the key points when creating a library for spring boot project.It could be common that over the years you have created a number of services that could be reused by other spring projects. It then makes sense to make the reusable modules such as a library and install it in your local repository for later use.Here are the key points to consider when building a spring boot library.release versionbuild plugindependency injectionautoconfigurationsRelease VersionTo guarantee spring boot works the way you expect, it is recommended to keep update the release versions of the library so that it supports some versions of the spring boot minor version. A good practice is to monitor change spring boot changelog and see if there are any conflicting dependencies that are used in the library project. If there is, introduce a new version to resolve the conflict.Build PluginIf the projects reference this library doesn’t compile through ma…
Read more

Distributed Transaction Management with REST and Try Confirm/Cancel Pattern

distributed-transaction-management-with-rest-and-try-confirm-cancel-patternThis article introduces how to manage transactions effectively in distributed REST services with Try Confirm/Cancel (TCC) pattern. It also provides a repository that is a simplified Java implementation for anyone who is interested in learning the TCC pattern. This repository attempts to trim the most of the common boilerplate, but only preserve the minimal that could be most straightforward to observe this pattern. It could be adapted to use any backend stack.Try Confirm/Cancel (TCC) PatternTCC is a distributed transactions pattern that fits in the stateless REST services. It is originally proposed by Guy Pardon, the creator of Atomikos.Useful ReferencesConference Speech By Guy PardonTCC for REST API (API specification)Spring Cloud TCC Example By ChrisAbout This RepositoryThis repository is a simplified Java implementation for anyone who is interested in learning the TCC pattern. This repo attempts to trim the …
Read more

Spring JMS and JPA XA Transactions with WebLogic

spring-jms-and-jpa-xa-transactions-with-weblogicThis article shows the configuration of using XA transactions with the resources managed by WebLogic server.There are three parts of configurations for this XA transactions to work - JMS, JPA and JTA. Both JMS and JPA are acquired through the JNDI registry and the XA transaction manager implementation uses the one from the WebLogic server. This configuration relies on WebLogic server. The concept should be similar and applicable to other JEE application servers. With these configurations, we could easily use @Transactional annotation on the services for XA transactions.JmsConfiguration.java Excerpt@ConfigurationpublicclassJmsConfiguration{// properties...@Beanpublic ConnectionFactory connectionFactory(){returnlookupByJndiTemplate(jmsConnectionFactory, ConnectionFactory.class);}@Beanpublic JndiTemplate jndiTemplate(){ JndiTemplate jndiTemplate =newJndiTemplate(); jndiTemplate.setEnvironment(getJndiProperties());return jndi…
Read more