JDBC to Proxy- Error in JDBC channel SAP PO 7.3

[Former Member]

Gurus,

Background :

We have fresh

installation of SAP PO 7.3 (Single Stack ) on SQL Server 2013.

Scenraio is : JDBC to Proxy; I’m calling a stored proc.

The basis say they have installed the JDBC drivers correctly, I can ping the server in CMD so the Database is active
This is the error I get in Monitoring

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://XXXXXX:1433;databaseName=XXXX;SelectMethod=cursor' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.jdbc.sqlserver.SQLServerDriver returns: com.microsoft.jdbc.sqlserver.SQLServerDriver.
: SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver'

Please advise what to do.

I always provide points for helpful answers

[former_member184720 · Accepted solution]

Hi V Jay - I'm mnot sure if it is case sencitive but try with the below (cursor /Cursor)

jdbc:microsoft:sqlserver://dbhost:1433;databaseName=example;SelectMethod=Cursor

831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 JDBC Adapter

[Former Member · Accepted solution]

Hi Hareesh,

Same error!!

[former_member184720 · Accepted solution]

Hi V Jay - Change the JDBC driver value to "com.microsoft.sqlserver.jdbc. SQLServerDriver" and try..

[Former Member · Accepted solution]

Hi Haresh! New error

Check if the connection to URL is correct

Thanks for all your help!!

[former_member184720 · Accepted solution]

So it's working..

for the new error - try giving the FQDN/IP in place of the dbhost and make sure there are no typo's

jdbc:sqlserver://dbhost:1433;databaseName=example;SelectMethod=Cursor

FQDN - systemname.company.com -fullu qualified domain name

[former_member184720 · Accepted solution]

If you had checked the provided note -> question #20 has got the answer for you

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. 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> // for your case

           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>

[Former Member]

Hello,

Can u try this?

JDBC Driver Class Name	com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC Connection String Pattern	jdbc:sqlserver://host:1433;DatabaseName=Misdata;SelectMethod=cursor

Thanks

Amit Srivastava

[Former Member]

Thank You Hareesh, Amit!

It worked, Can you explain me when I put IP address it works but when i put the URL it does not? Any reson for this?

Also, im not able to see any data when i click on the message ID , im assuming this is because of the application error,

[former_member184720]

Hi V Jay - May be the DNS lookup fails..

Check with your basis team and see if they have added the entry in the hosts file (sorry not sure of the location)

[iaki_vila]

Hi V Jay,

Try with this connection: jdbc:sqlserver://YourIPAddress;user=Your_User_Name;password=Your_Password;databasename=Your_DatabaseNam

Regards.

[Former Member]

Thanks Vila,

Same error!