-
1. Re: can unindexed foreign key in oracle 11g can cause a deadlock in jboss AS 7
jaikiran Jul 9, 2013 1:43 AM (in response to hohokampeople)What kind of deadlock and why do you suspect an unindexed database key to be the reason behind it?
-
2. Re: can unindexed foreign key in oracle 11g can cause a deadlock in jboss AS 7
hohokampeople Jul 9, 2013 1:51 AM (in response to jaikiran)Hi,
Sorry, it was database deadlock because the table where the deadlock occured it has an unindexed foreign key.
-
3. Re: can unindexed foreign key in oracle 11g can cause a deadlock in jboss AS 7
jaikiran Jul 9, 2013 2:00 AM (in response to hohokampeople)That actually isn't enough information to understand what the problem is. You'll have to narrow it down to what's exactly going on and whether JBoss server is even involved in whatever issue you are running into. For example, why is that unindexed foreign key causing a deadlock?
-
4. Re: can unindexed foreign key in oracle 11g can cause a deadlock in jboss AS 7
hohokampeople Jul 9, 2013 2:21 AM (in response to jaikiran)Hi
Currently, we are migrating to jboss AS 7 and whenever we run jboss to our prodcution environment, we're consistently getting a database deadlock (oracle 11g). However, this is not happening in our old server (SUN App server). So, this is the reason why we assume that JBOSS has something do to.
Regards,
Bruno
-
5. Re: can unindexed foreign key in oracle 11g can cause a deadlock in jboss AS 7
jaikiran Jul 9, 2013 2:23 AM (in response to hohokampeople)Please continue the discussion in your other thread here https://community.jboss.org/message/827001#827001.