Question & Answer > View Question

SQL command doesn't work in "database update tool"

Confluence User - 10 Jun, 2020

As below screenshot, I configured one database update tool in one form. And use below SQL command. it doesn't work. But before I enter database update tool, I try to run this command in SQL server, it can work. And I found the key word "begin" can't be identified. Is it error in Joget ?

database;forms

2

Confluence User •

10 Jun, 2020 •

confluenceUser •

•

confluenceUser •

If you are using MySQL, please read https://stackoverflow.com/questions/10797794/multiple-queries-executed-in-java-in-single-statement#answers-header . This is an optional MySQL connection property and has nothing to do with Joget, I believe.

Confluence User •

11 Jun, 2020 •

confluenceUser •

•

confluenceUser •

Database Update Tool lets you perform update/insert/delete queries on your selected database.

If you want to use stored procedures you need to write them in SQL workbench and call them. But for that you need to use JDBC binder where you can write select query.

1

CSV | Excel | XML | PDF

Your answer

Print

SQL command doesn't work in "database update tool"

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-e29fbbd1-87c8-4f79-b419-ab418840b5cb{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-4af214de-a7dc-4e7f-b58e-4642b5bfdbdd{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer