Skip to Content
avatar image
Former Member

Picking data from multiple tables using JDBC

Hi Experts,

Is it possible to pick the data from multiple Oracle databases at once in an interface using JDBC? If so, How to go about it?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2015 at 06:00 AM

    Hi Nishat,

    Please chek the below thread.

     

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2015 at 07:19 AM

    Hi Nishant,

    My few cents, there are some problems if you have different ORACLE version because you only can have one ORACLE driver installed in your PI version, i haven't tried the trick suggested by Bhavesh Kantilal in this thread

    From multiple schemas i think you can have problems to take the data at once, i think the better approach is to have several scenarios to pick the data and one to merge the data.

    Check this note 941317 - XI / PI JDBC Adapter: Known Problems / Incompatibilities as well

    Regards.

    Add comment
    10|10000 characters needed characters exceeded