Hi Chris, Le 18/04/2014 20:44, Christopher Schultz a écrit : > > Every database I've ever used accepts "SELECT 1 FROM DUAL" because > Oracle did it first. You could try that.
Well, Postgresql does not (although you can of course create table dual(id integer primary key); insert 1 into dual(id);). That said, I was hit by another (related) problem this week-end, with Oracle. The validation query was configured as 'select 1 from dual;'. Notice the semi-column: this broke everything with intermittent ORA-12516 errors. Removing the semi-column fixes my app with Oracle. Has anyone an idea of what is happening with this ; ? Franck --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
