René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"JDBC driver does not support compressed IPC streams (ZSTD, LZ4) [FlightSQL]","articleBody":"### Describe the bug, including details regarding any error messages, version, and platform.\n\n**Component:** Flight SQL JDBC Driver\n**Version:** 18.3.0\n\nThe `flight-sql-jdbc-driver` shaded JAR does not include compression support, causing connection failures when the Flight SQL server sends compressed IPC streams using ZSTD or LZ4 compression.\n\n### Expected Behavior\nThe JDBC driver should be able to handle compressed IPC streams from Flight SQL servers, similar to how the direct Flight SQL client (`flight-sql` artifact) handles them.\n\n### Actual Behavior\nConnection fails with one of these errors depending on compression type used by server:\n\n**ZSTD compression:**\n```\njava.lang.IllegalArgumentException: Please add arrow-compression module to use CommonsCompressionFactory for ZSTD\nat org.apache.arrow.driver.jdbc.shaded.org.apache.arrow.vector.compression.NoCompressionCodec$Factory.createCodec(NoCompressionCodec.java:63)\n```\n\n**LZ4 compression:**\n```\nArrow error: Invalid argument error: lz4 IPC compression requires the lz4 feature\n```\n\n### Steps to Reproduce\n\n1. Set up a Flight SQL server that uses compression (ZSTD or LZ4)\n2. Try to connect using the JDBC driver:\nString url = \"jdbc:arrow-flight-sql://localhost:5127?useEncryption=false\";\nConnection conn = DriverManager.getConnection(url);\nStatement stmt = conn.createStatement();\nResultSet rs = stmt.executeQuery(\"SELECT * FROM table\");\n// Fails with compression error\n### Workaround\nCurrently, either:\n1. Disable compression on the server side, OR\n2. Use the direct Flight SQL client API (`flight-sql` and `flight-core` artifacts) instead of JDBC\n\n### Additional Context\n- Direct Flight SQL client works fine with compression\n- This affects any Flight SQL server that enables compression by default\n- JDBC drivers should be able to handle all protocol features transparently\n\n\n\n\n\n\n","author":{"url":"https://github.com/aarshivv","@type":"Person","name":"aarshivv"},"datePublished":"2025-12-02T17:18:16.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/926/arrow-java/issues/926"}