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)

Show: Today's Messages :: Show Polls :: Message Navigator

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

Sat, 06 August 2022 17:13

Seydou Zakou

Messages: 44
Registered: May 2020

Member

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.

Report message to a moderator

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

Mon, 08 August 2022 11:56

Beat Schwarzentrub

Messages: 210
Registered: November 2010

Senior Member

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

Report message to a moderator