Problem in connecting Oracle 10g with MII 12.1

Former Member · ‎12-16-2009

Hi All,

I am trying to establish a connection between oracle 10g and MII 12.1, the following are the parameters which i gave for establishing connection

JDBC Driver : oracle.jdbc.driver.OracleDriver

Server URL : jdbc:oracle:thin:@essdev03:1521:ID1.

when I checked the status it is in error.

Following is the log corresponding to the error.

Unable to get a connection from the pool

[EXCEPTION]

java.sql.SQLException: ORA-00923: FROM keyword not found where expected

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)

at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)

at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)

at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726)

at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.validateConnection(ConnectionPool.java:386)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.createConnectionObject(ConnectionPool.java:331)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.getConnectionObject(ConnectionPool.java:188)

at com.sap.xmii.Illuminator.tools.database.ConnectionHolder.getConnection(ConnectionHolder.java:89)

at com.sap.xmii.Illuminator.server.ConnectorStatus.<init>(ConnectorStatus.java:41)

at com.sap.xmii.Illuminator.connectors.IDBC.IDBC.getStatus(IDBC.java:50)

at JEE_jsp_Admin_ServerStatus_602051351_1258760302000_1260447354104._jspService(JEE_jsp_Admin_ServerStatus_602051351_1258760302000_1260447354104.java:236)

at com.sap.engine.services.servlets_jsp.lib.jspruntime.JspBase.service(JspBase.java:102)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:140)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:436)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:146)

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

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.runServlet(FilterChainImpl.java:162)

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:81)

at com.sap.xmii.system.SecurityFilter.doFilter(SecurityFilter.java:96)

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:73)

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

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

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

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

at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:48)