Thread: Poolman/mySQL transaction exception on connect
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? Thanks. -Dominic
Not to be rude, but shouldn't you be posting to the MySQL mailing lists and not the PostgreSQL mailing lists? Jason Dominic Da Silva <ddasilva@directvinternet.com> writes: > 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? > > Thanks. > > -Dominic > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
Mr. Da Silva, > I am trying to load my mySQL JDBC driver using poolman and > am getting the following error: You have reached the PostgreSQL SQL developer's list. This is neither a MySQL list nor a JDBC list. As such, your question cannot be answered here. Please check the MySQL site ( http://www.mysql.com/ ) for links to an appropriate mailing list. -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
-----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-----