Skip to main content


Eclipse Community Forums

      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 13:13 Go to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous message
Eclipse UserFriend
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:
  


Current Time: Wed Jun 25 01:41:59 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly