[
https://issues.apache.org/jira/browse/TOMEE-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alex Levin updated TOMEE-2968:
------------------------------
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"
was:
If a password contains the "}" (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"
> Postgres connection error when a password contains "}"
> ------------------------------------------------------
>
> Key: TOMEE-2968
> URL: https://issues.apache.org/jira/browse/TOMEE-2968
> Project: TomEE
> Issue Type: Bug
> Components: TomEE Core Server
> Affects Versions: 8.0.0-Final
> Environment: Windows 10
> Reporter: Alex Levin
> Priority: Critical
> Fix For: 8.0.0-Final
>
>
> 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"
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
