Skip to Content
avatar image
Former Member

Legacy_XI_MySQL

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 05, 2005 at 03:27 AM

    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-guides/how 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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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