How about defining a test sql statement in entityegine.xml which could
be specific to DBMS. For example 'select * from dual" in oracle and
MySQL, "Select 1" in PostgreSQL. Idea is to use the DBMS specific SQL
and make it configurable in the entityengine.xml so that it can be
configured while configuring the datasource.
Thanks,
Raj
On Thursday 24 May 2012 08:48 PM, Jacopo Cappellato wrote:
On May 24, 2012, at 5:06 PM, Adam Heath wrote:
select 1 from entity_key_store where key_name = '' limit 1;
ouch, I am getting an error on Derby for the "limit 1" syntax... since it is currently
used in the validation query based on "Example" I am now wondering if it is actually used
at all.
I will skip the limit 1 because as you mentioned key_name is a pk and this
should still guarantee that 0 records are returned
Thanks
Jacopo