You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
THe DB Health provider is not working correctly with Oracle Database.
This is because the query used in the code to check if DB is up is not a valid SQL Statement for Oracle :
res=self.engine.execute(f"SELECT {expected}")
should be :
res=self.engine.execute(f"SELECT {expected} from dual")
Instead of submitting a statement which can not guaranteed to be correct for all SQLAlchemy backend, may I suggest to use the do_ping function provided in the SQL Alchemy plumbing for each dialect, which will take care of using the correct query :
Hi,
THe DB Health provider is not working correctly with Oracle Database.
This is because the query used in the code to check if DB is up is not a valid SQL Statement for Oracle :
should be :
Instead of submitting a statement which can not guaranteed to be correct for all SQLAlchemy backend, may I suggest to use the do_ping function provided in the SQL Alchemy plumbing for each dialect, which will take care of using the correct query :
Instead of :
do :
Rgds
Jerome
The text was updated successfully, but these errors were encountered: