cancel
Showing results for 
Search instead for 
Did you mean: 

Calling Stored Procedure without JDBC-Adapter

frank_schmitt3
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

frank_schmitt3
Participant
0 Kudos

Hi Helge,

I only import the needed classes in my user-defined function and import the jdbc-driver (oracle) in an archive in Designer. The compilation works fine, but the select statement don´t work. No error-message can find in the loggings. Is the import in the was over visual admin necessary?

Greets,

Frank

bhavesh_kantilal
Active Contributor
0 Kudos

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

moorthy
Active Contributor
0 Kudos

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.

(last answer)

Thanks,

Morthy