> This is a significant weakness of JPA in my not so humble opinion. I would love to see a mechanism in JPA > 3.0 which allows the author to define aliases within JPQL for stored procedures, SQL functions, or > DB-specific functions.
Part of this limitation has been answered with JPA 2.0 itself. In JPA 2.0, queries can use database specific functions [1]. [1] http://www.ibm.com/developerworks/java/library/j-typesafejpa/#N10B02 See the subsection "Extensible datastore expressions" ----- Pinaki -- View this message in context: http://openjpa.208410.n2.nabble.com/JPA-for-portable-database-management-tp5134215p5136374.html Sent from the OpenJPA Users mailing list archive at Nabble.com.