Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Date: Tue, 22 Apr 2014 09:19:39 -0400
From: "Mark H. Wood" <mwood@IUPUI.Edu>
To: users@tomcat.apache.org
Subject: Re: Should validationQuery commit ?
Message-ID: <20140422131939.GB30083@IUPUI.Edu>
References: <5350EAD0.1040200@axege.com>
 <535172A0.3070806@christopherschultz.net>
 <53565980.6010007@axege.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="rJwd6BRFiFCcLxzm"
Content-Disposition: inline
In-Reply-To: <53565980.6010007@axege.com>
User-Agent: Mutt/1.5.22 (2013-10-16)

--rJwd6BRFiFCcLxzm
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Apr 22, 2014 at 01:58:56PM +0200, Franck Routier wrote:
[snip]
> 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.

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

--rJwd6BRFiFCcLxzm
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iEYEAREIAAYFAlNWbGsACgkQs/NR4JuTKG++RwCcCImNJnTQQ7QC59a/qKxrWXwO
T/0An1uLEQ/2oLa1GUQlJVyMjEH8ji5D
=5oDi
-----END PGP SIGNATURE-----

--rJwd6BRFiFCcLxzm--