Проблема с подключением к базе данных Oracle

200
12 июля 2017, 23:24

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

Пул соединений использую c3p0, Oracle 12.0.1, в папке apache-tomcat/lib лежит ojdbc7.jar

Настройки с3p0:

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<Context>
<Resource name="jdbc/REP"
             auth="Container"
          type="com.mchange.v2.c3p0.ComboPooledDataSource"
                      user="*****"
          password="******"
          driverClass="oracle.jdbc.driver.OracleDriver"
          jdbcUrl="jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=off)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=rep-db01.***.ru)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=rep-db02.****.ru)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=service_rep)))"
          factory="org.apache.naming.factory.BeanFactory"
                      minPoolSize="15"
                      maxPoolSize="100"
                      acquireIncrement="10"
                      testConnectionOnCheckin="true"
                      testConnectionOnCheckout="true"
                      idleConnectionTestPeriod="30"
                      preferredTestQuery="select 1 from dual"
                      maxIdleTimeExcessConnections="240"
                      unreturnedConnectionTimeout="10000"
                      debugUnreturnedConnectionStackTraces="true"
                      acquireRetryAttempts="0"
                      initialPoolSize="20"
                      dataSourceName="java:/comp/env/jdbc/REP"
                      />
</Context>

В логах вижу следующее:

2017-07-12 11:25:23,217 DEBUG [] An exception occurred while acquiring a poolable resource. Will retry.
java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:497)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:460)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:594)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:183)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:172)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:188)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1074)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1061)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1798)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:636)
2017-07-12 11:25:23,249 DEBUG [] Continuing acquisition series. pending_acquires [20],  attempts_remaining: 9
2017-07-12 11:25:23,249 DEBUG [] com.mchange.v2.async.ThreadPoolAsynchronousRunner@3b3f4e1e: Adding task to queue -- com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@769e5eb6
2017-07-12 11:25:23,370 DEBUG [] Continuing acquisition series. pending_acquires [20],  attempts_remaining: 9
2017-07-12 11:25:23,370 DEBUG [] com.mchange.v2.async.ThreadPoolAsynchronousRunner@3b3f4e1e: Adding task to queue -- com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@175c3b91
2017-07-12 11:25:23,373 DEBUG [] An exception occurred while acquiring a poolable resource. Will retry.
java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:497)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:460)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:594)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:183)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:172)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:188)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1074)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1061)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1798)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:636)
READ ALSO
Java при заполнение listview nullpointer

Java при заполнение listview nullpointer

В строчке listView1setItems(data); вылетает NPE

190
Запуск Activity из метода

Запуск Activity из метода

Есть метод в MainActivity:

208
Удалить тег из html

Удалить тег из html

Есть блок с текстом, в котором в некоторых местах есть brПри меньшей ширине окна текст принимает непрезентабельный вид и не выравнивается...

280
Нужно ли здесь использовать float?

Нужно ли здесь использовать float?

Посоветуйте, как правильно сверстать такой сайт, приведённый на рисунке? Интересует вопрос, нужно ли применять здесь float для блоков в шапке...

247