About JDBC adapter

[Former Member]

hi,everyone

Long time no see.

Just i make a demo,My trouble is that i have installed the oracle db in my laptop,and have configured the JDBC adapter as sender,but the error happened like following statements:

Sender Adapter v1711 for Party '', Service 'BS_FOXCCON':

Configured at 04:41:01 2006-05-15

Processing Error: Loading jdbc driver 'oracle.jdbc.driver.OracleDriver' failed: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Found in negative cache

-

---

Loader Info -

---

ClassLoader name: [service:com.sap.aii.adapter.jdbc.svc]

Parent loader name: [Frame ClassLoader]

References:

service:com.sap.aii.af.cpa.svc

service:com.sap.aii.af.ms.svc

service:com.sap.aii.af.svc

service:com.sap.aii.adapter.xi.svc

library:com.sap.aii.af.lib

library:com.sap.aii.messaging.runtime

library:com.sap.xi.util.misc

common:service:iiop;service:naming;service:p4;service:ts

common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:adminadapter;service:basicadmin;service:com.sap.security.core.ume.service;service:configuration;service:connector;service:dbpool;service:deploy;service:jmx;service:jmx_notification;service:keystore;service:security;service:userstore

library:ejb20

library:sapxmltoolkit

library:com.sap.util.monitor.jarm

library:com.sap.guid

library:com.sap.tc.Logging

library:jms

Resources:

/usr/sap/IXI/DVEBMGS10/j2ee/cluster/server0/bin/services/com.sap.aii.adapter.jdbc.svc/aii_adapter_jdbc_svc.jar

Loading model: {parent,local,references}

-

---

Available JDBC drivers:

No deployed JDBC Drivers found

Would u like to give me some ideas?

Best Wishes and Thanks

Amanda

[MichalKrawczyk · Accepted solution]

hi Amanda,

you need to deploy the jdbc driver

https://websmp107.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDrivers.zip

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member]

Hi Amanda!

Please have a look at this thread..

Hope it helps you!

cheers,

Prashanth

[bhavesh_kantilal]

Amanda,

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

To install oracle driver, just check this link,

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

The details that have to be entered while adapter configuration,

jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)>

Driver oracle.jdbc.driver.OracleDriver

Regards,

Bhavesh

[Former Member]

Thanks for your answer.

The trouble about the JDBC driver is OK, But now the new trouble is happened that there is a Informix Database,not oracle BD, so i want to know how to configure

the 'JDBC driver: ' and the 'connection:' for the informix's JDBC driver.

Give me some ideas and Thanks.

Amanda.

[Former Member]

Hi, Bhavesh

Do you have a handbook about 'how to config the external drivers for JDBC&JMS' for Linux platform,not for windows.

Give me some ideas and thanks.

Amanda

[bhavesh_kantilal]

Amanda,

Am not sure , but I think the driver installation procedure across windows and linux for JDBC / JMS should be the same.

ASFAIK, there is no separate doc available for a specific OS.

Regards,

Bhavesh

[Former Member]

hi,Bhavesh:

Thanks for your answer. I have done following the doc,but after the '3.2 step' in the doc is not running for linux platform

I don't have good ideas.

Thank you all the same

Amanda

[Former Member]

hi,Bhavesh

Great, The JDBC driver has been imported successful

and thank for your help.

But some error happened when the JDBC adapter is running like the below messages:

Processing Error: Accessing database connection 'jdbc:informix-sqli://10.0.0.12:1025/e:INFORMIXSERVER=ol_shaw2k01' failed: java.sql.SQLException: Transactions not supported

Addtional information: JDBC driver 'com.informix.jdbc.IfxDriver' loaded successfully, additional driver information:

Available JDBC drivers:

com.informix.jdbc.IfxDriver, 2.21 JDBC compliant

So i want to know whether the JDBC driver can be supported for the informix or not. From the error message 'transactions not supported' analysed, i think so.

Pls give me some suggestion and thanks.

Best Wishes

Amanda

[Former Member]

Yes Amanda,

JDBC is ofcourse supported with Informix. I think you better go through this link and let me know that you can test your connection successfully.

http://gethelp.devx.com/techtips/info_pro/10min/10min0800/10min0800.asp

I think with this you will get your JDBC connection done.

-Nilkanth.

[Former Member]

hi,Nilkanth

Thanks,but what i said is that whether it is possible to connect XI and Informix by JDBC driver or not.

IF it is possible, the error message 'transaction not found' happened, why?

Give me some ideas and Best wishes.

Amanda

[bhavesh_kantilal]

Amanda,

<i>Transactions not supported</i>

Would suggest you to look into your Database and see if the TRANSCATION SUPPORT has been turned off.

Also, go to the <b>ADVANCED MODE</b> of your JDBC adapter and ,

<b>Database Auto-Commit-Enabled (No Transaction Handling)

Set the indicator</b> if you want to deactivate the logical unit of work, which the JDBC adapter requires to guarantee that the data in the database is consistent.

<b>This option is required for JDBC drivers that do not support transactions.</b>

Regards,

Bhavesh

ps mark points for useful answers.

[Former Member]

Thanks Bhavesh

Great,It is working ok.

Best Wishes

Amanda

[Former Member]

hello, Bhavesh

my msn: xiaobaihe80@hotmail.com

Wish to make friends with u.

Amanda

[bhavesh_kantilal]

Hi Amanda,

Nice to know it helped.

Please close the thread by awarding points.

Regards,

Bhavesh

[Former Member]

Hi,

I want to have this scenario 'informix DB->XI->MDM' , the JDBC adapter for informix DB and the file adapter for MDM.

I want to know whether the MDM can receive the data from the third-party like informix DB or not.

Give me some ideas and thanks.

Amanda

[Former Member]

Hi,

I want to have this scenario 'informix DB->XI->MDM' , the JDBC adapter for informix DB and the file adapter for MDM.

I want to know whether the MDM can receive the data from the third-party like informix DB or not.

Give me some ideas and thanks.

Amanda

[moorthy]

HI Amanda,

TO know more-

/people/sap.user72/blog/2005/08/29/mdm-as-a-core-netweaver-component

/people/sap.user72/blog/2005/10/12/advanced-xi-mapping-useful-with-mdm

/people/sriram.vasudevan3/blog/2005/09/01/mdm-55-data-distribution-using-sap-xi

/people/kamaljeet.kharbanda/blog/2005/09/14/sap-netweavercomplete-information-integration-platform

MDM will receive the data from any third party systems thru XI provided it should be given in Required format..

SO in this Case, Mapping will help you to get the Required data format from the legacy system.

Hope this helps,

Regards,

Moorthy