cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Error

Former Member
0 Kudos

Hi,

I am using JDBC Receiver to post data to MS SQL Server from simple XML File.

Error i am getting is

JDBC adapter receiver channel F2J_Jdbc_CC1 not initialized. Unable to proceed due to Loading jdbc driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' failed: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver Found in negative cache ------------------------- Loader Info ------------------------- ClassLoa

Exception caught by adapter framework: JDBC Adapter Receiver Channel F2J_Jdbc_CC1: Configuration not initialized due to Loading jdbc driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' failed: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver 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: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:jms Resources: C:usrsapSXIDVEBMGS00j2eeclusterserver0binservicescom.sap.aii.adapter.jdbc.svcaii_adapter_jdbc_svc.jar Loading model: {parent,local,references} --------------------------------------------------------------- Available JDBC drivers: No deployed JDBC Drivers found

Delivery of the message to the application using connection AFW failed, due to: JDBC Adapter Receiver Channel F2J_Jdbc_CC1: Configuration not initialized due to Loading jdbc driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' failed: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver 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: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:jms Resources: C:usrsapSXIDVEBMGS00j2eeclusterserver0binservicescom.sap.aii.adapter.jdbc.svcaii_adapter_jdbc_svc.jar Loading model: {parent,local,references} --------------------------------------------------------------- Available JDBC drivers: No deployed JDBC Drivers found.

It says "No deployed JDBC Drivers found", but when i looked at aii_af_jmsprovider.sda file and unzipped it.. it shows msbase.jar,mssqlserver.jar,msutil.jar. Which means MS SQL Drivers already installed..

What is the reason?

thanks

Seshu

Accepted Solutions (0)

Answers (1)

Answers (1)

moorthy
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi,

Can you check to see if the jar filenames are also included in the provide.xml of aii_af_jmsproviderlib.sda?

Regards,

Bill

Former Member
0 Kudos

Hi

Li: Jar Filenames included in provide.xml

Moorthy: i used the same guide to post the .sda file

any other ideas?

How to restart J2EE Engine?

Thanks

Seshu

Message was edited by: Seshu

moorthy
Active Contributor
0 Kudos

Hi,

<i>How to restart J2EE Engine?</i>

>>>GO to SMICM and Administration->j2EE instance..

Look into this also-

Try restarting the Adapter engine.

Regards,

Moorthy

Former Member
0 Kudos

Hi Moorthy,

getting new error now..

Attempt to establish database connection failed with SQL error java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Exception caught by adapter framework: JDBC Adapter Receiver Channel F2J_Jdbc_CC1: Database connection could not be established

Delivery of the message to the application using connection AFW failed, due to: JDBC Adapter Receiver Channel F2J_Jdbc_CC1: Database connection could not be established.

Connection Details in Receiver JDBC are..

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

Connection: jdbc:microsoft:sqlserver://192.168.0.1:1433;databaseName=TEST

User: sa

Even i tried to ping the database host also.. its fine..

Thanks

Seshu

bhavesh_kantilal
Active Contributor
0 Kudos

Seshu,

Have you already deployed the drivers (msbase.jar, mssqlserver.jar, msutil.jar).

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

If you are using the new SQL Server 2005 jdbc driver (sqljdbc.jar). Setup is basically the same, except the driver is now:

com.microsoft.sqlserver.jdbc.SQLServerDriver

And the URL is slightly different as well:

jdbc:sqlserver://host:1433;DatabaseName=name

Check this. Next, check if your XI server can access the DB server . If the firewall and ports are open.

Regards,

bhavesh