Based on this docs: https://github.com/aaberg/sql2o/wiki/Column-mappings
- Failed mapping when SELECT
Old query: SELECT created_date createdDate, user_id userId, phone FROM mob_user WHERE userId = :userIdParam
Exception: Database error: ORA-00904: "USERID": invalid identifier
But its success when query like this:
New query: SELECT created_date createdDate, user_id userId, phone FROM mob_user WHERE user_id = :userIdParam
- Failed mapping when UPDATE
Old query: UPDATE mob_user SET cuid = :cuidParam WHERE user_id = :userIdParam
Exception: - (but field not updated)
But its success when query like this:
New query: UPDATE mob_user SET cuid = :cuidParam WHERE phone = :phoneParam
Can you help me what's wrong??? I see something is wrong with the column using underscore. I'm using sql2o version 1.6.
MAVEN
org.sql2o
sql2o
1.6.0
Based on this docs: https://github.com/aaberg/sql2o/wiki/Column-mappings
Old query: SELECT created_date createdDate, user_id userId, phone FROM mob_user WHERE userId = :userIdParam
Exception: Database error: ORA-00904: "USERID": invalid identifier
But its success when query like this:
New query: SELECT created_date createdDate, user_id userId, phone FROM mob_user WHERE user_id = :userIdParam
Old query: UPDATE mob_user SET cuid = :cuidParam WHERE user_id = :userIdParam
Exception: - (but field not updated)
But its success when query like this:
New query: UPDATE mob_user SET cuid = :cuidParam WHERE phone = :phoneParam
Can you help me what's wrong??? I see something is wrong with the column using underscore. I'm using sql2o version 1.6.
MAVEN