Sql error 17008

Ошибка SQL загрузки Sprint: 17008, SQLState: 08003 При запуске веб-приложения Java / Spring я получаю сообщение об ошибке ниже. Я использовал SqlDeveloper для подключения к базе данных Oracle, и, похоже, он работает нормально. Как вы думаете, в чем может быть проблема? 2018-05-28T16:26:03,863 [RMI TCP Connection(2)-127.0.0.1] INFO org.hibernate.validator.internal.util.Version 30 — HV000001: Hibernate Validator 5.3.4.Final 2018-05-28T16:26:04,843 […]

Содержание

  1. Ошибка SQL загрузки Sprint: 17008, SQLState: 08003
  2. SQL Error: 17008, SQLState: null
  3. java.sql.SQLRecoverableException: закрытое соединение; Состояние=08003; Код ошибки = 17008
  4. 4 ответа
  5. SQLState: 08003 Problems #1036
  6. Comments
  7. Environment

Ошибка SQL загрузки Sprint: 17008, SQLState: 08003

При запуске веб-приложения Java / Spring я получаю сообщение об ошибке ниже. Я использовал SqlDeveloper для подключения к базе данных Oracle, и, похоже, он работает нормально. Как вы думаете, в чем может быть проблема?

2018-05-28T16:26:03,863 [RMI TCP Connection(2)-127.0.0.1] INFO org.hibernate.validator.internal.util.Version 30 — HV000001: Hibernate Validator 5.3.4.Final

2018-05-28T16:26:04,843 [RMI TCP Connection(2)-127.0.0.1] INFO org.hibernate.tuple.PojoInstantiator 66- HHH000182: No default (no-argument) constructor for class: CustomKitCart (class must be instantiated by Interceptor)

2018-05-28T16:26:05,353 [RMI TCP Connection(2)-127.0.0.1] INFO org.hibernate.tool.hbm2ddl.SchemaValidator 69 — HHH000229: Running schema validator

2018-05-28T16:29:08,070 [RMI TCP Connection(2)-127.0.0.1] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper 127 — SQL Error:17008, SQLState: 08003

2018-05-28T16:29:08,070 [RMI TCP Connection(2)-127.0.0.1] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper 129 — 关闭的连接: next

2018-05-28T16:29:08,084 [RMI TCP Connection(2)-127.0.0.1] WARN org.springframework.web.context.support.XmlWebApplicationContext 544 — Exception encountered during context initialization — cancelling refresh attempt

Кажется, у вашего класса CustomKitCart нет конструктора по умолчанию. Проверьте трассировку стека.

Добавьте для этого класса конструктор без аргументов по умолчанию и посмотрите, решит ли он проблему.

@IndraneelBende Я добавил конструктор по умолчанию. Это не сработало.

Вы узнали, что означает приведенный выше код ошибки?

Источник

SQL Error: 17008, SQLState: null

We are facing some connectivity problems in our production systems.

Oracle RAC
Oracle Version : 10.2.0.4
OS : Solaris 10

Application team uses JDBC connectivity to connect to database and using java hibernate code for testing.

The connectivity works perfect for some hours and suddenly there arises an error.

The error is as follows.

WARNING: SQL Error: 17008, SQLState: null
Dec 16, 2010 4:35:10 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Closed Connection
Dec 16, 2010 4:35:10 AM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 17008, SQLState: null
Dec 16, 2010 4:35:10 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Closed Connection
org.hibernate.exception.GenericJDBCException: could not execute query
at com.sa.loungefinder.datalayer.ManageUsersLogic.getLoginDetails(ManageUsersLogic.java:75)
at com.sa.loungefinder.helper.user.ManageUserDelegate.getLoginDetails(ManageUserDelegate.java:46)
at com.sa.loungefinder.action.LoginAction.execute(LoginAction.java:100)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:249)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:870)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)

Kindy provide us some suggestions to eradicate the above error.

Источник

java.sql.SQLRecoverableException: закрытое соединение; Состояние=08003; Код ошибки = 17008

Я получаю следующую ошибку при вставке некоторых строк в таблицу базы данных оракула с использованием циклов java, мой цикл будет выполняться почти 25000 раз:

4 ответа

Код приложения не должен передавать кэшированный дескриптор соединения от одного экземпляра клиента доступа к данным другому экземпляру клиента. Передача дескриптора соединения между экземплярами клиента создает проблемную ситуацию, когда один экземпляр использует дескриптор соединения, на который ссылается другой. Например, когда код приложения экземпляра клиента, который получает переданный дескриптор, закрывает дескриптор, а экземпляр клиента, сохраняющий исходную ссылку на дескриптор, пытается восстановить его, сервер приложений выдает исключение. показаны некоторые исключения, ожидаемые в этом случае. Описание исключения: при очистке ManagedConnection для операции уничтожения обнаружено исключение. Обратитесь к ошибке, о которой сообщает программное обеспечение базы данных, чтобы определить причину ошибки. Исключение

Прочтите это, чтобы узнать больше

Возможно, код тратит слишком много времени между открытием соединения с базой данных и подготовкой PreparedStatement или между другими операциями с базой данных и подготовкой следующего PreparedStatement , так что соединение закрывается из-за бездействия.

Соединение может быть закрыто Oracle или C3P0, поэтому проверьте настройки тайм-аута в конфигурации C3P0. Также рассмотрите возможность подключения позже в ходе выполнения.

Возможно, вы столкнулись с ошибкой в ​​C3P0, связанной с соединениями Oracle.

Возможно, у вас есть временная сетевая ошибка при подключении к экземпляру базы данных (предполагается, что база данных находится на другом компьютере; этого не произойдет, если база данных находится на том же компьютере).

Чтобы избежать остановки выполнения из-за этой проблемы, вы должны поймать такие RecoverableException , получить новое соединение из пула соединений, а затем повторить операцию с базой данных.

Источник

SQLState: 08003 Problems #1036

I am getting many errors a day and not sure how I can deal with them:
2017-12-01 08:19:28.464 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:28.464 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:29.333 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:29.333 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:29.584 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 08:19:29.584 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 08:19:29.594 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:29.594 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:33.013 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:33.013 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:39.068 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:39.068 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:39.294 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:39.294 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:39.420 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:39.420 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:44.886 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:44.886 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:44.905 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:44.905 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:19:45.589 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:19:45.589 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:20:05.085 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:20:05.085 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 08:20:06.351 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 08:20:06.351 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:14.745 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:14.745 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:14.775 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:14.775 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:16.921 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:16.921 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:18.059 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:18.059 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:19.656 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:19.656 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:24.349 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 10:16:24.349 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 10:16:24.389 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:24.389 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:30.373 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 10:16:30.373 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 10:16:30.416 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:30.416 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:32.000 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:32.000 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:34.413 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:34.413 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:34.874 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:34.874 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:35.759 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:35.760 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:35.782 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:35.782 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:36.751 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:36.751 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:37.742 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:37.742 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:41.078 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 10:16:41.078 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 10:16:43.638 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 10:16:43.638 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 10:16:45.104 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:45.104 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:16:49.412 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:16:49.412 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:37:43.835 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:37:43.835 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:37:43.880 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:37:43.880 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:37:44.068 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:37:44.068 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:37:44.078 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:37:44.078 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 10:37:49.806 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 10:37:49.806 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 10:37:49.863 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 10:37:49.863 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:00:41.727 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:00:41.727 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:00:41.830 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:00:41.830 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:00:42.190 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:00:42.190 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:00:44.126 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 12:00:44.126 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 12:00:44.162 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:00:44.162 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:00:47.345 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:00:47.345 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:00:47.372 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:00:47.372 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:00:47.472 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:00:47.472 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:00:47.503 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:00:47.503 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:17.557 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:17.557 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:17.605 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:17.605 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:17.651 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:17.651 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:17.732 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:17.732 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:17.771 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:17.772 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:24.116 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 12:34:24.116 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 12:34:24.147 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:24.147 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:24.203 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:24.203 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:25.369 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:25.369 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:28.322 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 12:34:28.322 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 12:34:28.353 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:28.353 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:28.408 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:28.408 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:34:50.511 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:34:50.512 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:35:19.079 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:35:19.079 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:35:42.350 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:35:42.350 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after statement closed.
2017-12-01 12:35:42.425 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:35:42.425 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:35:43.127 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 12:35:43.127 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 12:35:43.169 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:35:43.169 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:35:43.189 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:35:43.189 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:35:46.165 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:35:46.165 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:25.468 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 12:51:25.468 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 12:51:25.481 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:25.481 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:25.534 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:25.534 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:25.607 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:25.607 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:25.653 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:25.653 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:25.715 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:25.715 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:25.774 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:25.774 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:27.338 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:27.338 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:40.489 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 12:51:40.489 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 12:51:42.642 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:42.642 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 12:51:49.954 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 12:51:49.954 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:01.920 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:01.920 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.215 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.215 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.325 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.326 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.456 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.456 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.460 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.460 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.510 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.510 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.511 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.511 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.535 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.535 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.584 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.585 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.585 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.585 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.612 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.612 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.625 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.625 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:02.637 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:02.637 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:07.843 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:07.843 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:25.684 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:25.684 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:25.809 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:25.809 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:25.903 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:25.903 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:25.925 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:25.925 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:25.933 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:25.933 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:26.021 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:26.021 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:26.140 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:26.140 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:26.237 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:26.238 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:26.396 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:26.396 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:26.451 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:26.451 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:26.506 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:26.506 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:26.507 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:26.507 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:26.622 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:26.622 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:27.103 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:27.103 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:41.319 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:41.319 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:41.348 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:41.348 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 13:20:41.694 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 13:20:41.694 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:23:31.715 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:23:31.715 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:23:42.868 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:23:42.868 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:23:42.884 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:23:42.884 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:23:42.932 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:23:42.932 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:23:42.956 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:23:42.956 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:23:43.000 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:23:43.000 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:24:12.044 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:24:12.044 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:24:12.074 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:24:12.074 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:24:12.842 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 19:24:12.842 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 19:24:12.884 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:24:12.884 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 19:24:12.905 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 19:24:12.905 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:02.536 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 22:38:02.536 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 22:38:02.576 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:02.576 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:05.572 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:05.572 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:23.871 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:23.871 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:23.915 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:23.915 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:40.030 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:40.030 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after statement closed.
2017-12-01 22:38:40.096 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:40.096 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:40.242 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:40.242 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:40.259 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:40.259 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:41.544 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:41.544 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:42.005 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08S01
2017-12-01 22:38:42.005 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — Communications link failure
2017-12-01 22:38:42.015 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:42.016 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:42.034 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:42.034 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:42.054 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:42.054 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:44.859 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:44.859 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:44.903 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:44.903 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.
2017-12-01 22:38:47.198 WARN o.h.e.jdbc.spi.SqlExceptionHelper — SQL Error: 0, SQLState: 08003
2017-12-01 22:38:47.198 ERROR o.h.e.jdbc.spi.SqlExceptionHelper — No operations allowed after connection closed.

Environment

Have you searched the CLOSED issues already? How about checking stackoverflow?

The text was updated successfully, but these errors were encountered:

Источник

Источник

Problem

During installation verification testing (IVT) of IBM® InfoSphere® Master Data Management (InfoSphere® MDM), a ‘Resource manager unavailable’ error can sometimes occur. This issue occurs when containerized InfoSphere MDM is deployed on Docker or Red Hat® OpenShift® environments with Oracle Database. 

Symptom

The following is an example of the ‘Resource manager unavailable’ error that can occur as part of this issue:

[6/24/20 7:57:11:488 UTC] 00000157 EmbeddableTra I   WTRN0041I: Transaction 00000172E552D88A0000000115200494443873BE8709685AA43D3ED6C2AFF879F9EA3D4900000172E552D88A0000000115200494443873BE8709685AA43D3ED6C2AFF879F9EA3D4900000001 has been rolled back.
[6/24/20 7:57:11:490 UTC] 00000157 WSRdbXaResour E   DSRA0304E:  XAException occurred. XAException contents and details are:
The XA Error is            : -7
The XA Error message is    : Resource manager is unavailable.
The Oracle Error code is   : 17008
The Oracle Error message is: Internal XA Error
The cause is               : java.sql.SQLRecoverableException: Closed Connection.
[6/24/20 7:57:11:490 UTC] 00000157 WSRdbXaResour E   DSRA0302E:  XAException occurred.  Error code is: XAER_RMFAIL (-7).  Exception is: XAErr (-7): Resource manager is unavailable. ORA-17008 SQLErr (0)
[6/24/20 7:57:11:491 UTC] 00000157 XATransaction E   J2CA0027E: An exception occurred while invoking end on an XA Resource Adapter from DataSource jdbc/DWLCustomer, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54),
data(00000172e552d88a0000000115200494443873be8709685aa43d3ed6c2aff879f9ea3d4900000172e552d88a0000000115200494443873be8709685aa43d3ed6c2aff879f9ea3d49000000010000000000000000000000000001)} : oracle.jdbc.xa.OracleXAException: XAErr (-7): Resource manager is unavailable. ORA-17008 SQLErr (0)
 at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1112)

Environment

This issue occurs when containerized InfoSphere® MDM is deployed on Docker or Red Hat® OpenShift® environments with Oracle Database. 

Resolving The Problem

To resolve this issue, complete the following steps:

  1. Log in to the IBM® WebSphere Application Server Integrated Solutions console (admin console).
    https://<IP or URL of machine>:<port>/ibm/console/secure/securelogon.do
  2. Navigate to Resources  > Data Sources > DWLConfig > Additional Properties > Connection pool properties > General Properties > Minimum Connections and change the value of Minimum connections to 0. Click OK.
    image 6218
  3. Navigate to Resources  > Data Sources > DWLCustomer > Additional Properties > Connection pool properties > General Properties > Minimum Connections and change the value of Minimum connections to 0. Click OK.
  4. Save the configuration.

Document Location

Worldwide

[{«Line of Business»:{«code»:»LOB10″,»label»:»Data and AI»},»Business Unit»:{«code»:»BU059″,»label»:»IBM Software w/o TPS»},»Product»:{«code»:»SSWSR9″,»label»:»IBM InfoSphere Master Data Management»},»ARM Category»:[],»Platform»:[{«code»:»PF025″,»label»:»Platform Independent»}],»Version»:»11.6.0″}]

Источник

Hello Hibernate Users,

I’m currently working on a web application running on the Spring Tomcat server with an Oracle 10g Database backend. We use the app server to handle the data source connection pooling.

When the web application initially starts up, the connection to the database is great.. but after some heavy usage on the application I start seeing the following message in myapplication logs:

Quote:

2011-07-30 11:28:16.884 PDT TRACE online.tng.trustonline.sitemessages.SiteMessageServiceImpl — Begin getSiteMessage( destination[ASSET_SUMMARY])
2011-07-30 11:28:16.886 PDT WARN org.hibernate.util.JDBCExceptionReporter — SQL Error: 17008, SQLState: 08003
2011-07-30 11:28:16.886 PDT ERROR org.hibernate.util.JDBCExceptionReporter — Closed Connection
2011-07-30 11:28:16.887 PDT ERROR wellsfargo.online.framework.exception.RepositoryException — errorCode[2012], message[Exception while trying to getSiteDestination for destination[ASSET_SUMMARY], getSiteDestinationQuery[from SiteDestination as siteDestination where siteDestination.siteDestinationCode = ? or siteDestination.siteDestinationCode = ? or siteDestination.siteDestinationCode = ? or siteDestination.siteDestinationCode = ? or siteDestination.siteDestinationCode = ? or siteDestination.siteDestinationCode = ?], exceptionMessage[could not execute query]]

I tried googling these errors, but was unable to find a solution to the problem :(
SQL Error: 17008, SQLState: 08003 — means connection closed

Here’s my hibernate properties:

Code:

      <property name=»hibernateProperties»>
         <value>
            hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
            hibernate.current_session_context_class=thread
            hibernate.id.new_generator_mappings=true
            hibernate.connection.release_mode=after_transaction
         </value>
      </property>

And my Spring Tomcat resource configuration:

Code:

        <Resource name=»jdbc/tng» auth=»Container»
        scope=»Shareable»
        type=»oracle.jdbc.pool.OracleDataSource»
        driverClassName=»oracle.jdbc.driver.OracleDriver»
        factory=»oracle.jdbc.pool.OracleDataSourceFactory»
        connectionCachingEnabled=»true»
        connectionCacheName=»TNGConnectionCache»
        connectionCacheProperties=»{
                MaxLimit=${dbMaxLimit},
                MinLimit=${dbMinLimit},
                InitialLimit=${dbInitialLimit},
                InactivityTimeout=60,
                AbandonedConnectionTimeout=60,
                validateConnection=true}»
        url=»jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ${dbHost1})(PORT = ${dbPort1}))) (CONNECT_DATA = (SERVICE_NAME = ${dbSID})))»
        user=»${dbUser}»
        password=»${dbPasswordEncrypted}»
        testOnBorrow=»true»
        testOnReturn=»false»
        validationInterval=»30000″
        validationQuery=»select 1 from dual»/>

Источник

Понравилась статья? Поделить с друзьями:
  • Sql error 17003
  • Sql error 4060
  • Sql error 17002 sqlstate 08006
  • Sql error 40000 42000 error while compiling statement failed nullpointerexception null
  • Sql error 16000