How to insert a Set into a column of type integer[]?

I have a column of type `integer[]`, created with the following query. ... questions int[] DEFAULT '{}', ... I am trying to insert a set of integers using Hibernate's query functionality. Set questions = randomQuestions(); Query query = session.createSQLQuery("UPDATE contestant SET questions=:questions WHERE email=:email"); query.setParameterList("questions", questions); query.setParameter("email", email); query.executeUpdate(); This doesn not successfully execute and throws and exception. Caused by: org.postgresql.util.PSQLException: ERROR: column "questions" is of type integer[] but expression is of type record Hint: You will need to rewrite or cast the expression. How will I go about inserting my set of integers into the database?

以上就是How to insert a Set into a column of type integer[]?的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » JavaScript 答疑

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准