mmmyql driver doesn't store a vector object in mysql database (changes serialized object string)

mmmyql driver doesn't store a vector object in mysql database (changes serialized object string)

Post by sebastian.muel.. » Mon, 18 Oct 1999 04:00:00



hello,

i'd appreciate any help on the problem i keep having since i'm running
out ouf ideas.
i tried to store a vector object using the mmmysql driver 1.2 and 2.0pre
in a mysql database (win32 version 3.21).
as you can imagine, the serialized vector object contains a lot of
unusual ascii characters. when i write the object to a file and read it
in using "load infile .." mysql inserts it without any problems.
using the drivers setObject() or setBinaryStream() methods not a single
character of the object reaches the database, just two ascii signs (not
contained in the serialized object string) and a lot of spaces.
to make it even worse, a result query (ResultSet rs
= executeQuery("select * from tableX")) to select this row doesn't even
return!!

if anyone could help me, i'd be glad.

thanks in advance,

sebastian

PS: i tried the original "store objects in database for persistence"
example in http://www.codeguru.com with the same result

Sent via Deja.com http://www.deja.com/
Before you buy.