Limitations of Microsoft SQL Server JDBC driver when publishing to a remote WebSphere Application Server
It is a known problem that when you are publishing to a remote WebSphere® Application Server by using a Microsoft SQL JDBC driver, you might get the following error. This error prevents you from making a database connection:
Important: Applicable to WebSphere
Application Server traditional
SystemOut
O [Microsoft][SQLServer 2000 Driver for JDBC]Error opening/loading com.microsoft.util.transliteration.properties.
SystemErr
R java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error opening/loading com.microsoft.util.transliteration.properties.
To work around this problem:
- Copy the following Microsoft SQL
Server JAR files to the x:\AppServer\lib folder
(where x is the directory where WebSphere Application Server is installed:
- msbase.jar
- mssqlserver.jar
- msutil.jar
- If you want the JAR files located elsewhere:
- In the WebSphere Application
Server installed directory, open the following directory.
Where x:\profiles is the directory of your profile for the WebSphere Application Server.x:\profiles\properties
- Edit the server.policy file and change the permissions for the
JAR files to read access, for example.
// WebSphere system classes grant codeBase "file:${was.install.root}/lib-" { permission java.security.AllPermission; permission java.io.FilePermission "${was.install.root}${/}lib${/}msbase.jar", "read"; permission java.io.FilePermission "${was.install.root}${/}lib${/}msutil.jar", "read"; permission java.io.FilePermission "${was.install.root}${/}lib${/}mssqlserver.jar", "read"; };
- In the WebSphere Application
Server installed directory, open the following directory.