1 Reply Latest reply on Jul 19, 2008 1:15 AM by Eric H

    AJAX updates hang during DB query?

    Eric H Novice

      This may not be enough information to answer, but here goes:

      My pages use the full power of EJB in their rendering.  I often have things like:

      City: <h:outputText value="#{project.customer.address.city}/>

      which of course probably has to go across four tables to get what it needs.  And I'll display a bunch of data on one page, so there might be quite a few such queries.

      It seems like EJB3 handles all this very well.  It doesn't attempt to do joins which the DB can't accomplish.  But sometimes when I do an AJAX update of a value, it repeats some of these complex queries, and somehow the AJAX update never seems to complete.  I end up putting the AJAX update onto a separate page that doesn't have to display all the other data, and then it works.

      I'm not even sure how to begin isolating the problem here.  Any suggestions on where to begin?