lutece-dao

Define Lutece 8 DAO and Home layer patterns with DAOUtil lifecycle and SQL constants.

3|Updated Feb 2, 2026
One-click install
npx skills add https://github.com/lutece-platform/lutece-dev-plugin-claude --skill lutece-dao-lutece-platform
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: lutece-dao
Source: https://github.com/lutece-platform/lutece-dev-plugin-claude/tree/main/skills/lutece-dao
Command: npx skills add https://github.com/lutece-platform/lutece-dev-plugin-claude --skill lutece-dao-lutece-platform

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides standardized patterns and best practices for implementing Data Access Object (DAO) and Home layers in Lutece 8 applications, ensuring consistency and maintainability.

Core Features & Use Cases

  • DAO Class Structure: Demonstrates the typical Java structure for DAO classes, including SQL constants and method signatures.
  • DAOUtil Lifecycle: Illustrates the correct usage of DAOUtil for database operations (INSERT, UPDATE, DELETE, SELECT) with try-with-resources.
  • Home Facade Pattern: Shows how to create static facade classes for simplified data access.
  • Use Case: When developing a new Lutece plugin that requires database interaction, consult this Skill to implement the DAO and Home layers according to established Lutece 8 conventions.

Quick Start

Consult the ~/.lutece-references/lutece-core/ directory for core DAO patterns before writing new DAO code.

Frequently Asked Questions about lutece-dao

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I implement Data Access Object patterns in Lutece 8 plugins?

To implement Data Access Object patterns in Lutece 8, define SQL constants and manage database operations using the DAOUtil lifecycle with try-with-resources inside static facade Home layers.

What is the DAOUtil lifecycle for database operations in Java?

The DAOUtil lifecycle manages Java database operations like INSERT, UPDATE, DELETE, and SELECT. It requires try-with-resources to ensure proper resource cleanup and maintainable data access logic.

How does the Home facade pattern work for data access in Lutece?

The Home facade pattern uses static Java classes to simplify data access. It wraps DAO implementations and utilizes CDI lookup mechanisms to provide standardized interface conventions for Lutece plugins.

Do I need to follow specific interface conventions for Lutece DAO classes?

Yes, Lutece DAO classes require strict adherence to specific interface conventions and CDI lookup mechanisms to ensure robust and maintainable data access logic across Lutece 8 plugins.

Are there SQL constant conventions for Lutece 8 database interactions?

Yes, Lutece 8 database interactions use specific SQL constant conventions within DAO classes. Standardizing these SQL constants ensures consistency and maintainability across plugin data access layers.