Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is a good validation query to use with JayBird?

April 26, 2017good JayBird query validation

0

Posted

What is a good validation query to use with JayBird?

1 Answer

0

Posted

Some programs and web applications need a query that they can send to the database to verify that it is online and connected, or to insure that a connection hasn’t timed out. That is called a validation query. A good one for Firebird/JayBird is: SELECT CAST(1 AS INTEGER) FROM rdb$database This select will always succeed if the connection is still alive and will have exactly one row in the result set..