pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDataBase Problem
3+ messages / 3 participants
[nested] [flat]
* DataBase Problem
@ 2009-12-30 01:49 Premila Devi <premiladevi.dayalan@agbnielsen.com>
2009-12-30 01:54 ` Re: DataBase Problem Craig Ringer <craig@postnewspapers.com.au>
2009-12-30 11:42 ` Re: DataBase Problem Joshua Tolley <eggyknap@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Premila Devi @ 2009-12-30 01:49 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: pgsql-sql
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(Hi
bernateTransactionManager.java:677)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.d
oRollbackOnCommitException(AbstractPlatformTransactionManager.java:850)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.p
rocessCommit(AbstractPlatformTransactionManager.java:737)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.c
ommit(AbstractPlatformTransactionManager.java:678)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitT
ransactionAfterReturning(TransactionAspectSupport.java:321)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tr
ansactionInterceptor.java:116)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro
xy.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(Hi
bernateTransactionManager.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:2
07)
at
org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.jav
a:87)
at
org.postgresql.PGConnection$$EnhancerByProxool$$4e6ef3b1.rollback(<generated
>)
at
org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTra
nsaction.java:217)
at
org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)
... 115 more
Pls guide me.Thanks you.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: DataBase Problem
2009-12-30 01:49 DataBase Problem Premila Devi <premiladevi.dayalan@agbnielsen.com>
@ 2009-12-30 01:54 ` Craig Ringer <craig@postnewspapers.com.au>
1 sibling, 0 replies; 3+ messages in thread
From: Craig Ringer @ 2009-12-30 01:54 UTC (permalink / raw)
To: Premila Devi <premiladevi.dayalan@agbnielsen.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: DataBase Problem
2009-12-30 01:49 DataBase Problem Premila Devi <premiladevi.dayalan@agbnielsen.com>
@ 2009-12-30 11:42 ` Joshua Tolley <eggyknap@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Joshua Tolley @ 2009-12-30 11:42 UTC (permalink / raw)
To: Premila Devi <premiladevi.dayalan@agbnielsen.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql
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
Attachments:
signature.asc (application/pgp-signature, 196B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-12-30 11:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-12-30 01:49 DataBase Problem Premila Devi <premiladevi.dayalan@agbnielsen.com>
2009-12-30 01:54 ` Craig Ringer <craig@postnewspapers.com.au>
2009-12-30 11:42 ` Joshua Tolley <eggyknap@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox