JDBC for BW UDI - Help Needed

[Former Member]

Hi,

I'm new to the J2EE side of things.

I'm trying to setup a new feature in BW 3.5 which allows loading via JDBC drivers.

We have a vanilla BW 3.5 system at SP9 across the board.

I have successfully registed a SQLserver JDBC driver. However the BW install guide then tells me to create a "connector container" in the j2ee administrator. However this node has a red cross against it:

sap.com/com.sap.ib.busdk.dac.connector.jdbc/null

Also when I go to the JDBC test applet:

http://gblonnw01:50500/TJdbc/servlet/TestJdbc

I get the following error:

com.sap.engine.services.jndi.persistent.exceptions.NamingException: Exception during lookup operation of object with name webContainer/applications/sap.com/com.sap.ip.bi.sdk.dac.connector.checkjdbc/TJdbc/java:comp/env/SDK_JDBC, cannot resolve object reference. [Root exception is com.sap.engine.services.connector.exceptions.BaseResourceException: ConnectionFactory "SDK_JDBC" does not exist. Possible reasons: the connector in which ConnectionFactory "SDK_JDBC" is defined is not deployed or not started.] at com.sap.engine.services.jndi.implclient.ClientContext.lookup(ClientContext.java:504) at com.sap.engine.services.jndi.implclient.OffsetClientContext.lookup(OffsetClientContext.java:202) at com.sap.engine.services.jndi.implclient.OffsetClientContext.lookup(OffsetClientContext.java:271) at javax.naming.InitialContext.lookup(InitialContext.java:347) at javax.naming.InitialContext.lookup(InitialContext.java:347) at com.sap.ip.bi.sdk.trialarea.connector.servlet.TestJdbc630.service(TestJdbc630.java:60) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:153) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:385) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:263) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:340) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:318) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:821) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:239) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:147) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37) at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162) Caused by: com.sap.engine.services.connector.exceptions.BaseResourceException: ConnectionFactory "SDK_JDBC" does not exist. Possible reasons: the connector in which ConnectionFactory "SDK_JDBC" is defined is not deployed or not started. at com.sap.engine.services.connector.ResourceObjectFactory.getObjectInstance(ResourceObjectFactory.java:210) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:280) at com.sap.engine.services.jndi.implclient.ClientContext.lookup(ClientContext.java:414) ... 22 more exception:Exception during lookup operation of object with name webContainer/applications/sap.com/com.sap.ip.bi.sdk.dac.connector.checkjdbc/TJdbc/java:comp/env/SDK_JDBC, cannot resolve object reference.

Any ideas?

Something to do with SDK_JDBC is obviously missing or not configured, but I don't know how to resolve it.

Many thanks in advance for any help.

Regards,

Mike

[Former Member]

Hi,

I have the same problem like Mike. The final test, decribed in the Installation-Guide, shows the listed error.

Has anyone configured UDI on an Oracle-Database and HP-UX?

I assume that the problem is related to the Communication-Settings in the Visual Admin.

Do you have any Ideas?? Please come back to me.

Regards,

Benni

[Former Member]

Part of the problem was that the java stuff hadn't installed properly - I needed to re-deploy using SDM, once I had found the right .ear files. Still not convinced this is working propely - I can't use the test applet, but I have sucessfully configured a JDBC UDI connection.

Mike

[Former Member]

Hi,

How did you manage to configute the udi connection SUCCESSFULLY?

[Former Member]

Hi,

I also have the same problem,has any one done this before.Help needed URGENT!!!

[Former Member]

Hi again Mike, Looks like you were at same place we are at. How did you get this thing to work ?