cancel
Showing results for 
Search instead for 
Did you mean: 

Error in JDBC receiver channel connecting to SQL DB

Former Member
0 Kudos
177

Hi All,

Please help me on following Error:

JDBC Message processing failed, due to Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource:

DriverManagerException: Cannot estblish connection to URL XXXXX : SAPNoClassDefFoundError: com.morcrosoft.jdbc.base.BaseDriver

I had downloaded drivers from microsoft website for SQL Server 2000. When i download i am getting .tar file insted of .jar file. i untar the file and deployed in PI server, also installed util jar in class path.

please advice me. How i can reslove this issue.

Thanks

Vick

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Vick,

If you configure as mentioned in this document it should work with out any issues:

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

Also check this thread where he has issues in installing:

---Satish

Former Member
0 Kudos

Hi Satish,

Thank you for your quick responce, our basis team say they have done all possible tries. I believe that i had provided wrong drivers. Can you please suggest me from where i can download MSSQL Server 2000 driver for SP4. Please help me on this issue.

Thanks

Vick

Former Member
0 Kudos

I had experianced similar situation,

resolution - download and use latest JDBC driver for SQL server 2005 from MS site.

redeploy the dirver .

Also let me know your connection string in JDBC CC. It is different for different version of drivers.

Former Member
0 Kudos

Hi All,

When i am testing the connection i am getting following error:

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

-


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

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

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

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:401)

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

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

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

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

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

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

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

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(AccessController.java:219)

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

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

Thanks

Vick

Former Member
0 Kudos

Dear ..

My above given answer (infact all) are for the same issue, please act as per the answer.

Former Member
0 Kudos

Hi

Check if Driver is compatible for the DB , login to the Microsoft Site and see corresponding Drivers.

More importanly Drivers should be corresponding to the JDK version 1.4.2 above versions wonot work with SAP XI Deployment as XI works on JDK 1.4.2 , sometimes higher version JDK cause problem too

please check this for deploying again.

rgds

srini

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

please undeploy the driver and once again deploy the jar file sqljdbc.jar

remeber while zipping file dont follow shortcut like drag and drop this will detroit ascii encoding of ur driver file

so unzip .sda file , add driver jar and then again zip .sda

then deploy

one more thing to remember that there is a bug with drivers for SQL 2000

you need to download patch from marketplace

install that correction then u wil be able to solve ur issue

thanks

sandeep

Former Member
0 Kudos

Hi All,

Now driver deployed, still i am getting following error. what would be the case?

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException:

Unable to create new pooled resource: DriverManagerException: Cannot establish connection to

URL 'jdbc:microsoft:sqlserver://XXXX':

ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Please advice

Thanks

Vick

Former Member
0 Kudos

there must be some issue in Deployment, because we are using JDBC driver for SQL server 2005 and 2000 both.

Former Member
0 Kudos

Hi Vick,

>

> com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource:

> DriverManagerException: Cannot estblish connection to URL XXXXX : SAPNoClassDefFoundError: com.morcrosoft.jdbc.base.BaseDriver

>

I think you have misspelled microsoft in the Driver name in th Communication channel. Check it out.

Regards,

Alka.

Former Member
0 Kudos

Hi Vick ,

The error clearly mention that drivers for JDBC are not properly installed. Reinstall your JDBC drivers and then give it a try.

Thanks

Ajay