I came across a requirement to use HStore capability of postgres schema to store unstructured data along with the EclipseLink as JPA implementation. I was aware that I need to write an EclipseLink converter to support this functionality in my project. I thought about using existing solution for this if one is available, I came across couple of solution at Stack Overflow and Git Hub but all of them are incomplete. After implementing these solution I started receiving an exception column metadata is of type hstore but expression is of type character varying from postgres.
After lot of Google and digging into postgres library I came across a solution, I am writing the same hoping this can be helpful for others.
Exception Trace
Solution