sunmingtao / sample-code

3 stars 4 forks source link

DL Trove broken in UAT: No suitable driver #209

Closed sunmingtao closed 3 years ago

sunmingtao commented 3 years ago

Hit https://dl-uat.nla.gov.au/dl-trove/Repository/TroveService/changes/works?start=2020-03-22T00:00:00.000%2b00:00&end=2020-03-26T00:00:00.000%2b00:00&offset=0&pageSize=50&bibLevel=Item&collection=nla.aus&collection=nla.gen&collection=nla.mus&form=Journal

image
URI: | /Repository/TroveService/changes/works
-- | --
500
javax.servlet.ServletException:  org.springframework.web.util.NestedServletException: Request processing  failed; nested exception is java.lang.RuntimeException: Failed to get  driver instance for  jdbcUrl=jdbc:mysql://mysql-dluat.nla.gov.au:8306/amberdb?allowMultiQueries=true&useUnicode=yes&serverTimezone=Australia/Sydney&zeroDateTimeBehavior=convertToNull
appServlet
javax.servlet.ServletException:  org.springframework.web.util.NestedServletException: Request processing  failed; nested exception is java.lang.RuntimeException: Failed to get  driver instance for  jdbcUrl=jdbc:mysql://mysql-dluat.nla.gov.au:8306/amberdb?allowMultiQueries=true&useUnicode=yes&serverTimezone=Australia/Sydney&zeroDateTimeBehavior=convertToNull
org.springframework.web.util.NestedServletException:  Request processing failed; nested exception is  java.lang.RuntimeException: Failed to get driver instance for  jdbcUrl=jdbc:mysql://mysql-dluat.nla.gov.au:8306/amberdb?allowMultiQueries=true&useUnicode=yes&serverTimezone=Australia/Sydney&zeroDateTimeBehavior=convertToNull
java.lang.RuntimeException: Failed to get  driver instance for  jdbcUrl=jdbc:mysql://mysql-dluat.nla.gov.au:8306/amberdb?allowMultiQueries=true&useUnicode=yes&serverTimezone=Australia/Sydney&zeroDateTimeBehavior=convertToNull
java.sql.SQLException: No suitable driver
sunmingtao commented 3 years ago

Make change in jvmctl config to make it work (scratch it)

-JAVA_HOME=/usr/lib/jvm/java-11
+JAVA_HOME=/usr/lib/jvm/java-11-openjdk

I change it back and it still works...All it needed was a redeploy.