Re: [h2] How to run a sql script with duplicate insert queries on h2db

2022-05-26 Thread 'Balamurali Krishna Ippili' via H2 Database
Hi Andreas, Thanks for your quick response. Your suggestion is awesome. Really appreciate it. However I have just found a specific method and param provided in H2DB to resolve my issue. There is a RunScript.execute method provided with an option to continue execution even if there is an error.

Re: [h2] How to run a sql script with duplicate insert queries on h2db

2022-05-26 Thread Andreas Reichel
On Wed, 2022-05-25 at 22:25 -0700, 'Balamurali Krishna Ippili' via H2 Database wrote: > Hi Team, > > We have a requirement where we are executing an sql script on h2 db > and there is a primary key constraint on the table and if there is > any single failure in the script is stop executing the

[h2] How to run a sql script with duplicate insert queries on h2db

2022-05-25 Thread 'Balamurali Krishna Ippili' via H2 Database
Hi Team, We have a requirement where we are executing an sql script on h2 db and there is a primary key constraint on the table and if there is any single failure in the script is stop executing the rest of the script. How can we allow the java program to ignore the failed query and continue