Create an Oracle Hibernate Dialect that uses clob rather than long

[bjagg]

Hibernate's Oracle Dialects use LONG datatypes for historical reasons. Unfortunately, Oracle has a limitation of one LONG per table. There is no such limit for CLOBs, and Oracle fully supports them. Still, Hibernate will not change their dialect. Do switch to CLOBs, we simply need to subclass and configure CLOBs.

public class Oracle10gDialect extends Oracle9iDialect {

    public Oracle10gDialect() {
        super();
        registerColumnType(Types.LONGNVARCHAR, "clob");
        registerColumnType(Types.LONGVARCHAR, "clob");
    }

    public JoinFragment createOuterJoinFragment() {
        return new ANSIJoinFragment();
    }

}

See uPortal-Project/AnnouncementsPortlet@master...bjagg:ANNPLT-127_oracle-bad-grammer