[TOMEE-2968] Postgres connection error when a password contains "}"

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 7.0.5, 8.0.0-Final, 7.1.4, 8.0.6
• Fix Version/s: 7.0.10, 7.1.5, 8.0.7, 8.0.8
• Component/s: TomEE Core Server
• Environment: Windows 10
• Flags: Important
• Assignee: Richard Zowalla
• Reporter: Alex Levin
• Created: 02/Feb/21 21:04
• Updated: 12/May/21 14:32
• Resolved: 04/Mar/21 09:35

Description

If a password contains the "}" character (closing curly brace), the database connection cannot be established.
My resources.xml:
<Resource id="Postgres Databse" type="javax.sql.DataSource">
    jdbcDriver org.postgresql.Driver
    jdbcUrl jdbc:postgresql://localhost:5432/postgresdb
    username scott
    password tiger...}
    maxActive = 250
</Resource>
Error message in the log:
2021-02-02 15:55:45 WARN [main] SqlExceptionHelper:144 - SQL Error: 0, SQLState: 28P01
2021-02-02 15:55:45 ERROR [main] SqlExceptionHelper:146 - FATAL: password authentication failed for user "scott"

Issue Links

• links to: GitHub Pull Request #763