René's URL Explorer Experiment

Title: GH-929: Add UUID support in JDBC driver by xborder · Pull Request #930 · apache/arrow-java · GitHub

Open Graph Title: GH-929: Add UUID support in JDBC driver by xborder · Pull Request #930 · apache/arrow-java

X Title: GH-929: Add UUID support in JDBC driver by xborder · Pull Request #930 · apache/arrow-java

Description: What's Changed This PR adds UUID support to the Arrow Flight SQL JDBC driver, enabling JDBC applications to work with UUID data types when connecting to Flight SQL servers that use Arrow's canonical arrow.uuid extension type. Key Implementation Details Added ArrowFlightJdbcUuidVectorAccessor to handle reading UUID values from UuidVector getObject() returns java.util.UUID directly getString() returns the standard hyphenated UUID format (e.g., "550e8400-e29b-41d4-a716-446655440000") getBytes() returns the 16-byte binary representation Added UuidAvaticaParameterConverter to handle parameter binding for UUID columns Supports binding java.util.UUID objects directly via setObject() Supports binding UUID string representations via setString() Supports binding 16-byte arrays via setBytes() UUID extension type maps to java.sql.Types.OTHER. Updated SqlTypes to recognize UuidType and return appropriate SQL type ID Examples try (Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT id, session_id FROM sessions")) { while (rs.next()) { int id = rs.getInt("id"); // getObject() returns java.util.UUID directly UUID sessionId = rs.getObject("session_id", UUID.class); // getString() returns hyphenated format: "550e8400-e29b-41d4-a716-..." String sessionIdStr = rs.getString("session_id"); System.out.printf("ID: %d, UUID: %s%n", id, sessionId); } } // Use PreparedStatement to bind UUID parameters String sql = "SELECT * FROM sessions WHERE session_id = ?"; try (PreparedStatement pstmt = conn.prepareStatement(sql)) { UUID targetId = UUID.fromString("550e8400-e29b-41d4-a716-446655440000"); // Bind UUID directly with setObject() pstmt.setObject(1, targetId); // Or bind as string: pstmt.setString(1, targetId.toString()); try (ResultSet rs = pstmt.executeQuery()) { if (rs.next()) { System.out.println("Found: " + rs.getObject("session_id")); } } } Closes #929.

Open Graph Description: What's Changed This PR adds UUID support to the Arrow Flight SQL JDBC driver, enabling JDBC applications to work with UUID data types when connecting to Flight SQL servers that use Arrow's ...

X Description: What's Changed This PR adds UUID support to the Arrow Flight SQL JDBC driver, enabling JDBC applications to work with UUID data types when connecting to Flight SQL servers that use Arrow&am...

Opengraph URL: https://github.com/apache/arrow-java/pull/930

X: @github

direct link

Domain: github.com

Links:

Viewport: width=device-width