Complete example for JDBC endpoint
Issue
I have to get a proof of concept to connct to mysql DB and insert rows to a table in this DB from a queue (in activeMQ).
I want to find the easiest way to do this with a shortest time available, so I'm thinking of using "jdbc" endpoint in my blueprint.
With the above info, I'd like to ask:
1) Where can I find a complete example where jdbc endpoint is used?
2) Where would I indicate id/pwd to the DB when using JDBC connection?
3)If the content of data in the queue is XML, do I have to create bean to map XML tag to DB columns?
4) If the content of the data in the queue is a flat file (fixed length) column, what would be the easiest way to parse each row into DB row with multiple columns? Let's assume it's a single table.
Environment
Fuse ESB Enterprise 7.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
