Re: Réf. : save stream into blob - J. Wang - com.mysql.lists.java

6 messages in com.mysql.lists.javaRe: Réf. : save stream into blob

From	Sent On	Attachments
jean...@corman.be	01 Jul 2004 02:55
J. Wang	01 Jul 2004 03:36
Mark Matthews	01 Jul 2004 06:18
J. Wang	01 Jul 2004 23:37
Mark Matthews	02 Jul 2004 05:30
J. Wang	02 Jul 2004 06:03

Subject:	Re: Réf. : save stream into blob
From:	J. Wang (jwa...@frdc.fujitsu.com)
Date:	07/01/2004 11:37:10 PM
List:	com.mysql.lists.java

Dear Mark,

I think this problem is due to special reason but not special circumstance. This is not a occasional problem, and I found other guys also met the same
problem in some BBS discussions, but no one can tell how to fix it. I have try "saving stream into blob' on following different situations, but get
the same error.

------------------------------------------------------ Client machines ( PCs with win2000 and XP JDK 1.4.2_04) Mysql server (4.0.15-log on Redhat Linux Advanced server and 3.23.39 on Sun
solaris 8) Connector/J (3.0.14, 3.1.12a)

----------------------------------------------------

I really want to solve this problem, but I have tried all that I can do.

Could you tell me some cues? I think many other people also need this help!

Thank you very much!

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

J. Wang wrote: | But you will often meet this kind of problem as follows. | | =============================================== | java.sql.SQLException: Syntax error or access violation, message from server: " | You have an error in your SQL syntax near '?x???z???????y?5??????? | ?????EA???h1?r??Q????\\~??S????' at line 1" | | Till now, no one can solve this problem, I think this is maybe a system bug of Connector/J. | | good luck!

The driver saves big blobs all of the time by many users, and as part of the testsuite that's run every day. It would appear your particular problem is due to special circumstances. Do you have a repeatable testcase?

-Mark

- -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com

MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFA5A9JtvXNTca6JD8RAsApAJ9f8HxZeZy+khkM7iuszeHpB0NuegCfWipx cz9me9OJIXMyiagelQhG/rU= =HvxE -----END PGP SIGNATURE-----