What are the object types of columns in a message retrieved by SQL Gateway in JBoss ESB?

Solution Unverified - Updated -

Issue

  • SQL Gateway places a database row in a message as java.util.Map<String, Object>, where the String is the database column name, and the Object holds the value of the column. How will I know what the object types are? For instance, what type of object does a BLOB column get mapped to, or a long column?
  • Can I get a concrete example on how to map database BLOBs to java byte arrays and how to map database TIMESTAMPs to java Date objects.

Environment

  • JBoss Enterprise SOA Platform (SOA-P)
    • 5.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In