当发布到远程 WebSphere 服务器时 Microsoft SQL Server JDBC 驱动程序的局限性

有这样一个已知问题:当使用 Microsoft® SQL JDBC 驱动程序发布到远程 WebSphere® 服务器时,可能会发生下列错误,它会阻止您建立数据库连接:

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.

要解决此问题:

  1. 将下列 Microsoft SQL Server JAR 文件复制到 WAS_installdir\AppServer\lib 文件夹(其中 WAS_installdir 是 WebSphere Application Server 的安装目录):
    • msbase.jar
    • mssqlserver.jar
    • msutil.jar
  2. 如果想要将 JAR 文件放置在其它位置:
    1. 打开以下目录:WAS_installdir\AppServer\properties
    2. 编辑 server.policy 文件并将对 JAR 文件的许可权更改为读访问权,例如:
      // Drivers and other system classes should be stored in this
      // code base.
      grant codeBase "file:${was.install.root}/lib/system/-" {
          permission java.security.AllPermission;
      permission java.io.FilePermission
      "${was.install.root}${/}lib${/}system${/}msbase.jar", "read";
      permission java.io.FilePermission
      "${was.install.root}${/}lib${/}system${/}msutil.jar", "read";
      permission java.io.FilePermission
      "${was.install.root}${/}lib${/}system${/}mssqlserver.jar", "read"; 
使用条款 | 反馈
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.