[Crash] SQLException: Type java.lang.String not supported type

[kangobot]

Auto-reported crash

Key	Value
Plugin	ChatControl 12.1.20
Server	Youer 1.21.1-R0.1-SNAPSHOT
Players Online	0
BBB Nonce	a6a80319034c7c9925e0cceedbde401b
db_type	remote
db_player_type	uuid
proxy_enabled	true

Context

Error selecting database rows
Table: ChatControl_Settings
Query: SELECT * FROM ChatControl_Settings WHERE Server = ?

Stack Trace

SQLException: Type java.lang.String not supported type
	at MC-BOOTSTRAP/librariesvault@1.21.1-2/org.mariadb.jdbc.BasePreparedStatement.setInternalObject(BasePreparedStatement.java:1248)
	at MC-BOOTSTRAP/librariesvault@1.21.1-2/org.mariadb.jdbc.BasePreparedStatement.setObject(BasePreparedStatement.java:644)
	at ChatControl-12.1.20.jar//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setObject(HikariProxyPreparedStatement.java)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.lib.database.SimpleDatabase$2.invoke(SimpleDatabase.java:1484)
	at ChatControl-12.1.20.jar/jdk.proxy14/jdk.proxy14.$Proxy219.setObject(Unknown Source)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.lib.database.SimpleDatabase.select(SimpleDatabase.java:1002)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.lib.database.SimpleDatabase.getRowsWhere(SimpleDatabase.java:568)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.lib.database.SimpleDatabase.getRowWhere(SimpleDatabase.java:551)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.model.db.Database.getServerSettings(Database.java:671)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.model.db.Database.getProxySettings(Database.java:659)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.model.db.Database.prepareTables(Database.java:114)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.ChatControl.onPluginStart(ChatControl.java:124)
	at ChatControl-12.1.20.jar//org.mineacademy.chatcontrol.lib.platform.BukkitPlugin.onEnable(BukkitPlugin.java:402)
	at TRANSFORMER/neoforge@21.1.232/org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:293)
	at TRANSFORMER/neoforge@21.1.232/io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:202)
	at TRANSFORMER/neoforge@21.1.232/io.papermc.paper.plugin.manager.PaperPluginManagerImpl.enablePlugin(PaperPluginManagerImpl.java:108)
	at TRANSFORMER/neoforge@21.1.232/org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:524)
	at TRANSFORMER/neoforge@21.1.232/org.bukkit.craftbukkit.CraftServer.enablePlugin(CraftServer.java:691)
	at TRANSFORMER/neoforge@21.1.232/org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:639)
	at TRANSFORMER/minecraft@1.21.1/net.minecraft.server.MinecraftServer.createLevels(MinecraftServer.java:639)
	at TRANSFORMER/minecraft@1.21.1/net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:488)
	at TRANSFORMER/minecraft@1.21.1/net.minecraft.server.dedicated.DedicatedServer.initServer(DedicatedServer.java:275)
	at TRANSFORMER/minecraft@1.21.1/net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1064)
	at TRANSFORMER/minecraft@1.21.1/net.minecraft.server.MinecraftServer.lambda$spin$2(MinecraftServer.java:347)
	at java.base/java.lang.Thread.run(Thread.java:1583)

[kangarko]

This is Youer breaking JDBC, not a ChatControl bug. Your stack trace shows the MariaDB driver loading from Youer's own librariesvault boot module instead of the driver we download and pin. Their repackaged driver breaks Java's ServiceLoader, so its codec list comes up empty and every parameterized query fails with "Type java.lang.String not supported type". Plain SQL still works, which is why the plugin got as far as it did.

I hardened the next build to bind values with typed setters, which sidesteps their broken codec discovery, so this particular error should go away. That said, NeoForge hybrids like Youer patch server internals in ways I cannot support, so if anything else misbehaves there, test on Paper before reporting.

[kangarko]

Fixed in 12.2.0. The plugin now binds database values in a way that survives Youer's repackaged driver.