Dentsu Research Institute Develops Support Tool for Doma Java Framework

Dentsu's New Support Tool for Doma

Dentsu Research Institute, a leading technology and consulting organization based in Minato, Tokyo, is set to enhance the utilization of its open-source Java database access framework, Doma, with a brand new support tool. Scheduled for contribution to the open-source community on June 10, 2025, this initiative aims to bolster productivity for software developers who leverage the Doma framework.

What is Doma?

Doma is an open-source framework designed to simplify the connection between Java applications and databases, enabling seamless data storage and retrieval. By clearly separating Java code from SQL statements, Doma reduces the maintenance costs associated with modifying applications. This structure also enhances security by preventing SQL injection attacks, thereby safeguarding database integrity.

The newly developed support tool is equipped with features that assist developers in managing Java and SQL more effectively, thereby improving overall productivity.

Background and Development

In the realm of software development that involves database access, one of the significant challenges is safely constructing dynamic SQL while maintaining high maintainability. To address this issue, a team from Dentsu Research Institute created the Doma framework which was donated to the open-source community in 2009. Since then, Doma has been continually evolving through ongoing feedback from the community.

The Doma framework has seen increased adoption within Dentsu, being integrated into various application development platforms, such as aiuola and M5, which support the company’s business operations. In anticipation of Doma's stable development and wider adoption, Dentsu has decided to develop this support tool and donate it to the open-source community. This move is aimed at revitalizing the community and establishing a foundation where more developers can engage in the development and maintenance of Doma.

Overview and Features of the Support Tool

The forthcoming support tool is a plugin designed for IntelliJ IDEA, specifically supporting the integration between Java and SQL in Doma development. Here are some of its key features:

1. Seamless Transition Between Java Methods and SQL Files

Doma encourages a design that aligns naming conventions between Java methods and SQL files. This tool facilitates smooth transitions between the two through shortcuts, ensuring that if a corresponding SQL file does not exist, it can be easily created.

2. Autocomplete for Bind Variables with Real-time Error Checking

When referencing parameters in Java methods via SQL bind variables, the tool offers an automatic dropdown of suggestions, allowing for accurate and easy input. Furthermore, should a non-existent parameter be utilized, an error message will immediately appear, helping to prevent human error.

3. Syntax Highlighting and Formatting for SQL

SQL statements benefit from automatic syntax highlighting, improving clarity for developers. Bind variables and Doma-specific directives (e.g., %if and %end) are clearly visible, and code formatting can be easily handled in conjunction with IntelliJ IDEA’s reformat functionality.

At Dentsu Research Institute, we are committed to ongoing development of both Doma and the support tool, galvanizing our engagement with the open-source community. Through open co-creation initiatives, we aim to contribute to technological advancement and the realization of a sustainable society.

About Dentsu Research Institute

Dentsu Research Institute is dedicated to driving transformation through its corporate vision of "HUMANOLOGY for the future~creating beyond humans and technology~." Our approach combines system integration, consulting, and think-tank methodologies to sincerely address challenges across the public and private sectors as well as within society. By promoting cross-innovation that transcends technology, industries, companies, and communities, we strive to clear pathways to the future and continue creating new value.

References

1. About Doma
2. Details of the Support Tool

This initiative exemplifies Dentsu’s commitment to using technology for the betterment of society. It enables developers to focus on innovation while minimizing their workload, setting the stage for a robust future in open-source development.