Complete example for JDBC endpoint

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content