Project

General

Profile

Actions

Architecture #4526

closed

Architecture #4428: Avoid useless requests and commits in SQL database

Change the validation query for the database

Added by Nicolas CHARLES over 10 years ago. Updated over 9 years ago.

Status:
Released
Priority:
2
Category:
Performance and scalability
Target version:
Effort required:
Name check:
Fix check:
Regression:

Description

Rudder does the following query to check the connection validity:

SELECT tables.table_name FROM information_schema.tables WHERE lower(table_name) = '';

however, it seems the correct query (and which put less stress on the systems) is

select 1

as said in http://stackoverflow.com/questions/10684244/dbcp-validationquery-for-different-databases

Actions

Also available in: Atom PDF