关于Universe和IDT链接数据库的JDBC配置

情况一：Universe链接Oracle（选择客户端链接方式）

 

开发端：客户端装的BO Client Tool 4.0版本要和Oracle Client要一致，即同为32位或64位

运行时：由于BOE 4.0为64位，所以在BOE调相应驱动时会调用：C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib64\dbd_oci.dll

所以要保证在服务器端安装64位的Oracle client， 32位的会报错

 

情况二：Universe 链接SQL Server或Oracle (用JDBC方式连接)

 

1.配置classpath环境变量

2.将C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc

目录下的文件jdbc.sbo文件打开，添加类路径：

    <DataBases>
        <DataBase Active="Yes" Name="Generic JDBC datasource">
            <JDBCDriver>
                <!--  Uncomment and edit the following lines
                     to define java classes required by JDBC driver
                &lt;ClassPath&gt;
                    &lt;Path&gt;your jar or class files directory&lt;/Path&gt;
                &lt;/ClassPath&gt;
                 -->
<ClassPath>
<Path>C:\\XJL\\Install Software\\Drivers\\sqljdbc.jar</Path>
</ClassPath>

                <Parameter Name="JDBC Class">$JDBCCLASS$</Parameter>
                <Parameter Name="URL Format">$DATASOURCE$</Parameter>
            </JDBCDriver>
            <Parameter Name="Array Fetch Size">10</Parameter>
        </DataBase>
    </DataBases>
</DriverConfiguration>

 
补充：

当时解决的chartset issue: Conversion from UTF8 tochartset failed:Encoding not loaded 

2.Also you need to  add "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64" to the PATH environment variables on the SAP Business Objects Enterprise machine

(the purpose of adding PATH environment is to fix the chartset issue. Error message : “Conversion from UTF8 tochartset failed:Encoding not loaded” )