on 09-26-2011 11:09 AM
Dear Friends
I have strange problem. I am failed to connect with SQL Server from PI Quality system. My configuration of communication channel is working perfectly fine in Development system. Same configuration for Communication channel is not working in Quality system.
Below is the error log from communication channel monitoring.
Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: 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:sqlserver://*************;databaseName=*************;user=sa;password=***************;':
SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDrive
Please tell me how can I solve this problem. Any reply from you will be appreciated greatly.
Thanking you
Regards
Naeem
Hi Naeem,
Try restarting the JDBC channel it will work. if not try to increase the thread count for JDBC Adapter.
Regards,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: 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:sqlserver://**************;databaseName=***************;user=sa;password=****************;':
SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDrive
JDBC Drivers for MS SQL Server is not installed in QA box. Please check that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
20. ClassNotFoundException while using SQL Server 2005 Driver
Q: I am not able to connect to DB using SQL Server 2005 driver if I use com.microsoft.jdbc.sqlserver.SQLServerDriver as driver class name. I get [classNotFoundException|http://sapnwnewbie.blogspot.com/2011/09/sapclassnotfoundexception-when-using.html]. Why?
A: Driver class names for SQL Server 2000 driver and SQL Server 2005 driver are different.
If you are using SQL Server 2005 driver, then class name should be as follows:
Driver class: com.microsoft.sqlserver.jdbc. SQLServerDriver
URL :jdbc:sqlserver://<db_Server>:port;databaseName=< db_name>
If you are using SQL Server 2000 driver , then class name should be as follows:
Driver class: com.microsoft.jdbc.sqlserver. SQLServerDriver
and URL is as follows:
jdbc:microsoft:sqlserver://<db_server>:port; databaseName=<db_name>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
You could also check note:
831162 FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter
question
20. ClassNotFoundException while using SQL Server 2005 Driver
Regards
Sarah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.