Skip to Content
avatar image
Former Member

Dropped Oracle Connections

xMII v11.0.2. Several (on different xMII servers) connections to an Oracle v9.2.0.6 DB, using default driver oracle.jdbc.driver.OracleDriver

Data sources stay connected for "a while" then drop out, and am often not able to reconnect for some time.

Our Oracle folks seem to think there is a problem with the client (xMII). Any ideas?

Errors:

<b>(Occurs when xMII tries to query DB when connection has failed)</b>

"An error occurred while creating a DB connection. Connection may have been prevented due to too many waiting connections in pool."

<b>(Occurs when attempting manual reconnect from xMII after connection has failed)</b>

2007-08-02 08:45:05,273 [ServletExec: request: time=1186058691835, uri=/Lighthammer/Illuminator] FATAL Connector - Unable to create connection pool for FLO_SampleManager: Fatal error while filling connection pool for jdbc:oracle:thin:@<REM>:<REM>:<REM>

2007-08-02 08:45:05,273 [ServletExec: request: time=1186058691835, uri=/Lighthammer/Illuminator] SYSTEM Connector - Create server FLO_SampleManager[serverClassName=com.lighthammer.Illuminator.connectors.IDBC.IDBC, enabled=true]

2007-08-02 08:45:28,601 [ServletExec: request: time=1186058728538, uri=/Lighthammer/Illuminator] SYSTEM SessionHandler - Session timeout set to 120 minutes

2007-08-02 08:45:35,117 [ServletExec: request: time=1186058731960, uri=/Lighthammer/Illuminator] ERROR ConnectionPool - Fatal error while filling connection pool for jdbc:oracle:thin:@<REM>:<REM>:<REM>

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:418)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)

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

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

at com.lighthammer.Illuminator.tools.database.ConnectionPool.createConnectionObject(Unknown Source)

at com.lighthammer.Illuminator.tools.database.ConnectionPool.fill(Unknown Source)

at com.lighthammer.Illuminator.tools.database.ConnectionPool.initialize(Unknown Source)

at com.lighthammer.Illuminator.tools.database.ConnectionPool.<init>(Unknown Source)

at com.lighthammer.Illuminator.tools.database.ConnectionHolder.addDBConnectionPool(Unknown Source)

at com.lighthammer.Illuminator.server.ServerObject.createHolder(Unknown Source)

at com.lighthammer.Illuminator.server.ServerObject.<init>(Unknown Source)

at com.lighthammer.Illuminator.server.ServerStore.addServer(Unknown Source)

at com.lighthammer.Illuminator.server.ServerStore.updateServer(Unknown Source)

at com.lighthammer.Illuminator.config.system.ServersProxy.update(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.lighthammer.Illuminator.services.admin.Add.processRequest(Unknown Source)

at com.lighthammer.Illuminator.services.handlers.Admin.process(Unknown Source)

at com.lighthammer.Illuminator.services.handlers.Admin.processRequest(Unknown Source)

at com.lighthammer.Illuminator.services.ServiceManager.runQuery(Unknown Source)

at com.lighthammer.Illuminator.servlet.Illuminator.service(Unknown Source)

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

at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)

at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)

at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)

at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96)

at com.lighthammer.Illuminator.security.IllumFilter.doFilter(Unknown Source)

at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60)

at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2140)

at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1804)

at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937)

at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)

at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973)

at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167)

at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204)

at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487)

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Aug 09, 2007 at 01:30 PM

    Paul,

    I hope you are well on your way with plans on updating your version, especially since 11.0 is no longer an officially supported product.

    Do you have a ValidationQuery in your data server settings?

    Regards,

    Jeremy Good

    Add comment
    10|10000 characters needed characters exceeded