Can't save properly a CLOB in hsql with JPA
<p>I need to save some long text in an entity using HSQL but it doesn't work.</p>

<p>Here's My JPA annotation </p>

<pre><code>@Entity
public class DocPart extends AbstractEntity{
....    
    /**
     * the text of this docPart, exctract from the comment in the odt.
     */
    @Column(columnDefinition = "clob")
    @Lob
    private String text;
....
}   
</code></pre>

<p>When I save this object</p>

<pre><code>docPart.setId(1); 
docPart.setText("A text that could be large");
entityManager.persist(docPart);
</code></pre>

<p>and check in the database instead of the text I get this </p>

<pre><code>SELECT text FROM "PUBLIC"."DOCPART"
text
=======================================
org.hsqldb.jdbc.JDBCClobClient@37c0372c
</code></pre>

<p>I get this JDBCClobClient@37c0372c thing instead of the text "A text that could be large" </p>

<p>Any idea ?</p>