[Java][JDBC][FlightSql] Select query fails when using JDBC to query Sqlite example
- 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

`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:



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`

### Component(s)
Go
Contributor 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