db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ken Johanson <ken2...@kensystem.com>
Subject Database ping? ('select 1'?)
Date Fri, 12 Jan 2007 07:20:22 GMT
This syntax:

select 1

Seems to always throw a:

SQLException: Syntax error: Encountered "<EOF>" at line 1, column 8.

Is this table-less syntax going to be supported at some point, and what 
would be the next best means to do table-less select (such as for 
testing scalars, etc)

Of course this exmaple is also common for database connection pings, in 
systems where the connection may timeout or FIFO.. but is there a better 
(and equally efficient) approach to pinging?

I also tried `select values (1)`.

Thank you,

View raw message