Visual composer JDBC

[former_member188977]

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 ?

[Former Member]

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&displa... 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

[Former Member]

Awesome. You post the problem, you come up with the solution.

This needs testing alright.

[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...

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Ignacio,

Just from looking at the configuration from post: , 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

[former_member188977]

Thanks Jimmy, but Yes, I´m using

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

I´m reading again steap by steap the documentation and the posts but I don´t find the error..

[Former Member]

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