on 07-09-2013 11:16 AM
Hello,
We’re trying to connect to Data Federeator Server, which is in the localhost, through method “conn = DriverManager.getConnection("jdbc:datafederator://localhost", "sysadmin", "sysadmin")”.
However we’re getting always the “No suitable driver” exception.
Data Federator is working properly and we need the program for statistics automation purposes.
The jdbc.sbo file lools like:
“ <DataBase Active="Yes" Name="Data Federator Server">
<Class JARFile="dbd_jdbc,dbd_datafederator">com.businessobjects.connectionserver.java.drivers.jdbc.datafederator.DataFederatorDriver</Class>
<JDBCDriver>
<!-- Uncomment and edit the following lines
to define java classes required by JDBC driver
<ClassPath>
<Path>your jar or class files directory</Path>
</ClassPath>
-->
<ClassPath><Path>D:\\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$;catalog="$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>”
Does anyone know what could be wrong?
Ricardo Prata
Hi Ricardo,
you may go with adapter or you can use ODBC connection also.
Regards,
Shiva Sahu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Shiva,
The problem is that we’re running the data federator program to update statistics automatically and the line code “DriverManager.getConnection("jdbc:datafederator://localhost", "sysadmin", "sysadmin")” is from that program, class RefreshTableColumnStatistics.
We need to implement the “16.3.2.2 The sample program RefreshTableColumnStatistics” from the “Data Federator User Guide (SAP BusinessObjects Data Federator XI 3.0 Service Pack 3)”.
Regards,
Ricardo
Kindly check KBA 1465207 - Getting "No Suitable Driver" error when using Data Federator to connect to Universe De...
Thank you,
Viacheslav.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.