René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"java exception with SQLDatabaseMetaData == null","articleBody":"Hello gurus,\r\n\r\nI'm new to SquirrelSQL. I encounter the error that confuses me.\r\n\r\nI installed SquirrelSQL 4.8.0 om Mac M2, with Sonoma. I have JDK 21. SquirrelSQL runs fine. I can connect to Mysql and IBM Db2 servers without issues. I can query the databases and get the results. I can edit data.\r\n\r\nWhat is however doesn't work is any refactor command. Whenever I try to alter table or add a column I consistently get an exception:\r\n\r\n```\r\nERROR  net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand  - Unexpected exception on sql generation: SQLDatabaseMetaData == null\r\njava.lang.IllegalArgumentException: SQLDatabaseMetaData == null\r\n        at net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectInfo.\u003cinit\u003e(DatabaseObjectInfo.java:69)\r\n        at net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo.\u003cinit\u003e(TableColumnInfo.java:56)\r\n        at net.sourceforge.squirrel_sql.client.gui.db.ColumnDetailDialog.getColumnInfo(ColumnDetailDialog.java:259)  \r\n        at net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddColumnCommand.generateSQLStatements(AddColumnCommand.java:88)\r\n        at net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand$1.run(AbstractRefactoringCommand.java:200)\r\n        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)\r\n        at java.base/java.lang.Thread.run(Thread.java:1623)\r\n```\r\n\r\nThis behavior is identical with both IBM Db2 and Mysql databases. I also installed SquirrelSQL 4.8.0 on my older Intel Mac with Mojave and JDK 17. Same issue. I couldn't find on Google anything related to this. \r\n\r\nWhat's wrong here? How to solve the problem with refactoring? Thank you for your help. \r\n\r\nP.S.\r\nTo copy the above log entries I checked the SquirrelSQL log files and see that it is full of the similar exceptions like this (though I don't observe these errors in the GUI):\r\n```\r\nERROR  net.sourceforge.squirrel_sql.client.session.messagepanel.MessagePanel  - privateShowMessage: Exception was: SQLDatabaseMetaData == null\r\njava.lang.IllegalArgumentException: SQLDatabaseMetaData == null\r\n        at net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectInfo.\u003cinit\u003e(DatabaseObjectInfo.java:69)\r\n        at net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo.\u003cinit\u003e(TableColumnInfo.java:56)\r\n        at net.sourceforge.squirrel_sql.client.gui.db.ColumnDetailDialog.getColumnInfo(ColumnDetailDialog.java:259)\r\n        at net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddColumnCommand.generateSQLStatements(AddColumnCommand.java:88)\r\n        at net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand$1.run(AbstractRefactoringCommand.java:200)\r\n        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)\r\n        at java.base/java.lang.Thread.run(Thread.java:1583)\r\n``` \r\n\r\n[UPDATE]: I installed SquirrelSQL on my third PC, Fedora 40 x86_64, with OpenJDK 21. Same thing. I'm now sure that either I'm doing something fundamentally wrong, or this client has a bug. I'm doing just clean install with necessary DB plugins, then driver installation, then alias creation. No any other configurations made, so this works as described out of the box.\r\n\r\n[UPDATE 2]: Yeah, the previous version, 4.7.1, doesn't contain this bug (at least on Fedora) and works as expected.","author":{"url":"https://github.com/dutty5","@type":"Person","name":"dutty5"},"datePublished":"2024-10-04T10:59:15.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/42/squirrel-sql-code/issues/42"}