Received: from xyzzy.lan.internal (d226-89-133.home.cgocable.net [24.226.89.133]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBC4hQm96081 for ; Tue, 11 Dec 2001 23:43:26 -0500 (EST) (envelope-from drew@xyzzy.dhs.org) Received: from localhost ([127.0.0.1] helo=there ident=drew) by xyzzy.lan.internal with smtp (Exim 3.33 #1 (Debian)) id 16E1Eu-0000AQ-00; Tue, 11 Dec 2001 23:43:28 -0500 Content-Type: text/plain; charset="iso-8859-1" From: "Andrew G. Hammond" To: Dominic Da Silva , pgsql-sql@postgresql.org Subject: Re: Poolman/mySQL transaction exception on connect Date: Tue, 11 Dec 2001 23:43:22 -0500 X-Mailer: KMail [version 1.3.2] References: <3C13C9A4.8080801@directvinternet.com> In-Reply-To: <3C13C9A4.8080801@directvinternet.com> MIME-Version: 1.0 Message-Id: Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fBC4nCL96247 X-Archive-Number: 200112/119 X-Sequence-Number: 5942 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2001 December 9 03:29 pm, Dominic Da Silva wrote: > I am trying to load my mySQL JDBC driver using poolman and > am getting the following error: > > openConnection() - Exception occurred: SQLException occurred in > JDBCPool: java.sql.SQLException: Transaction Isolation Levels are not > supported. > > I am using the max version of mySQL and created the tables I am trying > to access as InnoDB tables. > Any reason why the driver is throwing the exception? Well, if you upgrade your database to Postgres, we might be able to help you. Either way, I'd suggest the pgsql-jdbc list instead of this one. I think, however, that the simplest answer is right in front of your face: "Transaction Isolation Levels are not supported." poolman apparently relies on the jdbc driver to manage transactional isolation. The jdbc driver doesn't, which means that your connection pooler can't use it. So of course it barfs. Of course since MySQL doesn't support transactions, you're probably not going to be able to find a jdbc driver which does. Moral of the story? Get a real database. - -- Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/ 56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481 5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1 "To blow recursion you must first blow recur" -- me -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjwW4G4ACgkQCT73CrRXhLHMiQCfTM0w9Cf5jdq1dTpwNJ0qqVtr SBsAoIWQaE1UH9YWHfGCBuk88taAwsIn =3i4J -----END PGP SIGNATURE-----