Re: Dependency of DBCPConnectionFactory on ExampleType entity

[Jacques Le Roux]

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