Cannot open connection while insert much data.

Поиск
Список
Период
Сортировка
От BozhkoKA
Тема Cannot open connection while insert much data.
Дата
Msg-id 1301554595679-4272825.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Cannot open connection while insert much data.  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
My application is using JBOSS 5.1.0.GA, hibernate for connection to
PostgreSQL 9.0 database. Application inserts into database rows regularly.
But when it attempts insert row with 11Mb (11511828 bytes) size body (into
text-datatype column), the following error appiared:

19:02:54,989 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
19:02:54,989 ERROR [JDBCExceptionReporter] Transaction is not active:
tx=TransactionImple < ac, BasicAction: -3f57a87f:ed11:4d933f5e:99 status:
ActionStatus.
ABORTED >; - nested throwable: (javax.resource.ResourceException:
Transaction is not active: tx=TransactionImple < ac, BasicAction:
-3f57a87f:ed11:4d933f5e:9
9 status: ActionStatus.ABORTED >)
19:02:55,142 ERROR [TxPolicy] javax.ejb.EJBTransactionRolledbackException:
Cannot open connection
19:02:55,142 ERROR [ServiceBean]
javax.ejb.EJBTransactionRolledbackException: Cannot open connection
19:02:55,223 INFO  [DBFacade] *** EntityManager.getFlushMode() = AUTO
19:02:55,225 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
19:02:55,225 ERROR [JDBCExceptionReporter] Transaction is not active:
tx=TransactionImple < ac, BasicAction: -3f57a87f:ed11:4d933f5e:99 status:
ActionStatus.
ABORTED >; - nested throwable: (javax.resource.ResourceException:
Transaction is not active: tx=TransactionImple < ac, BasicAction:
-3f57a87f:ed11:4d933f5e:9
9 status: ActionStatus.ABORTED >)
19:02:55,226 INFO  [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.GenericJDBCException: Cannot open connection
        at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
        at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
        at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
        at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
        at
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
        at org.hibernate.loader.Loader.doQuery(Loader.java:696)
        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1881)
.............

Database some parameters are:

effective_cache_size = 512MB
work_mem = 64MB
shared_buffers = 256MB
max_prepared_transactions = 200


Can anybody help me?

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Cannot-open-connection-while-insert-much-data-tp4272825p4272825.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: JDBC gripe list (the autocommit subthread)
Следующее
От: Quartz
Дата:
Сообщение: Re: JDBC gripe list (the autocommit subthread)