generic JDBC db-con displays no table information (SAP BO BI-Plattform 4.0)

[Former Member]

Dear experts,

we try to run our generic JDBC-Driver (java 1.5 implementation of JDBC-Interface, Type-4-Driver) on SAP BO 4.0 with Universe Designer 14.0.2.364.

Running the Quick Design Wizard of universe design tool:

We're able to define the database connection in the wizard for the universe parameters and see (in debug mode of our driver) that the button-klick "Test" opens successfully a connection ("The server is respondig!"). After a klick on "next" to create initial classes and objects, the left view "database tables and columns" only displays our schema-name but not our tables and columns. We do alse see (in debug mode of our driver) that getTables() or getColumns() of the DatabaseMetadata is never called.

Does anyone have an idea how to set up generic jdbc driver to display table information in the universe designer? Maybe der is a special implementation in the driver needed for displaying tables?

Many thanks in advance.

[Henry_Banks]

Hi,

It sounds like the User / Pwd you are using for the connection doesn't have enough permissions to browse the table catalogue

Also, for what it's worth, give it a go in Information Design Tool

Finally, Trace the UDT / IDT clients, and analyze the logs - you will get some plain text in there explanating the |E|

Regards,

H

[Former Member]

Many thanks for your reply!

I tried to run our JDBC-Driver with Information Design Tool, but it gives me an old known error beloning the RMI-Connection used by our driver to connect to our servers:

10.02.2012 09:28:18 WARN de.csp.chronos.common.rmi.commands.AbstractChronosServerCall: RemoteException occurred in server thread; nested exception is:

java.rmi.UnmarshalException: error unmarshalling arguments; nested exception is:

java.net.MalformedURLException: no protocol: BusinessObjects

java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:

java.rmi.UnmarshalException: error unmarshalling arguments; nested exception is:

java.net.MalformedURLException: no protocol: BusinessObjects

at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:336)

For the Universe Designer we solved this problem by setting the driver-jar to the System-CLASSPATH (under Win7). But this seems not to work for Information Design Tool. This problem seems to be in the Classloader or codepage, but we do not know how to fix it without System-CLASSPATH.

Could you pleas give me a hint how to turn on Logging/Tracing in Universe Design Tool? Many tries to switch loggin on with the configuration files are not working

thanks again in advance

[Former Member]

I've got the solution for the Problem "no table information readable by UDT":

Method "getSearchStringEscape()" may not return null. The only way to display table and column information in UDT is to return "/" in this method!

Our other Problem using RMI in JDBC-Driver still remains

We localized the Problem for IDT:

IDT uses a URLClass Loader which contains the URL for:

- the jar-file of "dbd_jdbc" which is defined in jdbc.sbo as "JARFile" of the com.sap.connectivity.cs.java.drivers.jdbc.JDBCDriver

- the "dbd_jdbcwrapper" for com.sap.connectivity.cs.java.drivers.jdbc.wrapper.JDBCWrapper

- all jar-files given in the ClassPath-Tag

all specified by absolute location in the system. Main Problem here is, that BusinessObjects always is installed in the directory containing "SAP BusinessObjects Enterprise XI 4.0" for example. This path contains white spaces. For the dbd_jdbcwrapper and path entries in the classpath white spaces could be replaced by %20 in correct URL syntax. But the dbd_jdbc path could not be changed because it seems to be constructed anywhere in the ConnectionsServer or IDT.

For further information: RMIClassLoader expects URL given in the URL-Set of the URLClassLoader space separated. Loading a URL containing white spaces causes the RMIClassLoader to separate it to several URLs. This is the main cause of the problem!

Do you know where the path to dbd_jdbc.jar is constructed to replace all spaces with %20 or if there is any other workaround for this problem?

Many thanks in advance, it would be great if i had a solution for this Problem