Trying to get UDConnect working - java errors and how to debug

[vince_laurent]

I am not sure if this is the right forum.

Here is my environment:

HP-UX sapjbs B.11.31 U ia64 3535015598 unlimited-user license

java version "1.5.0.23"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0.23-

15may_2011_12_11)

Java HotSpot(TM) Server VM (build 1.5.0.23 jinteg:05.15.11-11:40 IA64,

mixed mode)

When I go to do a 'smoke test' in my browser,

http://sapjbs.ssmhc.com:50000/TestJDBC_Web/TestJDBCPage.jsp

I get the following error:

Application error occurred during request processing.

Details: java.lang.UnsupportedClassVersionError:

com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 50.0)

Exception id: [E6A17B0941E4007500000000000017300004A6C61B93D1B9]

I have tried both drivers:

sqljdbc_1.2

sqljdbc_3.0

and neither work.

Ideas on how to debug?

[sunny_pahuja2]

Hi,

Please make sure that mssql JDBC driver that you downloaded should match mssql database version.

Thanks

Sunny

[vince_laurent]

Please make sure that mssql JDBC driver that you downloaded should match mssql database version.

I have tried all iterations and still no joy.

[sunny_pahuja2]

what is MSSQL version?

Thanks

Sunny

[vince_laurent]

From our wonderful MSSQL Team, I asked our senior BW developer to get information:

" As per them they have 2005 and 2008, but when I asked them specifically they said it doesnu2019t matter when we load the latest version of JDBC server."

That is why I tried both flavors of SQL driver.

Could it be the java version on my HP-UX box?

[vince_laurent]

Windows Server 2008 R2 Standard (x64)

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0

Edited by: Vince Laurent on Jun 29, 2011 5:46 PM

[sunny_pahuja2]

Hi,

Can you please download driver from below link and then try again:

http://www.microsoft.com/downloads/details.aspx?FamilyID=9f1874b6-f8e1-4bd6-947c-0fc5bf05bf71&Displa...

Thanks

Sunny

[vince_laurent]

When I click on the [DOWNLOAD] button I get a test file that says:

Microsoft SQL Server has been continually improving its Java connectivity support. As such we highly recommend you work with the latest version of our JDBC driver. The driver version i.e. SQL Server 2000 JDBC driver, that you are looking for is no longer available for download (please note that the support for the this driver will officially end on July 9, 2010). To download the latest JDBC drivers and additional information see:

u2022 Microsoft SQL Server JDBC Driver Download Page - http://msdn.microsoft.com/data/jdbc

u2022 SQL Server CSS Support Page - http://technet.microsoft.com/en-us/sqlserver/bb895929.aspx

If you would like to provide feedback to the JDBC team, need advice on which version to download, or would like to communicate with the JDBC team, please feel free to do so here (http://blogs.msdn.com/jdbcteam/contact.aspx).