Почему в такой конструкции возникает Connection closed?
Код:
public boolean isActive(String string, Contract contract, Date date)
throws BGException
{
logger.warn("...1");
ServerContext context = ServerContext.get();
TariffOptionService wsTariffOption = context.getService( TariffOptionService.class, 0 );
logger.warn("...2");
List<ContractTariffOption> currentOptionList = wsTariffOption.contractTariffOptionList(contract.getId(), date);
logger.warn("...3");
for (ContractTariffOption contractTariffOption : currentOptionList){
logger.warn("...4");
if (contractTariffOption.getOptionTitle().contains(string)) {
logger.warn("...5");
return true;
}
}
logger.warn("...6");
return false;
}
Код:
11-10/00:35:07 WARN [dyn-clss-evnt-lstnr-p-5-t-10] ContractEventListener - ...1
11-10/00:35:07 WARN [dyn-clss-evnt-lstnr-p-5-t-10] ContractEventListener - ...2
11-10/00:35:09 ERROR [dyn-clss-evnt-lstnr-p-5-t-10] ContractEventListener - java.sql.SQLException: Connection is closed.
ru.bitel.bgbilling.common.BGException: java.sql.SQLException: Connection is closed.
at ru.bitel.bgbilling.kernel.tariff.option.server.bean.ContractTariffOptionDao.list(ContractTariffOptionDao.java:91)
at ru.bitel.bgbilling.kernel.tariff.option.server.bean.ContractTariffOptionDao.list(ContractTariffOptionDao.java:33)
at ru.bitel.bgbilling.kernel.tariff.option.server.service.TariffOptionServiceImpl.contractTariffOptionList(TariffOptionServiceImpl.java:295)
at ru.gigacom.newstate.contract.eventlistener.payments.PaymentOptions.isActive(PaymentOptions.java:213)
at ru.gigacom.newstate.contract.eventlistener.payments.PaymentOptions.getCalculateMonth(PaymentOptions.java:197)
at ru.gigacom.newstate.contract.eventlistener.payments.PaymentOptions.checkOptionsPayment(PaymentOptions.java:65)
at ru.gigacom.newstate.contract.eventlistener.payments.PaymentIn.payment(PaymentIn.java:48)
at ru.gigacom.newstate.contract.eventlistener.ContractEventListener.onEvent(ContractEventListener.java:45)
at ru.bitel.bgbilling.kernel.script.server.DynamicScriptEventListener.runScriptImpl(DynamicScriptEventListener.java:196)
at ru.bitel.bgbilling.kernel.script.server.DynamicScriptEventListener$ThreadedScriptEventListener.access$101(DynamicScriptEventListener.java:204)
at ru.bitel.bgbilling.kernel.script.server.DynamicScriptEventListener$ThreadedScriptEventListener$1.call(DynamicScriptEventListener.java:254)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
Caused by: java.sql.SQLException: Connection is closed.
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.checkOpen(PoolGuardConnectionWrapper.java:39)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.prepareStatement(PoolGuardConnectionWrapper.java:200)
at ru.bitel.bgbilling.kernel.tariff.option.server.bean.ContractTariffOptionDao.list(ContractTariffOptionDao.java:70)
... 15 more
Код:
Информация о версии:
Клиент: вер. 7.0.836 / 15.09.2016 16:44:58
os: Windows 10; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91
Сервер: вер. 7.0.1107 / 15.09.2016 17:20:29
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
bill: вер. 7.0.93 / 15.09.2016 16:47:16
card: вер. 7.0.40 / 22.08.2016 16:40:03
dialup: вер. 7.0.319 / 29.08.2016 16:38:40
drweb: вер. 7.0.73 / 08.04.2016 17:40:40
inet: вер. 7.0.679 / 15.09.2016 16:46:50
ipn: вер. 7.0.258 / 01.09.2016 18:14:39
mps: вер. 7.0.199 / 13.09.2016 16:58:16
npay: вер. 7.0.198 / 19.07.2016 18:37:21
paymaster: вер. 7.0.58 / 15.09.2016 17:20:39
rentsoft: вер. 7.0.65 / 10.06.2016 17:00:01
reports: вер. 7.0.216 / 13.09.2016 16:58:32
rscm: вер. 7.0.180 / 10.06.2016 17:00:08
ru.bitel.bgbilling.plugins.bonus: вер. 7.0.122 / 15.09.2016 16:49:24
ru.bitel.bgbilling.plugins.crm: вер. 7.0.194 / 31.05.2016 15:00:38
ru.bitel.bgbilling.plugins.dispatch: вер. 7.0.85 / 13.09.2016 12:47:01
trayinfo: вер. 7.0.175 / 10.06.2016 17:00:23
tv: вер. 7.0.226 / 06.09.2016 17:38:49
Окружение:
Клиент:
os: Windows 10 amd64, 10.0
java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91
jre home: C:\Java\jdk1.8
default tz: 10.11.2016 00:39 GMT+03:00 +0300 (Etc/GMT-3)
user tz: 10.11.2016 00:39 MSK +0300 (Europe/Moscow)
locale: ru_RU
Сервер:
os: Linux amd64, 2.6.32-279.el6.x86_64
java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
jre home: /usr/java/jdk1.8.0_45/jre
default tz: 10.11.2016 00:41 GMT+03:00 +0300 (Etc/GMT-3)
db time: master: 10.11.2016 00:41 GMT-3
db charset: connection: cp1251(cp1251_general_ci), database: cp1251(cp1251_general_ci)
locale: ru_RU
uptime: Started: 10.11.2016 00:09:25 Uptime: 0 d 00:32:08