Package com.tbg.wms.db

package com.tbg.wms.db

Oracle WMS data-access layer.

Package Responsibility

• Provide read-only Oracle WMS query adapters.
• Encapsulate connection-pool lifecycle and connectivity diagnostics.
• Isolate SQL/schema probing concerns from core planning services and UI layers.

Key Types

• DbQueryRepository - read-only query contract used by CLI/GUI workflows.
• OracleDbQueryRepository - Oracle-backed implementation of query operations.
• DbConnectionPool - HikariCP lifecycle and read-only datasource setup.
• DbConnectivityDiagnostics - connection diagnostics and health checks.
• Rail family normalization honors explicit WMS override flags (for example, UC_PARS_FLG=1 implies CAN).

Internal Helper Types

• DescriptionTextHeuristics - centralized text-quality policy so description filtering stays consistent across all lookup branches.
• PrtmstDescriptionColumnResolver - cached PRTMST description-column discovery, separated from repository SQL orchestration for SRP and predictable lookup performance.
• Shipment line-items are loaded in one shipment-scoped query and grouped by LPN to avoid N+1 database probes.
• Shipment LPN rows are coalesced after the inventory-detail join so mixed-lot pallets cannot create duplicate labels.

Since:

1.5.0

Class	Description
DbConnectionPool	Manages the Oracle database connection pool using HikariCP.
DbConnectivityDiagnostics	Diagnostic information returned by database connectivity tests.
DbQueryRepository	Repository interface for querying WMS data from Oracle database.
OracleDbQueryRepository	Oracle implementation of DbQueryRepository.
WmsRailDbRepository	Adapter that exposes rail-only queries through the core rail repository boundary.