From: Andrew G. Hammond <drew@xyzzy.dhs.org>
To: Dominic Da Silva <ddasilva@directvinternet.com>
To: pgsql-sql@postgresql.org
Subject: Re: Poolman/mySQL transaction exception on connect
Date: Tue, 11 Dec 2001 23:43:22 -0500
Message-ID: <E16E1Eu-0000AQ-00@xyzzy.lan.internal> (raw)
In-Reply-To: <3C13C9A4.8080801@directvinternet.com>
References: <3C13C9A4.8080801@directvinternet.com>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: drew@xyzzy.dhs.org, ddasilva@directvinternet.com
Subject: Re: Poolman/mySQL transaction exception on connect
In-Reply-To: <E16E1Eu-0000AQ-00@xyzzy.lan.internal>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox