judo-runtimequery-debugging

name: judo-runtime:query-debugging description: Debug and trace JUDO DAO RDBMS SQL generation. Use when troubleshooting query performance, investigating wrong SQL output, or tracing query translation flow. metadata: author: BlackBelt Technology version: "${project.version}"

Query Debugging

Troubleshooting guide for JUDO DAO RDBMS query translation and SQL generation.

Query Execution Flow

sequenceDiagram
    participant App as Application
    participant DAO as RdbmsDAOImpl
    participant Builder as RdbmsBuilder
    participant Executor as SelectStatementExecutor
    participant DB as Database
    
    App->>DAO: Query request
    DAO->>Builder: Build query
    Builder->>Builder: Translate expressions
    Builder->>Builder: Apply mappers
    Builder-->>DAO: SQL + parameters
    DAO->>Executor: Execute
    Executor->>DB: JDBC query
    DB-->>Executor: ResultSet
    Executor-->>DAO: Mapped objects
    DAO-->>App: Results

Enable Debug Logging

<!-- logback.xml -->
<logger name="hu.blackbelt.judo.runtime.core.dao.rdbms" level="DEBUG"/>
<logger name="hu.blackbelt.judo.runtime.core.dao.rdbms.query" level="TRACE"/>
<logger name="org.springframework.jdbc" level="DEBUG"/>

Common Issues

Issue 1: Wrong SQL Generated

Symptoms: Query returns unexpected results or SQL syntax errors

Debug Steps:

1. Enable TRACE logging for query package
2. Check RdbmsBuilder output
3. Verify mapper registration

// Debug: Print generated SQL
log.debug("Generated SQL: {}", selectStatement.getSql());
log.debug("Parameters: {}", selectStatement.getParameters());

Issue 2: Missing Joins

Symptoms: Related entities not loaded, null references

Checklist:

1. Check RdbmsResolver.rdbmsJunctionTable() for M:N relations
2. Verify join processor selection
3. Check foreign key mappings in RDBMS metamodel

// Debug join resolution
RdbmsReference ref = resolver.rdbmsReference(eReference);
log.debug("Join table: {}", ref.getJunctionTable());
log.debug("FK columns: {}", ref.getForeignKeyColumns());

Issue 3: Type Conversion Errors

Symptoms: ClassCastException, wrong data types

Debug:

// Check parameter mapping
RdbmsParameterMapper mapper = ...;
Parameter param = mapper.createParameter(value, targetType);
log.debug("SQL Type: {}, Value: {}", param.getSqlType(), param.getValue());

Issue 4: Performance Issues

Symptoms: Slow queries, N+1 problems

Analysis:

1. Check query caching: SelectStatementExecutorQueryMetaCache
2. Profile join strategies
3. Review batch fetching configuration

// Enable query timing
long start = System.currentTimeMillis();
List<?> results = dao.query(querySpec);
log.info("Query took {}ms, returned {} rows", 
    System.currentTimeMillis() - start, results.size());

Tracing Query Translation

flowchart LR
    A[Query Model] --> B[RdbmsBuilder]
    B --> C[Attribute Mapping]
    B --> D[Filter Mapping]
    B --> E[Join Processing]
    C --> F[SQL SELECT]
    D --> G[SQL WHERE]
    E --> H[SQL JOIN]
    F --> I[Final SQL]
    G --> I
    H --> I

Key Debug Points

Statement Executor Hierarchy

classDiagram
    StatementExecutor <|-- SelectStatementExecutor
    StatementExecutor <|-- ModifyStatementExecutor
    ModifyStatementExecutor <|-- InsertStatementExecutor
    ModifyStatementExecutor <|-- UpdateStatementExecutor
    ModifyStatementExecutor <|-- DeleteStatementExecutor

See Also

• /judo-runtime:custom-queries - Extend query translation
• /judo-runtime:dialect-extension - Database-specific debugging