Unfortunately, you can't use hilo when supplying your own Connection to Hibernate, or when Hibernate is using an application server datasource to obtain connections enlisted with JTA. Hibernate must be able to fetch the "hi" value in a new transaction. A standard approach in an EJB environment is to implement the hi/lo algorithm using a stateless session bean.