Hi,
I want to know if I can use Hibernate with AS400 V4R5, with jdbc driver jt400.jar, com.ibm.as400.access.AS400JDBCDriver.

Thanks

The key is the JDBC driver, so if the JDBC driver is reasonably good and supports meta data then it should be fine. There is a generic dialect but you may find you will need new dialect to fine tune access. There are lots of dialects in the system from which to base your new one.

My understanding is that there are no particular problems with OS400 V5R4. Prior versions of DB2/400 have some problems with the SQL syntax of ORDER BY.

But I am not an AS400 user, so I am only relaying the experience of others here.

You'll have issues with ORDER BY with anything less than V5R2. Previous versions do not allow an order by on a column that is not referenced in the select. We use V5R2 here without any particular issues.

Hibernate will append the table name to the order by columns. On V5R2, you the table.column syntax is supported in order by. You can work around this by intercepting where the order by columns are appended to the order by clause and dropping the table qualifier. You could modify the OrderByParser to strip the table qualifier when it calls the pathExpressionParser().getWhereColumn().