Cannot connect to JDBC data source

[Former Member]

We are trying to configure Visual Composer to connect to the backend BI-ABAP

BI database which is DB2, from the Visual Admin on the windows box.

Downloaded the driver for DB2 JDBC from IBM website

(ibm_data_server_driver_package_win64_ALL_LANG_v97.exe) Not sure if this is the correct driver, because we are unable to connect to the BI

Landscape information

BI- ABAP: NW 701 SP4 AIX 6100-3/DB2 v9.5.0.4,FIXPACK 4

BI-JAVA: NW 701 SP4 WIN2003 X64/SQL2005 SP3

When i run this url http://servername:port/TestJDBC_Web/test2 i i get the following error

Exception Details:

com.sap.ip.bi.sdk.exception.BIConnectionFailedException: Cannot open the connection

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnectionEx(JdbcConnectionFactory.java:238)

at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.getConnection(JDBCModel.java:796)

at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.getTables(JDBCModel.java:132)

at com.sap.ip.bi.sdk.trialarea.connector.servlet.controller.Control2.doPost(Control2.java:25)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

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:104)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection.(JdbcManagedConnection.java:123)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectionFactory.createManagedConnection(JdbcManagedConnectionFactory.java:112)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:338)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:262)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnectionEx(JdbcConnectionFactory.java:233)

... 19 more

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot connect to JDBC data source

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:336)

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connect(Connection.java:99)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection.(JdbcManagedConnection.java:118)

... 23 more

Caused by: java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:532)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:320)

... 25 more

[Former Member]

Hi,

you can check the configuration:

http://help.sap.com/saphelp_scm50/helpdata/en/43/e35b3315bb2d57e10000000a422035/content.htm

Regards, Mayur

[rachidroughi]

"We're sorry, but this content is not accessible"

Could you please, copy and past the content of the article?

Thank you in advance.

Regards,

Rachid.