-
Notifications
You must be signed in to change notification settings - Fork 229
Open
Description
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
Metadata
Metadata
Assignees
Labels
No labels