tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark H. Wood" <mw...@IUPUI.Edu>
Subject Re: Should validationQuery commit ?
Date Tue, 22 Apr 2014 13:19:39 GMT
On Tue, Apr 22, 2014 at 01:58:56PM +0200, Franck Routier wrote:
> 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 ; ?

I believe that the semicolon is a delimiter used by SQL*Plus (and many
other interactive tools for DBMS access).  It seems to be used by SQL
itself only in the module language and embedded SQL, where a statement
delimiter is needed.  It's not part of an SQL statement, so it
probably doesn't belong in a query string.

Commandline tools need a statement delimiter, but statements fed to
the DBMS programmatically are delimited by end-of-string.

Mark H. Wood, Lead System Programmer   mwood@IUPUI.Edu
Machines should not be friendly.  Machines should be obedient.

View raw message