Skip to Content
author's profile photo Former Member
Former Member

How to use Native SQL in receiver JDBC adapter

Hi All,

Could someone pls advice me on how to use Native SQL in receiver JDBC adapter. We have a SAp to Oracle DB scenario.

Curenttly we are using Message protocol as XML SQL Format. and it's taking 3 hrs to insert 1.5 million records to the db. we want to try using Native SQL to see if it enchances performance.

Any suggestions are welcome...

Regards,

XIer

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 12, 2008 at 06:20 PM

    Hi,

    Though I do not think this is the correct forum for this question, I suggest you to check where exactly is the "insert bottleneck" : in the AFW (does it take too long for the XMLSQL SAX parser to build the SQL statement from the message ?) or in the database (did you trace the db activity while inserting records) ?

    The native mode of the JDBC receiver adapter allows you to put a "real" SQL statement in one of its property (though I do not know if - and how - you can bind values to this prop), and maybe it's size limited (setting 1.5million of records and their corresponding values could be quite hard) ...

    Also, what sort of columns your insert deals with (BLOB ? RAW ?), this could also lead to perf issues

    Rgds

    Chris

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.