[odb-users] Re: Problem loading long TEXT strings with MySQL

[Andreas Gerasch]

Hi Boris,

just for completion, below is the console output of my 1.8.0 test. The 
first call of driver contains the code for creating the objects. The 
second call of driver does not contain this code, it only loads the 
objects from the database.

As you can see, there is no problem with long strings in last name of 
person (both long strings (nnnn and jjjj) have the same length of 512.


Andreas

gerasch at nina:/staff/gerasch/downloads/odb-examples-1.8.0/hello$ ./driver 
--user gerasch --database odb_test --password Regenbogen
Hello, John 
nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 
Doe!
Hello, Jane Janette Doe!
Hello, Joe Dalton 
jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj!

gerasch at nina:/staff/gerasch/downloads/odb-examples-1.8.0/hello$ vim 
driver.cxx

gerasch at nina:/staff/gerasch/downloads/odb-examples-1.8.0/hello$ make
make  all-am
make[1]: Entering directory 
`/staff/gerasch/downloads/odb-examples-1.8.0/hello'
depbase=`echo driver.o | sed 's|[^/]*$|.deps/&|;s|\.o$||'`;\
	g++ -DHAVE_CONFIG_H   -I'.' -I'.' -DDATABASE_MYSQL     -DQT_SHARED 
-I/usr/include/qt4 -I/usr/include/qt4/QtCore     -g -O2  -MT driver.o 
-MD -MP -MF $depbase.Tpo -c -o driver.o driver.cxx &&\
	mv -f $depbase.Tpo $depbase.Po
/bin/bash ../libtool --tag=CXX   --mode=link g++  -g -O2    -o driver 
driver.o person-odb.o  -lodb-mysql -lQtCore   -lodb-boost 
-lboost_date_time -lboost_system -lodb  -lpthread
libtool: link: g++ -g -O2 -o driver driver.o person-odb.o 
/usr/local/lib/libodb-mysql.so -lQtCore /usr/local/lib/libodb-boost.so 
-lboost_date_time -lboost_system /usr/local/lib/libodb.so -lpthread
make[1]: Leaving directory 
`/staff/gerasch/downloads/odb-examples-1.8.0/hello'


gerasch at nina:/staff/gerasch/downloads/odb-examples-1.8.0/hello$ ./driver 
--user gerasch --database odb_test --password Regenbogen
Hello, John 
nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnin1_germ
John" 
order="German Duden"/>
   <collation name="latin1_swedish_ci"	id="8"	order="Finnish, Swedish">
     <flag>primary</flag>
     <flag>compiled</flag>
   </collation>
   <collation name="latin1_danish_ci"	id="15"	order="Danish"/>
   <collatio Doe!
Hello, Jane Janette Doe!
Hello, Joe Dalton 
jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj!


On 02/10/2012 10:07 AM, Boris Kolpackov wrote:
> Hi Andreas,
>
> Andreas Gerasch<gerasch at informatik.uni-tuebingen.de>  writes:
>
>> After using the odb-examples.tar.gz, I was able to reproduce the problem
>> using your hello example by introducing a vector of middle names.
>
> I tried the code you have attached with ODB 1.8.0 and it works without
> any problems. I don't have the 1.7.0 build around, so could you try
> this test with 1.8.0 on your setup? While I don't believe we fixed this
> specific issue in 1.8.0, we might have made some changes that fixed it
> indirectly.
>
> If it still fails for you with 1.8.0, I will need more information about
> your setup. Specifically, which version of the MySQL client library you
> are using (dpkg -s libmysqlclient-dev) as well as the version of the
> MySQL server you are connecting to.
>
> Boris
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gerasch.vcf
Type: text/x-vcard
Size: 435 bytes
Desc: not available
Url : http://codesynthesis.com/pipermail/odb-users/attachments/20120210/4626c1b7/gerasch.vcf