Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Operation not allowed on execute update with 1.6.0 #326

Open
harshathota1991 opened this issue Apr 30, 2019 · 0 comments
Open

Operation not allowed on execute update with 1.6.0 #326

harshathota1991 opened this issue Apr 30, 2019 · 0 comments

Comments

@harshathota1991
Copy link

harshathota1991 commented Apr 30, 2019

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant