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.