Thread: DataBase Problem

DataBase Problem

From
"Premila Devi"
Date:

I am having problem as :

 

Caused by: org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed

      at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:677)

      at org.springframework.transaction.support.AbstractPlatformTransactionManager.doRollbackOnCommitException(AbstractPlatformTransactionManager.java:850)

      at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:737)

      at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)

      at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)

      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

      at $Proxy57.generateReport(Unknown Source)

      ... 106 more

Caused by: org.hibernate.TransactionException: JDBC rollback failed

      at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:204)

      at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:674)

      ... 114 more

Caused by: java.sql.SQLException: Couldn't perform the operation rollback: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).

      at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)

      at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)

      at org.postgresql.PGConnection$$EnhancerByProxool$$4e6ef3b1.rollback(<generated>)

      at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:217)

      at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)

      ... 115 more

 

Pls guide me.Thanks you.

 

Re: DataBase Problem

From
Craig Ringer
Date:
On 30/12/2009 9:49 AM, Premila Devi wrote:

> Caused by: _java.sql.SQLException_: Couldn't perform the operation
> rollback: You can't perform any operations on this connection. It has
> been automatically closed by Proxool for some reason (see logs).

"see logs"

Look at your proxool logs and see why the connection was closed. The
error message its self gives you the next step.

I suggest reading this:
   http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
for some hints in case you need to ask a more detailed follow-up.

--
Craig Ringer

Re: DataBase Problem

From
Joshua Tolley
Date:
On Wed, Dec 30, 2009 at 09:49:52AM +0800, Premila Devi wrote:
>    I am having problem as :
>
>
>
>    Caused by: org.springframework.transaction.TransactionSystemException:
>    Could not roll back Hibernate transaction; nested exception is
>    org.hibernate.TransactionException: JDBC rollback failed
  ...snip...
>    Caused by: org.hibernate.TransactionException: JDBC rollback failed
  ...snip...
>    Caused by: java.sql.SQLException: Couldn't perform the operation rollback:
>    You can't perform any operations on this connection. It has been
>    automatically closed by Proxool for some reason (see logs).

Without some idea of why the connection was "automatically closed by Proxool"
there's likely little we can do to help. If PostgreSQL is to blame, there's
probably useful information about the problem in your PostgreSQL logs. The
logging documentation might be useful to you here.

http://www.postgresql.org/docs/current/static/runtime-config-logging.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

Attachment