Skip to Content
author's profile photo
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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Oct 05, 2005 at 03:27 AM

    To install JDBC driver follow the how to guide. to install and configure external drivers for jdbc and jms adapters.pdf

    Configuration of JDBC Adapter for SQL Server

    JDBC Driver =

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

    UserID and Password.

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



    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:

      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.