Skip to Content

Visual composer JDBC

Hi, I am trying to configure the BI JDBC systems.

My case is identical to the post:

I configured everything exactly this post, but when I test it, the message is:

com.sap.ip.bi.sdk.exception.BIConnectionFailedException: No se puede establecer la conexión at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnectionEx(JdbcConnectionFactory.java:238) at com.sap.ip.bi.sdk.trialarea.connector.servlet.TestJdbc630.service(TestJdbc630.java:67) 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:391) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:265) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:345) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:323) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:865) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:240) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) 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.ip.bi.sdk.exception.BIResourceException: No se puede establecer la conexión at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection.(JdbcManagedConnection.java:135) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectionFactory.createManagedConnection(JdbcManagedConnectionFactory.java:119) at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:312) at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:186) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnectionEx(JdbcConnectionFactory.java:233) ... 18 more

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: La clase DriverName no existe at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:348)

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connect(Connection.java:100) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection.(JdbcManagedConnection.java:130) ... 22 more exception:No se puede establecer la conexión

Please, some suggestion ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2005 at 09:00 PM

    Hi Ignacio,

    Just from looking at the configuration from post: Visual Composer, JDBC, I believe the connection URL is incorrect. Instead of

    URL=jdbc:<b>sap</b>:sqlserver://XX.XX.XX.X:1433;DatabaseName=mydb,

    try

    URL=jdbc:<b>microsoft</b>:sqlserver://XX.XX.XX.X:1433;DatabaseName=mydb

    Hope this helps.

    Regards,

    Jimmy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member IGNACIO VILLALBA MARCORA

      Looks like there is a problem with loading the JDBC driver class from the driver. What jar files did you add for the MSSQL driver using the JDBC Connector service in the VA? And make sure the DriverName property is set to com.microsoft.jdbc.sqlserver.SQLServerDriver using the Connector Container service in the VA. The test servlet uses the default connector, which is named SDK_JDBC.

      --Jimmy

  • author's profile photo Former Member
    Former Member
    Posted on Aug 09, 2005 at 05:39 AM

    Hi All,

    I am getting exactly the same error. Has somebody been able to find a solution?

    If yes kindly mail me to naresh.pai@wipro.com

    Thanks and Regards,

    Naresh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 10, 2005 at 11:34 PM

    I am gettng the same error as well and have been trying to debug for the last 2 days with no success. Someone please email me the solution - rgade@nvidia.com

    Thanks,

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2005 at 01:44 AM

    OK Guys,

    I have solved this problem .....finally......whew.....

    Here are the steps that you need to take to make this work.

    1. Read through and follow the steps in "How To... Configure BI JDBC System for Visual Composer" document

    2. Make sure that you install and use the MSSQL JAR files when you create the new driver in Visual Administrator(all 3 of them) from http://www.microsoft.com/downloads/details.aspx?familyid=9F1874B6-F8E1-4BD6-947C-0FC5BF05BF71&displaylang=en for the Driver (SETUP.EXE file will install the drivers)

    3. Restart the WebAS before testing.

    Let me know if you need more details

    Regards,

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rajendra

      I just checked my JAR files and the sizes are diferent from the ones i downloaded from the link you posted.

      Do you think that might be a problem?

      Because i still cant connect to a SQL Server, i got this error:

      This one, I specified the Port

      Receiver Adapter v2108 for Party '', Service 'ALTERNODEV':

      Configured at 12:12:01 2005-10-11

      Last message processing started 12:23:50 2005-10-17, Error: Accessing database connection 'jdbc:microsoft:sqlserver://144.90.0.233:1433;DatabaseName=ALTERNO2005' failed: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

      Addtional information: JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' loaded successfully, additional driver information:

      Available JDBC drivers:

      oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

      -


      And in this one, i don't specified the port and i still got the same error..

      Receiver Adapter v2108 for Party '', Service 'ALTERNODEV':

      Configured at 12:32:53 2005-10-17

      Last message processing started 12:38:16 2005-10-17, Error: Accessing database connection 'jdbc:microsoft:sqlserver://144.90.0.233;DatabaseName=ALTERNO2005' failed: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

      Addtional information: JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' loaded successfully, additional driver information:

      Available JDBC drivers:

      oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

      com.microsoft.jdbc.sqlserver.SQLServerDriver, 2.2 JDBC compliant

      Please, if someone have some ideas to solve this problem, i'll appreciate it... thanks in advance...

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.