Hi, 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.But you can omit the from if you want, as in 'select 1'
That said, using rollbackOnReturn=true seemed to work, but with Oracle I'm getting quite freuent ORA-12516 (TNS:listener could not find available handler with matching protocol stack) errors since I activated this setting. Is there a known gotcha with rollbackOnReturn=true and Oracle ? Maybe I should give a higher maxWait ? (right now, I left default setting). Thanks for any hint, Franck --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
