You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I need to use IN clause in a query. We're using version 1.5.4 version of sql2o. When I bind a list of strings to the query, I am getting the below exception java.lang.RuntimeException: Error adding parameter 'ids' - Invalid column type at org.sql2o.Query.addParameterInternal(Query.java:137) at org.sql2o.Query.addParameter(Query.java:173) at org.sql2o.Query.addParameter(Query.java:194)
I had then updated the sql2o version to 1.6 and I am successfully able to bind a list to IN clause in the query. query.addParameter("ids", List<String> ids);
With the new 1.6 version, I am trying to a perform a modify operation when performs an update query. The executeUpdate() is throwing an exception "Operation not allowed". But the same code works with 1.5.4 version of sql2o.
Is this a known issue? Is there any work around where I can use "IN" clause with 1.5.4 version. Please suggest. Thank you
The text was updated successfully, but these errors were encountered:
I need to use IN clause in a query. We're using version 1.5.4 version of sql2o. When I bind a list of strings to the query, I am getting the below exception
java.lang.RuntimeException: Error adding parameter 'ids' - Invalid column type at org.sql2o.Query.addParameterInternal(Query.java:137) at org.sql2o.Query.addParameter(Query.java:173) at org.sql2o.Query.addParameter(Query.java:194)
I had then updated the sql2o version to 1.6 and I am successfully able to bind a list to IN clause in the query.
query.addParameter("ids", List<String> ids);
With the new 1.6 version, I am trying to a perform a modify operation when performs an update query. The executeUpdate() is throwing an exception "Operation not allowed". But the same code works with 1.5.4 version of sql2o.
Is this a known issue? Is there any work around where I can use "IN" clause with 1.5.4 version. Please suggest. Thank you
The text was updated successfully, but these errors were encountered: