Power Global

 View Only
Expand all | Collapse all

1 jdbc update query takes 10 minutes

  • 1.  1 jdbc update query takes 10 minutes

    Posted Sun August 09, 2020 07:29 AM

    I am using com.ibm.as400 dependency, 6.7 version in Spring Boot project and this update query takes between 5-10 minutes, what can cause this ?

    UPDATE myTable SET hashValue='yJIj213vj49V0VJKyKyqp+rlklBPNGnCAsDd0bwohMQ=' WHERE id='1002020000002584'


    #Support
    #SupportMigration
    #PowerServers


  • 2.  RE: 1 jdbc update query takes 10 minutes

    Posted Wed August 12, 2020 02:05 PM

    any ideas ? I tried auto_commit=false and PreparedStatment instead of jdbc, but nothing changed.


    #Support
    #SupportMigration
    #PowerServers