Hi,
Is there any “in Java/Groovy” procedural language, which basically will avoid to create functions inside database like PL/SQL, T-SQL procedures/functions ?
When you create an application which supports multiple databases like SQL Server, MYSQL, and Oracle, but dependent to the functions in the DB… not easy to switch between databases…
Regards,
Gent
Hi,
The short answer is - No, there is no special procedural language in the platform.
We use ORM approach and write code in Java using Java Persistence API implementation - EclipseLink. Usually, we encapsulate our business logic in Service classes that are components of our middle ware. In platform we do not write functions and stored procedures to keep platform persistence code as portable as possible, but if you use only one database for your project (or you can support all the databases manually) you can use JDBC and native SQL.
Hi,
If you want to write SQL in Java then you could check the jOOQ (jooq.org) library.
It creates a type safe SQL API in Java and makes the queries portable.
Regards,
JJ.