SELECT 1; is not a valid query to test connection for DB2 iseries ODBC connection #48

Activity

1. ThiccPan

   added

   bugSomething isn't workingSomething isn't working

   on Dec 12, 2025
2. lovasoa commented on Dec 12, 2025

   

   lovasoa

   on Dec 12, 2025

   Collaborator

   More actions

   Thank you for reporting this ! Do you want to try and open a pull request ? I can guide you if you need. db2 is paid and proprietary, so I will need to trust you to test your changes locally
3. lovasoa commented on Dec 12, 2025

   

   lovasoa

   on Dec 12, 2025

   Collaborator

   More actions

   the offending code is here

   sqlx-oldapi/sqlx-core/src/odbc/connection/mod.rs

   Lines 123 to 129 in 645fd0d

   	pub(crate) async fn ping_blocking(&mut self) -> Result<(), Error> {
   	self.with_conn("ping", move |conn| {
   	conn.execute("SELECT 1", (), None)?;
   	Ok(())
   	})
   	.await
   	}

   and if you just want to work around the issue temporarily, you should be able to use test_before_acquire(false) https://docs.rs/sqlx-oldapi/latest/sqlx_oldapi/pool/struct.PoolOptions.html#method.test_before_acquire