posted 10 years ago
Thank you for your answer, Peter... JPA is a good choice but I had in mind something more similar to a middleware product which would act as a proxy for your queries and stored procedure.
For example, I can run SQL PreparedStatements against that middleware and it in turn will translate on the fly my queries into SQL Server, Db2 or other vendors' SQL specific dialect..
Of course, I have no idea if such software exists...