Unable to insert negative coordinate values in MS SQL Server about deegree3 HOT 4 CLOSED

@datsnew has fixed it locally now in mssqlgeometryconverter.java.
A pull request will be created.

 Override
public void setParticle(PreparedStatement stmt, Geometry particle, int paramIndex) throws SQLException {
if (particle == null) {
stmt.setObject(paramIndex, null);
return;
}
particle = getCompatibleGeometry(particle);
if (is2d) {
try {
stmt.setBytes(paramIndex, WKBWriter.write(particle));
}
catch (Throwable e) {
throw new SQLException(e);
}
}
else {
// Added Replace UTF minus sign with hyphen-minus in particle
stmt.setString(paramIndex, WKTWriter.write(particle).replace('\u2212', '\u002D'));
}
}

from deegree3.

Thank you. I did a test with the suggested parameters and it worked. So it seams that the problem indeed is related to the default locale. The linked issues looks like this was introduced in JDK17, but we experiencing the same behavior with JDK 11.

Thank you for taking the time to look into and discuss this issue.

from deegree3.

Anyone looking at this bug? Very critical for the Norwegian use of deegree WFS-T.
@datsnew has tried fixing it locally without sucsess.

from deegree3.

In today's TMC-Meeting we discussed this again and found that this issue seems to be related to the used locale of the system.

Could you try to test if this issue also occurs when your container (tomcat) runs with English as it default locale?
For example, adding the following parameters -Duser.country=GB -Duser.language=en.

See also:

• adoptium/adoptium-support#709
• https://bugs.openjdk.org/browse/JDK-8302552

from deegree3.