Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 17:13 Go to next message
Seydou Zakou is currently offline Seydou ZakouFriend
Messages: 43
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.
Re: How to not write RAW SQL in scout application [message #1854224 is a reply to message #1854205] Mon, 08 August 2022 11:56 Go to previous messageGo to next message
Beat Schwarzentrub is currently offline Beat SchwarzentrubFriend
Messages: 201
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
Re: How to not write RAW SQL in scout application [message #1854491 is a reply to message #1854224] Mon, 22 August 2022 08:52 Go to previous message
Seydou Zakou is currently offline Seydou ZakouFriend
Messages: 43
Registered: May 2020
Member
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 10:02]

Report message to a moderator

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


Current Time: Thu Feb 22 21:24:34 GMT 2024

Powered by FUDForum. Page generated in 0.03472 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top