Camel YAML SQL-to-JSON Integration

I need a concise Apache Camel route written in YAML + Java + jbong . The flow is straightforward: pull inventory data from our own SQL-compatible database (it MySQL), run a SELECT statement, pipe the result through a Velocity template for clean formatting, then convert it to a JSON payload(will provide structure). Please wire everything up so it can be dropped into an existing jbong Camel runtime and start running immediately after I add the datasource credentials. Velocity must live in its own file for easy editing, and the final JSON should match the schema I’ll supply once the project starts. Deliverables • [login to view URL] containing the full route • Any supporting Java classes (processors, POJOs, Beans, unit tests) in Maven project form • velocity/[login to view URL] template file • README with import steps and a one-command way to run a sample route Acceptance criteria – Route compiles and starts without modification beyond datasource URL, user, and password – SELECT returns sample inventory rows and produces valid JSON that passes `jq .` parsing – Code follows Camel 3.x conventions and is cleanly commented

Project ID: 39738165