smart meter configuration on the database
Desktop utility for CRUD operations on GPRS smart electric meters in the platform database.
What it is
Device Configuration Utility is a standalone Java Swing application for adding, updating, and deleting smart electric meter devices in the platform database. It provides a forms-based interface for entering device metadata (serial number, account ID, meter make, modem serial, and CTR/PTR/MF calibration factors), selecting read parameters (instantaneous, billing, load profile, event data), configuring poll scheduling via an editable 5-row table, and setting endpoint/host details. The utility uses direct JDBC to perform cascading inserts, updates, and deletes across seven related database tables, automating the repetitive work of meter provisioning.
Key benefits
Faster meter provisioning
Eliminates manual SQL inserts for device onboarding. One form capture creates all required database records (device, controller, meter, scheduler, modem) in a single operation.
Bulk configuration at scale
Supports meter-make selection (HPL, SECURE, LNT, GENUS) and pre-configured 5-poll-type schedule (billing, load profile, instantaneous, event, daily load profile) with operator-set durations and intervals.
Complete device lifecycle
Add new devices, edit existing meter parameters (calibration, endpoints, read flags), or fully delete devices with automatic cleanup of all dependent records — no orphaned database rows.
Multi-database support
Connects via JDBC to SQL Server (default), MySQL, H2, PostgreSQL, SQLite, and Oracle without code changes — database type set in XML configuration at startup.
Capabilities
- Desktop Swing GUI for device metadata entry (serial, account, CTR/PTR/MF, modem serial, meter make)
- Checkbox controls for read parameter flags (instantaneous, billing, load profile, daily load profile, event)
- Editable 5-row JTable for poll scheduler setup (poll type ID, duration value, duration unit, enabled flag)
- Cascading device creation across platform tables, platform tables, platform tables, platform tables, platform tables, platform tables, and platform tables tables
- Update and delete operations with automatic cleanup of all related records
- License validation at startup (WizIIOT license file + native serial access wrapper)
- Raw JDBC data access (hand-crafted SQL queries, minimal ORM)
- Hardcoded support for GPRS meters only (controller type 13)