René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Problems with SQL, Midi and documentation","articleBody":"**Describe the bug**\n\nI couldn't find a wiki that would help me create a script that does a MySQL query, the existing ones don't have examples or the examples don't help at all.\n\nUnable to execute querys:\njava.sql.SQLException: Operation not allowed after ResultSet closed\n[12:00:35 WARN]:        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)\n[12:00:35 WARN]:        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)\n\nSkript:\nscript options:\n    $ init com.mysql.jdbc.Driver\n    $ db url jdbc:mysql://myhost/mydb\n    $ db username root\n    $ db password 1234\ncommand /testquery:\n    trigger:\n        set {_objects::*} to objects in column \"realname\" from result of query \"SELECT realname FROM authme limit 10\"\n        broadcast {_objects::*}\n\n\nError trying to reproduce midi:\ncommand /midi:\n\ttrigger:\n\t\tplay midi from link \"https://redemine.com.br/sounds/mario.mid\" to event-player\nException:\nException in thread \"Java Sound Sequencer\" java.lang.NoClassDefFoundError: Could not initialize class com.w00tmast3r.skquery.util.note.Instrument\n[11:54:04 WARN]:        at SkQuery-4.2.0.jar//com.w00tmast3r.skquery.util.note.NoteBlockReceiver.send(NoteBlockReceiver.java:39)\n[11:54:04 WARN]:        at java.desktop/com.sun.media.sound.AbstractMidiDevice$TransmitterList.sendMessage(AbstractMidiDevice.java:627)\n\n\n**Information:**\n- Skript version: 2.10.0\n- SkQuery versin: 4.2.0\n- Server software: Paper\n- Server version: 1.21\n","author":{"url":"https://github.com/victorgluz","@type":"Person","name":"victorgluz"},"datePublished":"2025-01-22T15:12:20.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/191/SkQuery/issues/191"}