http://server:port/ftp jdbc ....connection to DB failed

[Former Member]

Hi All,

While testing the http://server:port/ftp jdbc connection to DB failed.pls help

Details of error-:

ClassNotFoundException Occurred : Driver Class Could not be found.com.microsoft.sqlserver.jdbc.SQLServerDriver

-

---

Exception Stack Trace : java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

-

---

Loader Info -

---

ClassLoader name: [sap.com/testconnectionsEAR]

Parent loader name: [Frame ClassLoader]

References:

common:service:http;service:servlet_jsp

service:ejb

common:service:iiop;service:naming;service:p4;service:ts

service:jmsconnector

library:jsse

library:servlet

common:library:IAIKSecurity;library:activation;library:mail;library:tc_secssl

library:ejb20

library:j2eeca

library:jms

library:opensql

common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:adminadapter;service:basicadmin;service:com.sap.security.core.ume.service;service:configuration;service:connector;service:dbpool;service:deploy;service:jmx;service:jmx_notification;service:keystore;service:security;service:userstore

interface:resourcecontext_api

interface:webservices

interface:cross

interface:ejbserialization

library:sapxmltoolkit

Resources:

I:\usr\sap\XIT\DVEBMGS00\j2ee\cluster\server0\apps\sap.com\testconnectionsEAR\servlet_jsp\ftpjdbc\work

I:\usr\sap\XIT\DVEBMGS00\j2ee\cluster\server0\apps\sap.com\testconnectionsEAR\servlet_jsp\ftpjdbc\root\WEB-INF\classes

Loading model: {parent,references,local}

-

---

at com.sap.engine.frame.core.load.ReferencedLoader.loadClass(ReferencedLoader.java:382)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:141)

at com.sap.util.TestJDBCUtil.testDriverManagerConnect(TestJDBCUtil.java:30)

at com.sap.tests.TestJDBCConnectionServlet.processRequest(TestJDBCConnectionServlet.java:41)

at com.sap.tests.TestJDBCConnectionServlet.doPost(TestJDBCConnectionServlet.java:74)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Database is MSSQL, for connecting to the database we are giving Username : SIDADM and password for the same.

Regards,

Prashant

[Former Member · Accepted solution]

Hi Prashant,

Your driver may not be installed or deployed properly. Check the following link for more information.

Hope this helps!

Regards,

Kshitij

[Former Member · Accepted solution]

Hi,

Thanks for ur quick reply ,We have already installed the required JDBC drivers and we deployed the same using SDM. SDM showed us the successful deployment of drivers.Could you please let me know the way to check whether drivers have been installed properly or not?

Regards,

Prashant

[Neil_McLyn]

Hi Prashant -

We are facing the same issue how did you manage to fix it?

Thanks and Regards

Neil McLyn

[Former Member]

Hi Prashant,

If there wasn't an error during installation, then you dont need to worry about the installation...Check the deployment...

Go through this HOW TO guide for installation and deployment of drivers for JDBC adapter.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Regards,

Kshitij

[Former Member]

Hi,

We have already checked this guide.

on the receiver side I am using JDBC

in message monitoring I am getting given below errors

Error Attempt to establish database connection failed with SQL error com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://10.1.45.36:1433;databaseName=XIT': UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 50.0) 
2009-02-03 16:20:57 Error Exception caught by adapter framework: Database connection could not be established 
2009-02-03 16:20:57 Error Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Database connection could not be established. 
2009-02-03 16:20:57 Error The message status set to NDLV.

When we checked the entries in provider.xml after the req deployment ,

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE provider-descriptor SYSTEM "library.provider.dtd">
  <provider-descriptor>
    <display-name>com.sap.aii.af.jmsproviderlib</display-name>
    <component-name>com.sap.aii.af.jmsproviderlib</component-name>
    <major-version>7</major-version>
    <minor-version>0</minor-version>
    <micro-version>6</micro-version>
    <provider-name>sap.com</provider-name>
      <references>
         <reference type="library" strength="weak">jms</reference>
      </references>
    <jars>
	<jar-name>sqljdbc.jar</jar-name>
	<jar-name>sqljdbc4.jar</jar-name>
    </jars>
  </provider-descriptor>

Can nebody comment on the same.

Regards,

Prashant

[Former Member]

Hi,

After deploying new one ..we are getting new error ..

Attempt to establish database connection failed with SQL error com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://10.1.45.36:1433;databaseName=XIT': com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xitadm'. 
2009-02-03 17:37:34 Error Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Database connection could not be established

.

Pls suggest.

Regards,

Prashant

[Former Member]

Thanks