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, tools, and much more.