From: Jason B. <jas...@di...> - 2003-02-18 20:52:29
|
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 |