sqlj-lang
SQLJ Language Support for IntelliJ IDEA
Edit Java with embedded SQL in .sqlj files: host-variable completion,
Java/SQLJ navigation and DB2-oriented SQL assistance. A project wizard creates a
Spring Boot demonstration with a local DB2 LUW container.
Set source breakpoints in SQLJ files, step through Java/SQLJ code, inspect local variables and use Java watches, breakpoint conditions and log expressions. Maven preparation keeps source maps aligned with the compiled application. See capabilities and requirements for setup and scope. Oracle SQLJ and Derby are not currently supported.
View on JetBrains Marketplace · Installation guide
The listing provides available subscription/trial offers and installation options. Availability depends on Marketplace approval and publication.
Choose your starting point
| Your responsibility | Start here |
|---|---|
| Evaluate, approve or distribute the plugin | Administration and deployment |
| Install and try the DB2 demo | Getting started |
| Work on an existing SQLJ codebase | Editor features and project setup |
| Debug SQLJ code | Debugging setup |
| Diagnose a problem | Troubleshooting and support |
| Check entitlement and reuse of examples | Licensing |
DB2 is initialized automatically when the demo starts. For startup details, use
docker compose logs --follow db2 from the generated project directory.
What the plugin and the translator do
The plugin supplies IDE assistance. The IBM SQLJ translator, JDBC/SQLJ runtime, database privileges and any required customization/binding remain part of your application’s build and deployment. SQL/schema checking depends on the actual translator configuration or the IDE’s optional database tooling; this plugin does not independently validate every statement against a live database.
For example, in a configured SQLJ class with an available connection context:
int employeeId = 42;
String name = null;
#sql { SELECT name INTO :name FROM employee WHERE id = :employeeId };
:employeeId reads a Java value; :name is a write target in SELECT INTO.
Use Ctrl+B to navigate to their declarations. This fragment assumes the table,
connection and application build already exist. The wizard walkthrough
is the runnable starting point.
Distribution and ownership
The source repository is private. The GitHub repository contains generated public documentation and website assets only; it cannot be cloned to build the plugin. Obtain an approved plugin ZIP from the maintainer, or use its Marketplace listing once published. No Marketplace release is implied by this pre-release documentation.
This is an independent plugin by Danny Reinhold, not an official IBM or JetBrains product. See licensing, legal notice and privacy. All documentation.