Fixing the SQL Error in QA (ORCID#7117)

Camelia-Orcid · web-flow · commit c413162eb458 · 2024-10-30T10:13:51.000-06:00
diff --git a/orcid-persistence/src/main/java/org/orcid/persistence/dao/impl/PublicApiDailyRateLimitDaoImpl.java b/orcid-persistence/src/main/java/org/orcid/persistence/dao/impl/PublicApiDailyRateLimitDaoImpl.java
@@ -95,7 +95,7 @@ public boolean updatePublicApiDailyRateLimit(PublicApiDailyRateLimitEntity papiR
             query.setParameter("ipAddress", papiRateLimitingEntity.getIpAddress());
         }
         query.setParameter("requestCount", papiRateLimitingEntity.getRequestCount());
-        query.setParameter("requestDate", papiRateLimitingEntity.getRequestDate().toString());
+        query.setParameter("requestDate", papiRateLimitingEntity.getRequestDate());
         return query.executeUpdate() > 0;
     }
 

Original file line number	Diff line number	Diff line change
`@@ -95,7 +95,7 @@ public boolean updatePublicApiDailyRateLimit(PublicApiDailyRateLimitEntity papiR`
`95`	`95`	`query.setParameter("ipAddress", papiRateLimitingEntity.getIpAddress());`
`96`	`96`	`}`
`97`	`97`	`query.setParameter("requestCount", papiRateLimitingEntity.getRequestCount());`
`98`		`- query.setParameter("requestDate", papiRateLimitingEntity.getRequestDate().toString());`
	`98`	`+ query.setParameter("requestDate", papiRateLimitingEntity.getRequestDate());`
`99`	`99`	`return query.executeUpdate() > 0;`
`100`	`100`	`}`
`101`	`101`