RE: [Csvjdbc-develop] New features in CSVJDBC

[Jason B. <jas...@di...>]

My two cents in regard to the transaction support: MySQL does not
support transactions. The highly popular MM driver for MySQL (probably
used for at least 99% of all JDBC connections to MySQL) will just ignore
any method, without exception, that pertain to transactions. This seems
to be a highly standard behavior for jdbc drivers.

The work around is the developer must call, in this instance,
Connection.getTransactionIsolation() and if the return value equals
Connection.TRANSACTION_NONE then the database does not support
transactions according to the JDBC 3.0 spec. Therefore the developer
does not make the Connection.setTransactionIsolation(int) call.

-----Original Message-----
From: Tomasz Skutnik [mailto:Tom...@e-...]=20
Sent: Thursday, February 13, 2003 8:11 AM
To: csvjdbc-develop
Subject: Re: [Csvjdbc-develop] New features in CSVJDBC


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

John Walker wrote:
|
| Actually, what you did, did solve the first round of problems.  But=20
| now I have this additional problem, so I still cannot use it.  So, I=20
| was just saying that if the changes you guys made are not needed by=20
| anyone, you can put the other version up there if you want, I=20
| understand.  But, on the other hand, if someone changes the driver to=20
| ignore the methods for transaction syncronization, I will work with=20
| it, and if it works, I will let developers know of this tool, and it=20
| will get used.
|
| Thanks so much for listening to me, and trying to accomodate.  One of=20
| these days, I am sure I will have to start coding in Java...
|

Ok, I'll try to spare some time next week, but can't promise anything.

See ya.

- --

Tomasz Skutnik, R&D Director, www.e-point.pl
tel +48 (22) 853 48 30, mob +48 501 555 705, fax +48 (22) 853 48 30
e-point S.A., ul. Filona 16, 02-658 Warsaw, Poland PGP/GPG public key:
http://scooter.ext.e-point.pl/tomasz.skutnik.gpg
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+S6eGZe1f4n3990IRAnx9AKCjODOKeYRxCYPPLLEISC1sr/MGhwCfe3fR
PfPaJai5xkEMqnxVFbB8Syo=3D
=3DaUiI
-----END PGP SIGNATURE-----



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf _______________________________________________
Csvjdbc-develop mailing list Csv...@li...
https://lists.sourceforge.net/lists/listinfo/csvjdbc-develop