apache / apache/arrow-java

[Java][JDBC][FlightSql] Select query fails when using JDBC to query Sqlite example

Open
#165 8 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
94
Forks
152
Avg merge
3d 16h
Merged PRs (30d)
11

Description

### Describe the bug, including details regarding any error messages, version, and platform.

Running [this example](https://github.com/apache/arrow/blob/main/go/arrow/flight/flightsql/example/cmd/sqlite_flightsql_server/main.go)

I then use DBeaver with the Arrow JDBC Driver
![image](https://github.com/apache/arrow-java/assets/6108819/37254b9e-6326-4725-8434-94d3ae9f374e)

`jdbc:arrow-flight-sql://localhost:53822?useEncryption=false&disableCertificateVerification=true&user=flight_username&password=xxxx`

When running a Select statement and debugging, I see it is performing a Put on the backend and trying to run an Update statement resulting in no data:
![image](https://github.com/apache/arrow-java/assets/6108819/be4c9388-0436-4925-8d53-c7421583d1c1)

![image](https://github.com/apache/arrow-java/assets/6108819/4ac8f601-843f-42fb-b03d-56db7e6c015b)

![image](https://github.com/apache/arrow-java/assets/6108819/461021bb-b523-4485-b38a-a8729d5b3ea3)

If I run a Flight Server using [this example](https://github.com/voltrondata/flight-sql-server-example), and run a Select query, it works fine.
`jdbc:arrow-flight-sql://localhost:31337?useEncryption=true&disableCertificateVerification=true&user=flight_username&password=xxxx`
![image](https://github.com/apache/arrow-java/assets/6108819/ab6fa95d-0eb7-4b2f-a8b9-d01d2b92ebc4)

### Component(s)

Go

Contributor guide

Open the contributing guide

Research direction

Reproduce the failure with the Go sqlite_flightsql_server example, DBeaver, and the Arrow JDBC URL shown in the report. Compare it with the working flight-sql-server-example and trace why SELECT is treated as an update; done means the SQLite example returns query rows through the JDBC driver.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sqlite
Domain
api, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.