Error editing e-mail address

[mlohbihler]

To answer your question, yes, others have reported this problem, but it was never reproducable. I have added some code to try to protect against it based on information from Derby forums, and some logging in case it still happens. Hopefully, one way or another, this will be dealt with. The changes will be in the next release.

[craig]

the OS is windows 7. It does happen every time.

[mlohbihler]

Sorry, by "reproduceable", i meant not reproduceable in a development environment.

[craig]

on my local machine it is reproduceable if you would like me to test any patches

[mlohbihler]

Unfortunately, the UserDao class has undergone changes for multiple purposes, so i can't just send you a class file. But if you're feeling ambitious, you could modify the code by changing the updateUser method to that below. I have not tested this in 1.12.4, so ymmv.

    void updateUser(User user) {
        // Potential fix for "An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'null'"
        if (user.getPhone() == null)
            user.setPhone("");
        if (user.getHomeUrl() == null)
            user.setHomeUrl("");

        try {
            ejt.update(
                    USER_UPDATE,
                    new Object[] { user.getUsername(), user.getPassword(), user.getEmail(), user.getPhone(),
                            boolToChar(user.isAdmin()), boolToChar(user.isDisabled()), user.getHomeUrl(),
                            user.getReceiveAlarmEmails(), boolToChar(user.isReceiveOwnAuditEvents()),
                            user.getId() }, new int[] { Types.VARCHAR, Types.VARCHAR,
                            Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.INTEGER,
                            Types.VARCHAR, Types.INTEGER });
            saveRelationalData(user);
        }
        catch (DataIntegrityViolationException e) {
            // Log some information about the user object.
            LOG.error("Error updating user: " + user, e);
            throw e;
        }
    }

[craig]

that fixed it. thanks.

[mlohbihler]

Awesome. Thanks Craig.

[Victorino]

Can you make the updated library available for 1.12.4? I'm also having the same error when changing data point permissions on any users.

Actually I get the error when changing anything on a user.

[mlohbihler]

You should consider using Mango Automation. http://m2m2.serotoninsoftware.com/

[craig]

I have attached the patched UserDao classes off of an instance of 1.12.4.
Good Luck

@Victorino said:

Can you make the updated library available for 1.12.4?

Attachment: download link

[lordportux]

I had the same problem in mango 1.12.3 and I solved it using the Derby.jar file from mango 1.12.5