Skip to Content

Calling Stored Procedure without JDBC-Adapter

Hallo,

as it is not possible calling Stored Procedures with the parameter Typ Record in Oracle my question: It is possible connecting to DB using native java-code for example in Mapping?

Thanks in advance,

Frank

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 30, 2006 at 02:47 PM

    Hi Frank,

    If you want to do without JDBC adapter , I think then option is using Java Proxy and from java proxy you can use JAVA DB APIs to connect to data base..

    Check this thread with JDBC Lookup.

    JDBC adapter - no UPDATE to database

    (last answer)

    Thanks,

    Morthy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 30, 2006 at 02:51 PM

    Frank,

    you can generally do everything in your mappings what you can do in java.

    The only thing is that you need to deploy the required jars to the webas (using e.g. visual admin).

    Then u can import your libraries and build your stuff.

    Greets,

    Helge

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Frank,

      Maybe you can use the DB look up using the JDBC adapter in your mapping.

      Just check this blog for the same,

      /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

      As for calling an Oracle Strored Procedure, it is possible using a RECEIVER JDBC adapter, but not a SENDER JDBC adapter.

      <i> import the jdbc-driver (oracle) in an archive in Designer.</i>

      Also, this imported archive should be under any Namespace, but, it should be in the same SWCV as the one in which the mapping is being executed.

      Regards,

      Bhavesh

  • avatar image
    Former Member
    May 30, 2006 at 04:23 PM

    Hi,

    only to add to the previous posts: If you are going forward and connect to a DB in a mapping, keep in mind that mappings are stateless and can be executed more than once for the same message, so you should not write / manipulate anything into the DB in the mapping. Reading from the DB though should be fine.

    Regards

    Christine

    Add comment
    10|10000 characters needed characters exceeded