@Lob on String does not produce expected results for PostgreSQL

Description

If I create a String @Column, annotated with @Lob, and use PostgreSQL as the backend, then all my fields are stored as numbers in the database.

Workaround is to use the non-portable @Column(columnDefinition="TEXT")

Somebody else has seen the same thing http://stackoverflow.com/questions/9158645

Environment

<dependency>
<groupId>org.hibernate.javax.persistence</groupId>
<artifactId>hibernate-jpa-2.0-api</artifactId>
<version>1.0.1.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<version>4.2.0.CR2</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>9.1-901-1.jdbc4</version>
<scope>runtime</scope>
</dependency>

with latest macports postgresql92

Assignee

Unassigned

Reporter

Sam Halliday

Labels

None

Feedback Requested

None

Feedback Requested By

None

backPortable

None

Suitable for new contributors

None

Pull Request

None

backportDecision

None

backportReEvaluate

None

Affects versions

Priority

Major
Configure