file content to database scenario

[Former Member]

Hi All,

I am doing file content conversion to database scenario.

In this scenario i got the following problem.

Error during database connection to the database URL 'jdbc:mysql://ibxi:3306/javatest' using the JDBC driver 'org.gjt.mm.mysql.Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:mysql://ibxi:3306/javatest': SAPClassNotFoundException: org.gjt.mm.mysql.Driver'

In this i am connecting to mysql database.at that time in receiver side i got the problem.

please do the need ful.

Thanks & Regards,

Kakshayini.

[vikas_agarwal · Accepted solution]

Hi,

It seems that you have not installed the Drivers for JDBC adapter.

Use this doc to install Drivers in XI.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/how%20to%...

Regards,

vikas

[Former Member]

Sorry for the above post..

First check whether the required drivers has installed on your J2EE Engine or not. If it is not installed, please follow the bellow steps,

1.Get the existing <b>aii_af_jmsproviderlib.sda</b> file from your SAP XI installation (if you already have JDBC or JMS drivers deployed).

2. Unzip the file, add the required .jar files (each database has it's own .jar file that has

to be deployed on your J2EE Engine ).

For example if it is SQL server db -mssqlserver.jar

3. Again zip the flies including all .jars with the name "aii_af_jmsproviderlib" and it has

to be deployed in to the J2EE Engine.

4. Start the SDM (Software Deployment Manager) and select the

aii_af_jmsproviderlib.zip file and start the deployment.

I hope once you have done this thing, the problem will be solved.

Regards,

Velan

<b></b><b></b>

[Former Member]

Hi,

are you using XI 3.0 0r PI 7.0

if it is 3.0

THis is Solution

[Former Member]

Hi,

Check if below mentioned are correct in your JDBC configuration.

1. JDBC Driver

2. Connection Parameters

3. User name

4. Password

5. Port

6. DataBase Name

7. Table Name

8. Key Field used in Database

9. Empty field handling

10. Make sure drivers are installed or not

11. Make sure database is up & running

By the way what is the version of SQL server you are using?

Regards,

Sarvesh

[vikas_agarwal]

Hi,

Have you installed the JDBC drivers for SQL in XI??

Thanks