However I kept having issues with the schema validation in hibernate :
Wrong column type: binary_double, expected: double precision
After looking into the source for the dialect mappings I've found that creating a new dialect that extends the Oracle 9 one as follows solves this problem :
public class Oracle10Dialect extends Oracle9Dialect
{
public Oracle10Dialect()
{
super();
registerColumnType(Types.DOUBLE, "binary_double");
}
super();
registerColumnType(Types.DOUBLE, "binary_double");
}
}
Then use this class in the persistence.xml file instead of the Oracle9Dialect.