Hi there,

Sorry for this question if already asked by anyone.

As Hibernate has been tested with Oracle 8i and 9i, is there any known limitation with the very old 8.0.5 version ?

Thank's for your help

TRF

If you use the OracleDialect (not 9i but 8i) mostly it will work fine. You will not be able to use the query limits (setting min/max query results) unless you provide an alternate Dialect as the solution is 8i + specific. I cannot think of anything else you will have a problem with.

Note: Sometimes getting a decent JDBC driver may be a problem. Oracle has tended to have a few bugs in JDBC impl but it varies from version to version.

Thank's for your answer.

The conclusion seems to be, depending on Oracle's bugs... ;)
So, as we don't have to make complex things, I suppose it will be fine.

Nota: remember that Oracle 8i starts with 8.1.6 not 8.0.5

Yes I am aware of the version of Oracle as such this is why some of the functionally, eg Query Limits will not work with 8.0.5, as the OracleDialect is aimed toward 8i dialect. Now it is no problem to create a extended dialect so the limits will work (not as efficiently) but thats an exercise that may not be necessary. Having said that there are few other issues that you will encounter other than possible JDBC driver problems.

Thank's for this discussion and happy Hibernate !!!