pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jags <jrao@econify.com>
To: pgsql-admin@postgresql.org
Subject: problems after upgrading to 7.4.5
Date: Fri, 13 May 2005 20:15:48 +0530
Message-ID: <4284BD9C.6030406@econify.com> (raw)

hi all experts

please help me 
here's the story...
i an working on a Java based Web Application
which is made up of
Jsp's -tomcat jsp server(3.1.1)
EJB's-Jonas EJBServer (2.4.4)
RDBMS-postgres (7.3.4)
JDK Platform is 1.4.2

the application was working fine with this config since 2 years 

then some while ago this app was upgraded to postgres v7.4.5 after which the problem started

Problem 1)     first when i started the jonas server i got an error saying
                    SET AUTOCOMMIT OFF is no longer supported.
Resolution 1): i downloaded pgjdbc2.jar and restarted the JOnas server
                    things looked to work  fine

Problem 2): when i tested the application it was running fine.i was able to add products to
                  the shopping cart and all the things
                  but when i restart the jonas server after some code changes
                  i started getting error in the cart such as
ERR#          EnqCartBean:viewEnqcart:fetchin enqMasterjava.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
                   javax.transaction.TransactionRolledbackException: System exception in business method

                  the transaction got rolled back and all products in the cart were lost.
                  i tried by again adding the parts and the application started giving more and more errors

ERR#         CartDetailClient:Cannot create Cart detail: javax.transaction.NotSupportedException: Nested transactions not supported
ERR#          javax.transaction.TransactionRolledbackException: cannot register EntityContext
ERR#          EnqCartBean:addToEnqCartjavax.ejb.DuplicateKeyException: E0000053(even if 53 is not there)

Tries 1  : i tried by changing the newly available jdbc drivers from posgres.org
               1)pg74.216.jdbc2ee.jar
               2)pg74.216.jdbc3.jar and also others
             with these jars there was a strange issue i was able to connect and login to app but the product list
             and all the reporst were  not showing any records(this attempt also failed)
Tries 2 :  i learnt from the postgres site that SET AUTOCOMMIT OFF is not supported in 7.4
            so this might be a problem.so i set that option at postgres console by command SET "AUTOCOMMIT OFF"
            after this also problem is not solved

i am clue less about where actually the problem is it the driver i am using or there is a need to change the EJB code or
deployment descriptors.i'm new to EJB and also the code is quite old

pls help me.i have given it a real hard fight but no gains.basically where shud i attack

please mail me at

aquajags@yahoo.com
jrao@econify.com

regards
jags






Message-ID: <4284BD9C.6030406@econify.com>
Permalink:  ../4284BD9C.6030406@econify.com/
Also on:    postgresql.org/message-id/4284BD9C.6030406@econify.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jrao@econify.com
  Subject: Re: problems after upgrading to 7.4.5
  In-Reply-To: <4284BD9C.6030406@econify.com>
  References: <4284BD9C.6030406@econify.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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