on 08-31-2006 8:28 PM
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
Hi Seshu,
Cross check with this guide-
Regards,
Moorthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.