Eclipse Community Forums: Eclipse Scout » How to not write RAW SQL in scout application

Home » Eclipse Projects » Eclipse Scout » How to not write RAW SQL in scout application(Is there a way to use some kind of ORM to generate SQL queries)

How to not write RAW SQL in scout application [message #1854205]

Sat, 06 August 2022 13:13

Eclipse User

Hi All,

We have developed an application at the same time learning scout. So all database queries was write with RAW SQL like in the tutorial (contact application).
Since the application is evolving, we were dealing to use framework/tools to prevent us writing every time RAW SQL when querying the database.

My questions are:
1. Si there any tool in scout that can generate SQL queries for CRUD operation from FormData, and SQL queries from TablePageData ?
2. Does any one has an idea how to integrate Framework like JPA/Hibernate or ORMLite, just for query generation, without loosing transaction management in scout service call ?

Thanks in advance.

Re: How to not write RAW SQL in scout application [message #1854224 is a reply to message #1854205]

Mon, 08 August 2022 07:56

Eclipse User

Scout does not restrict or enforce the use of any particular persistence framework. Just use the one you like best!
I think the "Hello ScoutJS" application demonstrates the use of jOOQ: https://eclipsescout.github.io/22.0/helloscout-js-fullstack.html

As far as I know there is no automatic binding from forms to the persistence model.

Abstract transaction support is provided by Scout via ITransaction. Persistence implementations can add a transaction member (e.g. the SqlTransactionMember) to participate in the "Scout transaction" that is spanned by the RunContext.

Regards,
Beat

Re: How to not write RAW SQL in scout application [message #1854491 is a reply to message #1854224]

Mon, 22 August 2022 04:52

Eclipse User

Thank Beat for your response.

We will give jOOQ a try to see how we can use it based on the mentioned link.

Regards

[Updated on: Mon, 22 August 2022 06:02] by Moderator

Previous Topic:	Cannot create/update REST resource
Next Topic:	Updating a formData class

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 20:08:50 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter