[
https://issues.apache.org/jira/browse/TOMEE-2968?focusedWorklogId=560017&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-560017
]
ASF GitHub Bot logged work on TOMEE-2968:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 02/Mar/21 16:20
Start Date: 02/Mar/21 16:20
Worklog Time Spent: 10m
Work Description: rzo1 commented on a change in pull request #763:
URL: https://github.com/apache/tomee/pull/763#discussion_r585708625
##########
File path:
container/openejb-core/src/main/java/org/apache/openejb/util/PropertyPlaceHolderHelper.java
##########
@@ -53,33 +55,34 @@ public static void reset() {
}
public static String simpleValue(final String raw) {
- if (raw == null) {
- return null;
- }
- if (!raw.contains(PREFIX) || !raw.contains(SUFFIX)) {
- return String.class.cast(decryptIfNeeded(raw.replace(PREFIX,
"").replace(SUFFIX, ""), false));
- }
-
- String value = SUBSTITUTOR.replace(raw);
- if (!value.equals(raw) && value.startsWith("java:")) {
- value = value.substring(5);
- }
- return String.class.cast(decryptIfNeeded(value.replace(PREFIX,
"").replace(SUFFIX, ""), false));
+ return String.class.cast(simpleValueAsStringOrCharArray(raw, false));
}
public static Object simpleValueAsStringOrCharArray(final String raw) {
+ return simpleValueAsStringOrCharArray(raw, true);
+ }
+
+ private static Object simpleValueAsStringOrCharArray(final String raw,
boolean acceptCharArray) {
if (raw == null) {
return null;
}
if (!raw.contains(PREFIX) || !raw.contains(SUFFIX)) {
- return decryptIfNeeded(raw.replace(PREFIX, "").replace(SUFFIX,
""), true);
+ return decryptIfNeeded(raw, acceptCharArray);
}
String value = SUBSTITUTOR.replace(raw);
+
if (!value.equals(raw) && value.startsWith("java:")) {
value = value.substring(5);
}
- return decryptIfNeeded(value.replace(PREFIX, "").replace(SUFFIX, ""),
true);
+
+ // no key defined and no escape sequence found -> substitute to key
instead
+ if (!(raw.contains(ESCAPE_SEQUENCE) || value.contains(ESCAPE_SEQUENCE))
Review comment:
Thx @rmannibucau for the follow up!
Yes - testing with `contains` is a simplification and neglects some weirdo
cases... and yes: it would require char, position + offsets to properly test
and replace the closing and opening brackets.
Thus, I like the idea of using `PropertiesLookup#lookup` and returning the
key there. The parsing "magic" (char, position, offsets) is already done in the
substitutor, so I guess fallbacking there is a good option.
I will take a look at it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 560017)
Time Spent: 4h 40m (was: 4.5h)
> 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: 7.0.5, 8.0.0-Final, 7.1.4, 8.0.6
> Environment: Windows 10
> Reporter: Alex Levin
> Assignee: Richard Zowalla
> Priority: Major
> Time Spent: 4h 40m
> Remaining Estimate: 0h
>
> 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)
