GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — [feat] Support for LOCK-Statements by ANeumann82 · Pull Request #2321 · JSQLParser/JSqlParser

Conversation

@ANeumann82

@ANeumann82 ANeumann82 commented Oct 7, 2025

Copy link
Copy Markdown
Contributor

This adds support for LOCK-Statements (Requested for example here #1142, but we also need it)

It supports:

  • DB2: https://www.ibm.com/docs/en/db2/12.1.0?topic=statements-lock-table
  • Most of Oracle: https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/LOCK-TABLE.html

I just saw that MySQL has a bit different syntax, but as I don't need it I wouldn't add it for now.

Please have a look and let me know if there's something missing or wrong.

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.
All reactions
ANeumann82 added 3 commits October 7, 2025 17:03
@ANeumann82
Add support for LOCK-Statements
964513d
@ANeumann82
Fixed comments
973648c
@ANeumann82
ran updateKeywords
00b6545
@ANeumann82

ANeumann82 commented Oct 7, 2025

Copy link
Copy Markdown
Contributor Author

JMH-Run on my machine:

Benchmark                               (version)  Mode  Cnt    Score    Error  Units
JSQLParserBenchmark.parseSQLStatements     latest  avgt   15  158.130 ▒ 19.012  ms/op
JSQLParserBenchmark.parseSQLStatements        5.3  avgt   15  135.400 ▒ 14.585  ms/op
JSQLParserBenchmark.parseSQLStatements        5.1  avgt   15  110.471 ▒  9.734  ms/op
All reactions

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.
ANeumann82 added 2 commits October 7, 2025 17:45
@ANeumann82
Added test
fc57aac
@ANeumann82
Checkstyle & Spotless
16ccb75
@ANeumann82 ANeumann82 changed the title Add support for LOCK-Statements [feat] Support for LOCK-Statements Oct 7, 2025
@ANeumann82
Adjusted NOWAIT and WAIT-Setter
85b8513
@manticore-projects
manticore-projects merged commit 6697c06 into JSQLParser:master Oct 7, 2025
@manticore-projects

manticore-projects commented Oct 7, 2025

Copy link
Copy Markdown
Contributor

Thank you much for your contribution!
All reactions

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Uh oh!

There was an error while loading. Please reload this page.

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

Uh oh!

There was an error while loading. Please reload this page.

2 participants

@ANeumann82 @manticore-projects
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.