6 Replies Latest reply on Mar 3, 2004 7:24 AM by dreyk



      I am use JBoss 3.2.3+Oracle9i or MS SQLSERVER 2000.
      When i try create to table(Table1 and Table2) and create Relationship beetwin them (one2many) whis cascade deleting, JBoss succesfull create tables and Relationship but it does not create cascade deleting flag in database and cascade deleting does not work.
      Can you help me?

        • 1. Re: CASCADE DELETE

          JBossCMP handles cascade delete itself (w/o cascade delete settings in the db). How do you configure it that is does not work?

          • 2. Re: CASCADE DELETE

            Yes. It's work when i set <fk-constraint> to false. But can i do it this <fk-containt> to true value?For example I have Other Aplication(that execute not under Jboss) that work this data base, and I whant remove any row from whis table whis cade delete from child table?

            • 3. Re: CASCADE DELETE

              Ok.I'm understand. If I whant to use Jboss for casdade delte I must set "fk-constraint" option to false and set <cascade-delete> flag im my ejb-jar file.If i whant that Database do cascade delete i must don't set <cascade-delete> in my ejb-jar file, but create in database fk-coinstraint, whis cascade-delete option.

              • 4. Re: CASCADE DELETE

                JBoss will not create any cascade-delete flag in the database. It is not a bug. How do you configure cascade-delete? Show the code which does not work.

                • 5. Re: CASCADE DELETE

                  Sorry, I didn't read your last post.
                  In general, I would not recommend you configuring cascade-delete in the database due to caching issues.

                  • 6. Re: CASCADE DELETE

                    Thanks Loubyansky for u help.Sorry for my English:)