Legacy_XI_MySQL

[Former Member]

Hi Friends

Iam working on a scenario where Iam sending a Legacy file and trying to update the Table "VendorMaster" present in MySQL in DatabaseName "MSSQL" through XI.

I want to know what is the Connection and the Drivers that should be specified in the ID of XI.

And should the Driver specified in ID be loaded? If so, Where and How should that be Loaded. I dont know much about Java so please help me out because Iam using JDBC adapter to connect to MySQL.

Thanks in Advance.

[Former Member · Accepted solution]

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide... to install and configure external drivers for jdbc and jms adapters.pdf

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

regards

SKM

[Former Member · Accepted solution]

HI thanks for the Reply

My JDBC Driver is

<b>com.microsoft.jdbc.sqlserver.SQLServerDriver</b>

and my conection is

<b>jdbc:microsoft:sqlserver://localhost:3306;DatabaseName=MSSQL</b>

And I specified the Username and password of my system.

But Iam getting an error.

<b>Receiver Adapter v1109 for Party '', Service 'TBIT40_SQLSERVER_BS':

Configured at 09:09:54 2005-10-05

Initialization error: Loading jdbc driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' failed: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

-

---

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:com.sap.security.core.ume.service;service:connector;service:dbpool;service:keystore;service:security;service:userstore

library:ejb20

library:sapxmltoolkit

library:com.sap.guid

library:com.sap.tc.Logging

library:com.sap.aii.af.jmsproviderlib

Resources:

C:\usr\sap\LXI\DVEBMGS00\j2ee\cluster\server0\bin\services\com.sap.aii.adapter.jdbc.svc\aii_adapter_jdbc_svc.jar

Loading model: {parent,local,references}

-

---

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

sun.jdbc.odbc.JdbcOdbcDriver, 2.1 JDBC compliant</b>

[Former Member · Accepted solution]

Looks like you did not load the SQL Server driver properly. Did you follow the document and deployed the SQL Server driver ?

Go through the document I've mentioned above. It is a step by step guide to deploy JDBC driver for SQL Server.

regards

Shravan

[Former Member · Accepted solution]

Hi

the document you mentioned doesnot contain anything about MySQL. I think MS SQL is different from MySQL.

I have downloaded a jar file from net for MySQL and Iam deploying it. But I have a doubt do I need to load the Driver explicitly or it will be automatically loaded once the jar files are deployed? If the Driver is to be loaded manually then how should that be done?

[Former Member · Accepted solution]

Here are the parameters:

Driver Class: com.mysql.jdbc.Driver

URL: jdbc:mysql://<host>:<port3306>/<database>

You can download the MySQL Drivers depending on your version from:

http://dev.mysql.com/downloads/connector/j/

Follow the above document to deploy the driver.

The file you need to deploy is <b>mysql-connector-java-3.1.10.jar</b>

Becareful to select the right version of the driver.

Regards

Shravan