PostgreSQL SQL support
kloenk opened this issue ยท 3 comments
Is your feature request related to a problem? Please describe.
Tried setting BlueMap up using PostgreSQL, using the documentation for SQL.
Describe the solution you'd like
A sql syntax error is thrown by the PSQL jdbc adapter.
Stacktrace
################################
There is a problem with your BlueMap setup!
Failed to load and initialize the storage 'sql'!
################################
[21:35:18] [Thread-15/ERROR]: Failed to load bluemap!
java.io.IOException: de.bluecolored.bluemap.common.config.ConfigurationException: java.io.IOException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"
Position: 28
at de.bluecolored.bluemap.common.plugin.Plugin.load(Plugin.java:326) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.fabric.FabricMod.lambda$onInitialize$2(FabricMod.java:104) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: de.bluecolored.bluemap.common.config.ConfigurationException: java.io.IOException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"
Position: 28
at de.bluecolored.bluemap.common.BlueMapService.getStorage(BlueMapService.java:275) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.BlueMapService.loadWorldsAndMaps(BlueMapService.java:214) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.BlueMapService.getWorlds(BlueMapService.java:158) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.plugin.Plugin.load(Plugin.java:149) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
... 2 more
Caused by: java.io.IOException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"
Position: 28
at de.bluecolored.bluemap.core.storage.sql.SQLStorage.initialize(SQLStorage.java:477) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.BlueMapService.getStorage(BlueMapService.java:273) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.BlueMapService.loadWorldsAndMaps(BlueMapService.java:214) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.BlueMapService.getWorlds(BlueMapService.java:158) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.plugin.Plugin.load(Plugin.java:149) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
... 2 more
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"
Position: 28
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) ~[?:?]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) ~[?:?]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) ~[?:?]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) ~[?:?]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) ~[?:?]
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333) ~[?:?]
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319) ~[?:?]
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295) ~[?:?]
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:268) ~[?:?]
at de.bluecolored.shadow.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.shadow.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.shadow.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.core.storage.sql.SQLStorage.lambda$initialize$10(SQLStorage.java:374) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.core.storage.sql.SQLStorage.recoveringConnection(SQLStorage.java:524) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.core.storage.sql.SQLStorage.initialize(SQLStorage.java:373) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.BlueMapService.getStorage(BlueMapService.java:273) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.BlueMapService.loadWorldsAndMaps(BlueMapService.java:214) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.BlueMapService.getWorlds(BlueMapService.java:158) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
at de.bluecolored.bluemap.common.plugin.Plugin.load(Plugin.java:149) ~[cvav31clzs97zqn5afbjbr8mjpjbi6k5-BlueMap-3.3-fabric-1.19.jar:?]
... 2 more
I have not enough experience with JDBC to say this is not a JDBC error, but looks like a code feature missing in BlueMap.
BlueMap currently only supports MySQL-Compatible Databases, so i am treating this as a Feature Request ^^
yeah, meant as Feature request. Used the feature request template, maybe it got lost on GitHub's site.