Hi Friends,
I am working with MySQL, InnoDB as a database. I will want to disable FOREIGN KEY checks. For that, I appended "?sessionVariables = FOREIGN_KEY_CHECKS = 0" to My Application's JDBC URL. i.e.,
URL= jdbc:mysql://MyHost/MyDB?sessionVariables = FOREIGN_KEY_CHECKS = 0
It is working fine before deployment. But after deployment it is not working( Foreign key checks are not disabled).
If foreign keys are enabled, then the problem is: child is inserting data before the parent table. So please get rid out of this.

Thanks for your reply,
Sreenivasulu.A.

Why can't you insert the record into the parent table first..?

Manually I can insert the data into parent table, but My java application uses a large database. Whenever user adds a record into the database, number of queries tried to hit the database. If foreign keys are not there, then my application inserts data correctly. Because my application maintains relations in it's own fashion. When foreign keys are there, that time problem came.

Hi Friends,
I am working with MySQL, InnoDB as a database. I will want to disable FOREIGN KEY checks through my jdbc application. For that, I appended "?sessionVariables = FOREIGN_KEY_CHECKS = 0" to My Application's JDBC URL. i.e.,
URL= jdbc:mysql://MyHost/MyDB?sessionVariables = FOREIGN_KEY_CHECKS = 0
It is working fine before deployment. But after deployment it is not working( Foreign key checks are not disabled).
If foreign keys are enabled, then the problem is: child is inserting data before the parent table. So please get rid out of this.

Thanks for your reply,
Sreenivasulu.A.

if you are implementing your own RI checks (seems madness in the current day and age,but each to their own) have ypu thought of using the MyISAM engine.

or, a wild thought

rewriting your app so it writes to parent tables first?

...even if it writes only the bare-minimum information (i.e. the primary key)

If it's not creating the parent records first then your application is NOT inserting data correctly. You should change your application.

Threads merged - please do not post the same question twice!