on 06-24-2009 5:13 PM
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
Vick,
If you configure as mentioned in this document it should work with out any issues:
Also check this thread where he has issues in installing:
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.