Thanks Jacques. However "values 1" works in Derby (but not from the Webtools, because of a limitation in the data prep script).
Jacopo On May 24, 2012, at 11:33 AM, Jacques Le Roux wrote: > SELECT 1 FROM SYSIBM.SYSDUMMY1 works for Derby. If all others work with > SELECT 1 we could set a property in entityengine.xml (by DB)With SELECT 1 for > all but Derby and SELECT 1 FROM SYSIBM.SYSDUMMY1 for Derby. We could also use > the same trick for other DBs if SELECT 1 does not work for them (eg Oracle > has the dual table I read)I found the same idea at > http://svn.apache.org/repos/asf/tomcat/tags/JDBC_POOL_1_0_9_3/build.properties.default > (look for SELECT 1)But unfortunately VALUES 1 does not work with > DerbyJacquesFrom: "Jacopo Cappellato" jacopo.cappell...@hotwaxmedia.com> > On > May 24, 2012, at 10:37 AM, Jacques Le Roux wrote:> >> "select 1" works on > Postgres> > this is interesting, thanks for testing it.> Unfortunately it > doesn't seem to work on Derby and I didn't test on other dbs... but if we > could find a similar solution that works everywhere it would be great.> > > Jacopo