Task #3768 (closed)
Bug: setUserPassword fails on PG
| Reported by: | jamoore | Owned by: | jamoore |
|---|---|---|---|
| Priority: | critical | Milestone: | OMERO-Beta4.3 |
| Component: | General | Version: | n.a. |
| Keywords: | n.a. | Cc: | |
| Resources: | n.a. | Referenced By: | n.a. |
| References: | n.a. | Remaining Time: | 0.0d |
| Sprint: | 2011-01-13 (3) |
Description
serverStackTrace = ome.conditions.ApiUsageException: PreparedStatementCallback; bad SQL grammar [update password set hash = ? where experimenter_id = ?]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) ... ome.security.auth.PasswordProviders.changePassword(PasswordProviders.java:56) at ome.logic.AdminImpl._changePassword(AdminImpl.java:1108) at ome.logic.AdminImpl.changeUserPassword(AdminImpl.java:1103) at ome.logic.AdminImpl.createExperimenter(AdminImpl.java:559)
Change History (4)
comment:1 Changed 13 years ago by jmoore
comment:2 Changed 13 years ago by jmoore
- Resolution set to fixed
- Status changed from new to closed
(In [8870/omero]) Reversing password and experimenterID arguments (Fix #3768)
comment:3 Changed 13 years ago by jmoore <josh@…>
- Remaining Time set to 0
(In [3fec2406447d126d6050e22080decbf3ca23ca74/ome.git] on branch dev_4_1_custom) Reversing password and experimenterID arguments (Fix #3768)
git-svn-id: file:///home/svn/omero/trunk@8870 05709c45-44f0-0310-885b-81a1db45b4a6
comment:4 Changed 13 years ago by jmoore <josh@…>
(In [3fec2406447d126d6050e22080decbf3ca23ca74/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Reversing password and experimenterID arguments (Fix #3768)
git-svn-id: file:///home/svn/omero/trunk@8870 05709c45-44f0-0310-885b-81a1db45b4a6
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
(In [8871/omero]) Reversing password and experimenterID arguments (See #3768)
original-svn-id: file:///home/svn/omero/trunk@8870 05709c45-44f0-0310-885b-81a1db45b4a6