Java O/R layer for SQL server?

Question

I've got a java server (not web based, more like a big, many-threaded standalone application) that needs to talk to a MS SQL Server database.

I just worked on a different project that ported a home-grown O/R layer from oracle to SQL Server, and it ran into significant problems because of too many oracle assumptions (locking, mostly). So What O/R layer should I use?

Edit: I have heard of Hibernate, but everything else is useful! Specifically though, do any of these APIs/frameworks help with the peculiar shortcomings of SQL Servers locking strategy in a multi-threaded environment?

Answer 1

Hibernate is the usual choice. Besides that you can take a look at Oracle TopLink, iBatis, whatever suites you best.