2 Replies Latest reply on Nov 6, 2007 7:27 AM by dlusignan

    Flex and Java

    dlusignan
      When java throw a DB exception, I can see the message on the lcds terminal, but how can I get this message in my flex app to show user a friendly message of what hapenning.

      By ex:

      When my user try to delete data that resulting in a ForeignKey constraint, I want to tell him that he can't do that without first deleting associated data to this one. But, lcds just delete the item in my arraycollection, let's the user think it's deleted but in the database, nothing get deleted, normal, and in the lcds terminal throw an exception coming from Java.

      From now I try these:

      DS = new DataService("DS");
      DS.addEventListener(DataServiceFaultEvent.FAULT, themeFault);
      DS.addEventListener(DataConflictEvent.CONFLICT, themeConflict);
      DS.addEventListener(MessageEvent.MESSAGE, themeMessage);

      But nothing is throw for:

      com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted
      with the FOREIGN KEY constraint "FK_tblCongres_tlkpCategorieTheme". The conflic
      t occurred in database "Congres", table "dbo.tlkpCategorieTheme", column 'ID'.
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError
      (Unknown Source)

      I want to catch this message and tell my user that he can't delete at this point.

      Somebody know what I'm talking about?