Re: Reg: 25P02, current transaction is aborted, commands ignored until end of transaction block - Mailing list pgsql-bugs

hi i am useing PostgreSQL 8.2 i got this error on console  if any Solution
Please try to contact me or send me any Solution fro that
ajaylabdae@gmail.com

2009-09-30 12:34:56,281
[org.springframework.orm.hibernate3.HibernateTemplate] DEBUG - Not closing
pre-bound Hibernate Session after HibernateTemplate
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation:
could not execute query; uncategorized SQLException for SQL [select
this_.handicap_code as handicap1_161_0_, this_.handicap_desc as
handicap2_161_0_ from est_m_handicap this_ order by this_.handicap_code
asc]; SQL state [25P02]; error code [0]; ERROR: current transaction is
aborted, commands ignored until end of transaction block; nested exception
is org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
commands ignored until end of transaction block
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block
    at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
    at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    at org.hibernate.loader.Loader.doQuery(Loader.java:674)
    at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    at org.hibernate.loader.Loader.doList(Loader.java:2220)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    at org.hibernate.loader.Loader.list(Loader.java:2099)
    at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
    at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
    at
com.nic.mcc.est.transaction.AbstractSpringDao$3.doInHibernate(AbstractSpringDao.java:181)
    at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:369)
    at
com.nic.mcc.est.transaction.AbstractSpringDao.getOrderByArrayList(AbstractSpringDao.java:175)
    at com.nic.mcc.est.dao.HandicapDao.getOrderByList(HandicapDao.java:148)
    at
com.nic.mcc.est.controllers.master.employee.CreateController.formBackingObject(CreateController.java:178)
    at
org.springframework.web.servlet.mvc.AbstractFormController.getErrorsForNewForm(AbstractFormController.java:343)
    at
org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:323)
    at
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:263)
    at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
    at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
    at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:839)
    at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:774)
    at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:460)
    at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:415)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
    at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
    at java.lang.Thread.run(Thread.java:595)


ajay labade wrote:
>
>
>
> bhavani gade wrote:
>>
>> Dear all,
>>
>>     I am trying to port my application from Oracle to PostGREs. I have a
>> problem while doing so. In my application i need to update record if the
>> delete on the respective record is failed due to Constraint Violation.
>> But SQL Error: 0, SQLState: 25P02 ERROR [JDBCExceptionReporter] ERROR:
>> current transaction is aborted, commands ignored until end of transaction
>> block is being generated while updating the record. But with Oracle i am
>> able to do this.
>>
>> I have tried with latest Jar [postgresql-8.3-604.jdbc3.jar] too, but
>> problem still exists.
>>
>> Here is the code that i worked on:
>>
>> try{
>>     session = sessionManager.getSession();
>>     transaction = session.beginTransaction();
>>     session.delete(objects[i]);
>>     session.flush();
>> }catch(ConstraintViolationException e){
>>     objects[i].setDeleted(Integer.valueOf(1));
>>     session.saveOrUpdate(object[i]);
>>     session.flush();
>> }
>> transaction.commit();
>> sessionManager.closeSession(session);
>>
>> I am using platform java 1.5, jBoss 4.2.3, Hibernate v3.3, PostGREs v8.3
>> and OS Windows me.
>>
>> Thanks in advance,
>> Bhavani.G
>>
>
>

--
View this message in context:
http://www.nabble.com/Reg%3A-25P02%2C-current-transaction-is-aborted%2C-commands-ignored-until-end-of-transaction-block-tp22986191p25677724.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.