pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Poolman/mySQL transaction exception on connect
4+ messages / 4 participants
[nested] [flat]

* Poolman/mySQL transaction exception on connect
@ 2001-12-09 20:29 Dominic Da Silva <ddasilva@directvinternet.com>
  2001-12-10 19:11 ` Re: Poolman/mySQL transaction exception on connect Jason Earl <jason.earl@simplot.com>
  2001-12-10 19:38 ` Re: Poolman/mySQL transaction exception on connect Josh Berkus <josh@agliodbs.com>
  2001-12-12 04:43 ` Re: Poolman/mySQL transaction exception on connect Andrew G. Hammond <drew@xyzzy.dhs.org>
  0 siblings, 3 replies; 4+ messages in thread

From: Dominic Da Silva @ 2001-12-09 20:29 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Poolman/mySQL transaction exception on connect
  2001-12-09 20:29 Poolman/mySQL transaction exception on connect Dominic Da Silva <ddasilva@directvinternet.com>
@ 2001-12-10 19:11 ` Jason Earl <jason.earl@simplot.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Jason Earl @ 2001-12-10 19:11 UTC (permalink / raw)
  To: Dominic Da Silva <ddasilva@directvinternet.com>; +Cc: pgsql-sql


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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Poolman/mySQL transaction exception on connect
  2001-12-09 20:29 Poolman/mySQL transaction exception on connect Dominic Da Silva <ddasilva@directvinternet.com>
@ 2001-12-10 19:38 ` Josh Berkus <josh@agliodbs.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Josh Berkus @ 2001-12-10 19:38 UTC (permalink / raw)
  To: Dominic Da Silva <ddasilva@directvinternet.com>; pgsql-sql

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 information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Poolman/mySQL transaction exception on connect
  2001-12-09 20:29 Poolman/mySQL transaction exception on connect Dominic Da Silva <ddasilva@directvinternet.com>
@ 2001-12-12 04:43 ` Andrew G. Hammond <drew@xyzzy.dhs.org>
  2 siblings, 0 replies; 4+ messages in thread

From: Andrew G. Hammond @ 2001-12-12 04:43 UTC (permalink / raw)
  To: Dominic Da Silva <ddasilva@directvinternet.com>; pgsql-sql

-----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-----



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-12-12 04:43 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-09 20:29 Poolman/mySQL transaction exception on connect Dominic Da Silva <ddasilva@directvinternet.com>
2001-12-10 19:11 ` Jason Earl <jason.earl@simplot.com>
2001-12-10 19:38 ` Josh Berkus <josh@agliodbs.com>
2001-12-12 04:43 ` Andrew G. Hammond <drew@xyzzy.dhs.org>

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