Skip to Content
avatar image
Former Member

Universe connection error on JDBC driver - DF

Hi,

I am getting the following errors while creating a JDBC connection in the Universe using data federator.

"CS: Java Class not found in classpath : LeSelect.ThinDriver.ThinDriver"

"DBD: No suitable driver"

Below is the entries for DF in the jdbc.sbo file.Please let me know what am I doing wrong in the process.

<DataBase Active="Yes" Name="Data Federator Server">

<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>D:\Program Files\Business Objects\BusinessObjects Data Federator 12\JdbcDriver\lib\thindriver.jar</Path></ClassPath>

<Parameter Name="JDBC Class">LeSelect.ThinDriver.ThinDriver</Parameter>

<Parameter Name="URL Format">jdbc:leselect://$DATASOURCE$/$DATABASE$</Parameter>

</JDBCDriver>

<Parameter Name="Family">Business Objects</Parameter>

<Parameter Name="Version">rdbms_datafederatorjdbc.txt</Parameter>

<Parameter Name="SQL External File">datafederator</Parameter>

<Parameter Name="SQL Parameter File">datafederator</Parameter>

<Parameter Name="Driver Capabilities">Query</Parameter>

<Parameter Name="Extensions">datafederator,jdbc</Parameter>

<Parameter Name="Query TimeOut Available">No</Parameter>

<Parameter Name="Array Fetch Size">10</Parameter>

<Parameter Name="Strategies File">datafederator</Parameter>

</DataBase>

Regards,

Sreeni

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 13, 2010 at 03:40 AM

    Hi,

    Look at chapter three of this document...

    Data Federator Release Notes

    [http://help.sap.com/businessobject/product_guides/boexi3SP1/en/xi3_sp1_df_releasenotes_en.pdf]

    Regards,

    Bashir Awan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Try with below entries in JDBC.SBO file.

      Change the path driver path according to your installation.

      <DataBase Active="Yes" Name="Data Federator Server">

      <JDBCDriver>

      <ClassPath><Path>C:\Program Files\Business Objects\BusinessObjects Data Federator 12 Drivers\JdbcDriver\lib\thindriver.jar</Path></ClassPath>

      <Parameter Name="JDBC Class">com.businessobjects.datafederator.jdbc.DataFederatorDriver</Parameter>

      <Parameter Name="URL Format">jdbc:datafederator://$DATASOURCE$/$DATABASE$</Parameter>

      </JDBCDriver>

      <Parameter Name="Family">SAP BusinessObjects</Parameter>

      <Parameter Name="Version">datafederator_jdbc.setup</Parameter>

      <Parameter Name="Description File">datafederator</Parameter>

      <Parameter Name="SQL External File">datafederator</Parameter>

      <Parameter Name="SQL Parameter File">datafederator</Parameter>

      <Parameter Name="Strategies File">datafederator</Parameter>

      <Parameter Name="Driver Capabilities">Query</Parameter>

      <Parameter Name="Extensions">datafederator,jdbc</Parameter>

      <Parameter Name="Query TimeOut Available">No</Parameter>

      <Parameter Name="Array Fetch Size">10</Parameter>

      </DataBase>

      Make sure ports are opened between the server and client machine.

      Thanks,

      Amit