on 07-15-2009 6:47 PM
HI,
I have deployed the JDBC drivers (sqljdbc.jar and sqljdbc4.jar) available for the SQL Server 2008 from the microsoft website as described in the how to document for deploying and configuring JDBC and JMS adapters.
I am running a JDBC to FIle(XML) scenario. When I go and see on the RWB CC monitoring, I get this error
Error during database connection to the database URL 'jdbc:sqlserver://hostname:1433;databaseName=123_Nagasatya' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://hostname:1433;databaseName=123_Nagasatya': UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 50.0)'
WRT to the SQL server the port 1433 is open on the host and there is no firewall on the PI server as well as the SQL Server. Both are on different machines.Any help would be greatly appreciated.
Regards.
Hi,
Check the version of JDK of PI and see in the documentation which version is required for "sqljdbc.jar" and "sqljdbc4.jar".
Regards
Ivan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check out this link will give you all details...
[http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en|http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en]
Hope this will help,
Nilesh
Hi Nagasatya,
The JDBC for SQL 2008 is not complatible with JDK 1.4., But you can use JDBC for 2000/2005 which also can establish connection with SQL 2008 and It be compatible with JDK 1.4.. I give you the link.
Pls, check it:
[ JDBC|http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en]
Regards
Ivan
Hey Ivan,
This is Nagasatya.
I did what you said and deployed the drivers for the SQL Server 2005.
Then I configured the Sender and Receiver CCs. I am doing a JDBC 2 JDBC scenario now to check the JDBC connection.
When I go to the RWB to monitor, the Sender CC has the same error while the Receiver CC is working perfectly.
The URL and the driver path are the same for both the sender and receiver channels.
I dont know what is wrong here.
Regards.
Edited by: DNSPK on Jul 22, 2009 7:11 PM
Hi Sujan,
This is the link.
[JDBC|http://www.microsoft.com/downloads/details.aspx?familyid=c47053eb-3b64-4794-950d-81e1ec91c1ba&displaylang=en]
or
You can also use the one on the market place.
Go to http://service.sap.com/msplatforms -> SQL Server
get zip-file sqljdbc_12_hotfix.zip contains the sqljdbc.jar file.
It should work.
Please let me know if you have any questions.
Regards.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.