Skip to Content
0
Former Member
Sep 12, 2007 at 03:05 PM

UD Connect for MSSQL Server 2000

26 Views

Hi,

We tried to setup BI-JDBC connector using UD Connect for SQL Server 2000 using the How to Guide : Configure UD Connect on the J2EE server for JDBC Access to External databases.

System Details:

BI System is on Oracle.

External System is on MSSQL 2000.

When we tried to do the smoke test with the URL:

http://<server>:<port>/TJdbc/servlet/TestJdbc

ie:- wherein the <server> = BI System Host name and port is 50000.

We got the foll error: "404 Not Found. The requested resource does not exist".

Then, we tried with the other URL:

http://<server>:<port>/TestJDBC_Web/TestJDBCPage.jsp

where <server>= BI System Host name & port is 50000.

We got the TestJDBC Page wherein we selected the

Connection name : SDK_JDBC and click 'Select Connection' ,

<b>We have got the foll error:</b>

Test JDBC Page

Error!

Could not connect to database. Connection is inactive or does not support JDBC.

Go back

Details:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseImplSortCursorResultSet.setupTempFile(Unknown Source) at com.microsoft.jdbc.base.BaseImplSortCursorResultSet.postSetupInitialize(Unknown Source) at com.microsoft.jdbc.base.BaseResultSet.(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonGetNextResultSet(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source) at com.microsoft.jdbc.base.BaseDatabaseMetaData.getTables(Unknown Source) at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.getTables(JDBCModel.java:134) at com.sap.ip.bi.sdk.trialarea.connector.servlet.controller.Control2.doPost(Control2.java:23) 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:387) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160) 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:100) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170) .

Could u pls let me know if any additional settings need to be done or taken care of?

Rgds

Syam