Patched Database Connection Leak At

DynamicTradeStorageService.java

• Prevents connection pool exhaustion

---

Patched AdaptiveCache Executor Leak

Patched Missing Shutdown Calls

---

Improved Performance

• Optimized findNearestPlayer() with spatial queries
• Reduced complexity from O(n×m) to O(k)
• Added fallback for older API versions

---

Overall Patched Many Performance Issues

Villager Trade Manager v12 - Advanced Minecraft Villager Economy Control (1.20.x-1.21.x Folia/Paper/Spigot)

Ultimate villager trade plugin: Custom pricing/bans, leveling, stock mgmt, wandering traders, dynamic economy, multi-DB (SQLite/PG/Supabase), AI help, Vault integration. Folia optimized.

🎯 Key Features

• 💰 Custom Trades: Price any trade/profession (/vtrade setprice armorer diamond_helmet 25)
• 🚫 Item Bans: Block OP items (/vtrade banitem netherite_sword)
• 📈 Leveling: XP progression, unlocks (/vtrade level set)
• 📦 Stock/Restock: Limits, auto-refill (/vtrade stock inspect)
• 🐪 Wanderers: Custom trades (/vtrade wanderer add)
• 🗄️ DBs: SQLite/PG/Supabase w/ pooling
• 🤖 AI Help: /vtrade help ask "setup guide?"
• 📊 Metrics: Health/prometheus

Keywords: minecraft villager trade plugin 1.21, custom villager trades paper, folia villager manager, spigot economy plugin.

📋 Commands Summary

Cmd	Desc
/vtrade setprice <prof> <item> <cost>	Custom price
/vtrade banitem <item>	Ban item
/vtrade level/stock [set/inspect]	Level/stock mgmt
/vtrade [addprereq/chain] <trade>	Enhancements
/vtrade wanderer add <item>	Trader trades
/vtrade restock [on/time]	Restock
/vtrade help ask <q>	AI help

⚙️ Config Highlights

database: sqlite  # or postgresql/supabase
level_progression.enabled: true
trade_enhancements.enabled: true
ai_assistant.groq.api_key: "key"

Transform your villager economy today! ⭐ Download v12.

Changelog

---

[11.1.0] - 2025-11-06

🐛 Bug Fixes

Folia Compatibility Fix ⭐ CRITICAL

• Plugin Loading Failure: Fixed UnsupportedOperationException that prevented plugin from loading on Folia 1.21.8
• Scheduler Compatibility: Replaced raw Bukkit.getScheduler() calls with platform-aware TaskScheduler
• PerformanceMonitorService: Updated to use TaskScheduler.runAsyncRepeating() instead of runTaskTimerAsynchronously()
• MigrationCommand: Updated to use TaskScheduler.runSyncRepeating() instead of runTaskTimer()
• Constructor Updates: Modified service constructors to accept TaskScheduler dependency injection

🔧 Technical Improvements

Dependency Injection

• TaskScheduler Injection: Services now properly receive TaskScheduler instances instead of accessing raw schedulers
• Platform Abstraction: Enhanced use of platform-aware scheduling throughout the codebase
• Code Consistency: Unified scheduler usage patterns across all components

---

[11.0.0] - 2025-11-06

🎉 Major Features

Item Banning System ⭐ NEW

• Complete Item Control: Ban entire items from appearing in any villager trades
• Smart Filtering: Automatically prevents enchanted variants when base item is banned
• Database Persistence: Banned items stored in database with audit trail
• Commands Added:
  • /vt banitem <item_type> - Ban items from all villager trades
  • /vt unbanitem <item_type> - Remove item bans
  • /vt listbanneditems - Display all currently banned items
• Examples: /vt banitem diamond_sword, /vt banitem enchanted_golden_apple

PostgreSQL Database Support ⭐ NEW

• Direct JDBC Connections: Support for PostgreSQL databases beyond Supabase
• Connection String Config: Full PostgreSQL connection string support
• Enhanced Compatibility: Works with Supabase, AWS RDS, Google Cloud SQL, etc.
• Configuration:

  database:
    type: "postgresql"
    postgresql:
      connectionString: "postgresql://user:password@host:5432/database"
  

🔧 Enhancements

Command System Improvements

• Enhanced Tab Completion: Full autocomplete for all commands and parameters
• Better Error Messages: Improved feedback for invalid commands and parameters
• Enchantment Guidance: Special help messages for enchantment-related commands
• Profession Validation: Real-time validation of profession names and trade IDs

Database Architecture

• Multi-Database Support: SQLite, Supabase REST API, PostgreSQL JDBC
• Automatic Fallback: Seamless fallback to SQLite if cloud databases fail
• Connection Management: Improved connection pooling and lifecycle management
• Schema Validation: Enhanced database schema validation and migration

Performance Optimizations

• Memory Usage: Reduced memory footprint for large trade registries
• Database Queries: Optimized query performance and caching
• Async Operations: Improved asynchronous database operations
• Resource Management: Better cleanup and resource disposal

🐛 Bug Fixes

Supabase Integration

• URL Construction: Fixed double /rest/v1/ path construction bug
• Authentication: Corrected authorization header usage for service keys
• Connection Status: Fixed isConnected() method to properly track status
• Error Handling: Improved error messages and fallback behavior

Command Processing

• Trade Validation: Fixed validation logic for custom trade pricing
• Parameter Parsing: Improved command argument parsing and validation
• Tab Completion: Fixed tab completion for complex command structures
• Error Feedback: Enhanced error messages for user guidance

Database Operations

• Connection Handling: Fixed connection leak issues in database providers
• Transaction Management: Improved transaction handling and rollback
• Migration System: Enhanced database migration reliability
• Data Integrity: Better validation of database operations

🔒 Security

Database Security

• Connection Encryption: Proper SSL/TLS for database connections
• Credential Handling: Secure storage and transmission of credentials
• Access Control: Improved permission validation
• Audit Trail: Database operation logging for security monitoring

Input Validation

• Command Sanitization: Enhanced input validation for commands
• SQL Injection Prevention: Prepared statements for all database queries
• Path Traversal: Protection against path manipulation attacks
• Resource Limits: Rate limiting and resource usage controls

🏗️ Technical Improvements

Code Architecture

• Database Provider Pattern: Clean abstraction for different database types
• Configuration System: Enhanced configuration parsing and validation
• Error Handling: Comprehensive exception handling and logging
• Code Organization: Better separation of concerns and modularity

Dependencies

• PostgreSQL Driver: Added PostgreSQL JDBC driver support
• HTTP Client: Updated OkHttp for better Supabase communication
• JSON Processing: Enhanced Jackson for complex data structures
• Testing Framework: Improved unit and integration testing

Build System

• Maven Configuration: Updated dependencies and build process
• Plugin Compatibility: Enhanced compatibility with different server platforms
• Resource Management: Better handling of plugin resources
• Deployment: Streamlined build and deployment process

🔄 Migration Guide

From V10.x to V11.0

Database Migration

# V10.x config
database:
  type: "sqlite"

# V11.0 config (unchanged for SQLite users)
database:
  type: "sqlite"
  sqlite:
    file: "villager_data.db"

New Commands Available

• Run /vt listbanneditems to see current banned items (none by default)
• Use /vt banitem <item> to ban items from trades
• Consider /vt setprice improvements with better error messages

Configuration Changes

• No breaking changes for existing configurations
• New postgresql section available for advanced users
• Enhanced logging options in config.yml

📊 Metrics & Monitoring

Health Checks

• HTTP Endpoints: Configurable health check endpoints
• Database Monitoring: Connection pool and query performance metrics
• Memory Tracking: JVM memory usage and garbage collection monitoring
• Trade Statistics: Real-time trade volume and performance analytics

Logging Improvements

• Structured Logging: JSON-formatted logs for better parsing
• Debug Modes: Enhanced debugging options for troubleshooting
• Performance Logs: Query execution time and bottleneck identification
• Error Tracking: Comprehensive error reporting and analysis

---

[10.x.x] - Previous Versions

See individual release notes for V10.x changes including:

• Universal trade pricing for all professions
• Folia compatibility and region-threaded scheduling
• Advanced restock system with instant restock
• Dynamic trade detection and storage

---

🤝 Contributing

• Bug Reports: Use GitHub Issues with detailed reproduction steps
• Feature Requests: Describe the use case and expected behavior
• Code Contributions: Follow the existing code style and patterns
• Testing: Ensure all tests pass and add new tests for new features

---

📞 Support

• Documentation: README.md for complete usage guide
• Issues: GitHub Issues for bug reports and feature requests
• Community: Join our Discord for community support
• Compatibility: Minecraft 1.20.x - 1.21.x, Java 17+

---

Legend:

• 🎉 Major Features: Significant new functionality
• 🔧 Enhancements: Improvements to existing features
• 🐛 Bug Fixes: Resolved issues and problems
• 📚 Documentation: Documentation and guides
• 🔒 Security: Security-related changes
• 🏗️ Technical: Internal architecture changes

Changelog

---

[11.0.0] - 2025-11-06

🎉 Major Features

Item Banning System ⭐ NEW

• Complete Item Control: Ban entire items from appearing in any villager trades
• Smart Filtering: Automatically prevents enchanted variants when base item is banned
• Database Persistence: Banned items stored in database with audit trail
• Commands Added:
  • /vt banitem <item_type> - Ban items from all villager trades
  • /vt unbanitem <item_type> - Remove item bans
  • /vt listbanneditems - Display all currently banned items
• Examples: /vt banitem diamond_sword, /vt banitem enchanted_golden_apple

PostgreSQL Database Support ⭐ NEW

• Direct JDBC Connections: Support for PostgreSQL databases beyond Supabase
• Connection String Config: Full PostgreSQL connection string support
• Enhanced Compatibility: Works with Supabase, AWS RDS, Google Cloud SQL, etc.
• Configuration:

  database:
    type: "postgresql"
    postgresql:
      connectionString: "postgresql://user:password@host:5432/database"
  

🔧 Enhancements

Command System Improvements

• Enhanced Tab Completion: Full autocomplete for all commands and parameters
• Better Error Messages: Improved feedback for invalid commands and parameters
• Enchantment Guidance: Special help messages for enchantment-related commands
• Profession Validation: Real-time validation of profession names and trade IDs

Database Architecture

• Multi-Database Support: SQLite, Supabase REST API, PostgreSQL JDBC
• Automatic Fallback: Seamless fallback to SQLite if cloud databases fail
• Connection Management: Improved connection pooling and lifecycle management
• Schema Validation: Enhanced database schema validation and migration

Performance Optimizations

• Memory Usage: Reduced memory footprint for large trade registries
• Database Queries: Optimized query performance and caching
• Async Operations: Improved asynchronous database operations
• Resource Management: Better cleanup and resource disposal

🐛 Bug Fixes

Supabase Integration

• URL Construction: Fixed double /rest/v1/ path construction bug
• Authentication: Corrected authorization header usage for service keys
• Connection Status: Fixed isConnected() method to properly track status
• Error Handling: Improved error messages and fallback behavior

Command Processing

• Trade Validation: Fixed validation logic for custom trade pricing
• Parameter Parsing: Improved command argument parsing and validation
• Tab Completion: Fixed tab completion for complex command structures
• Error Feedback: Enhanced error messages for user guidance

Database Operations

• Connection Handling: Fixed connection leak issues in database providers
• Transaction Management: Improved transaction handling and rollback
• Migration System: Enhanced database migration reliability
• Data Integrity: Better validation of database operations

🔒 Security

Database Security

• Connection Encryption: Proper SSL/TLS for database connections
• Credential Handling: Secure storage and transmission of credentials
• Access Control: Improved permission validation
• Audit Trail: Database operation logging for security monitoring

Input Validation

• Command Sanitization: Enhanced input validation for commands
• SQL Injection Prevention: Prepared statements for all database queries
• Path Traversal: Protection against path manipulation attacks
• Resource Limits: Rate limiting and resource usage controls

🏗️ Technical Improvements

Code Architecture

• Database Provider Pattern: Clean abstraction for different database types
• Configuration System: Enhanced configuration parsing and validation
• Error Handling: Comprehensive exception handling and logging
• Code Organization: Better separation of concerns and modularity

Dependencies

• PostgreSQL Driver: Added PostgreSQL JDBC driver support
• HTTP Client: Updated OkHttp for better Supabase communication
• JSON Processing: Enhanced Jackson for complex data structures
• Testing Framework: Improved unit and integration testing

Build System

• Maven Configuration: Updated dependencies and build process
• Plugin Compatibility: Enhanced compatibility with different server platforms
• Resource Management: Better handling of plugin resources
• Deployment: Streamlined build and deployment process

🔄 Migration Guide

From V10.x to V11.0

Database Migration

# V10.x config
database:
  type: "sqlite"

# V11.0 config (unchanged for SQLite users)
database:
  type: "sqlite"
  sqlite:
    file: "villager_data.db"

New Commands Available

• Run /vt listbanneditems to see current banned items (none by default)
• Use /vt banitem <item> to ban items from trades
• Consider /vt setprice improvements with better error messages

Configuration Changes

• No breaking changes for existing configurations
• New postgresql section available for advanced users
• Enhanced logging options in config.yml

📊 Metrics & Monitoring

Health Checks

• HTTP Endpoints: Configurable health check endpoints
• Database Monitoring: Connection pool and query performance metrics
• Memory Tracking: JVM memory usage and garbage collection monitoring
• Trade Statistics: Real-time trade volume and performance analytics

Logging Improvements

• Structured Logging: JSON-formatted logs for better parsing
• Debug Modes: Enhanced debugging options for troubleshooting
• Performance Logs: Query execution time and bottleneck identification
• Error Tracking: Comprehensive error reporting and analysis

---

[10.x.x] - Previous Versions

See individual release notes for V10.x changes including:

• Universal trade pricing for all professions
• Folia compatibility and region-threaded scheduling
• Advanced restock system with instant restock
• Dynamic trade detection and storage

---

🤝 Contributing

• Bug Reports: Use GitHub Issues with detailed reproduction steps
• Feature Requests: Describe the use case and expected behavior
• Code Contributions: Follow the existing code style and patterns
• Testing: Ensure all tests pass and add new tests for new features

---

📞 Support

• Documentation: README.md for complete usage guide
• Issues: GitHub Issues for bug reports and feature requests
• Community: Join our Discord for community support
• Compatibility: Minecraft 1.20.x - 1.21.x, Java 17+

---

Legend:

• 🎉 Major Features: Significant new functionality
• 🔧 Enhancements: Improvements to existing features
• 🐛 Bug Fixes: Resolved issues and problems
• 📚 Documentation: Documentation and guides
• 🔒 Security: Security-related changes
• 🏗️ Technical: Internal architecture changes

Minor Bug Fixes

• Fixed Access global region thread To specific region thread In Folia Compatibility
• Other Minor Bug Fixes