[I] [Java][JDBC][FlightSql] Select query fails when using JDBC to query Sqlite example [arrow-java]

["scottlepp (via GitHub)" <gi...@apache.org>]

scottlepp opened a new issue, #165:
URL: https://github.com/apache/arrow-java/issues/165

   ### 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/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/assets/6108819/be4c9388-0436-4925-8d53-c7421583d1c1)
   
   ![image](https://github.com/apache/arrow/assets/6108819/4ac8f601-843f-42fb-b03d-56db7e6c015b)
   
   ![image](https://github.com/apache/arrow/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/assets/6108819/ab6fa95d-0eb7-4b2f-a8b9-d01d2b92ebc4)
   
   
   
   
   
   ### Component(s)
   
   Go


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org