Re: [OJB-developers] "tests" target results against MySql

[<ri...@ya...>]

Florian,

I fixed the db-setup.sql file, as you suggested, but kept getting =
errors.

So, I added these type changes to those you suggested:

In OJB_DMAP_ENTRIES:
   VALUE_OID to BLOB

In OJB_DMAP_ENTRIES:
    KEY_OID to BLOB
    VALUE_OID to BLOB

In BLOB_TEST:
    CLOB_VALUE_ to LONGTEXT
(LONGCLOB, as you suggested, doesn't seem to be a valid MySql type, so I =
tried using LONGTEXT for the CLOB_VALUE_ in the BLOB_TEST column)


The tests target now runs fine!

The junit target gives me the same 2 failures I previously reported.

Thomas, these changes to the db-setup.sql file should be included in the =
distribution...

I'll run the performance target now... I'll keep you guys informed.

Thanks,

Ricardo Arguello


----- Original Message -----=20
From: "Florian Bruckner" <bf...@fl...>
To: "ojb" <obj...@li...>
Sent: Wednesday, February 27, 2002 5:03 AM
Subject: RE: [OJB-developers] "tests" target results against MySql


> Hi Ricardo,
>=20
> You can easily fix these yourself by editing the file
> src/test/setup/db-setup.sql.
>=20
> For the table blob_test change the type of the column BLOB_VALUE_ to
> LONGBLOB and of the columne CLOB_VALUE to LONGCLOB.
>=20
> For the tables ojb_nrm, ojb_dlist_entries, ojb_dset_entries the type =
of the
> column OID_ should be changed to BLOB.
>=20
> For ojb_dmap_entries the type of the column KEY_OID should be BLOB.
>=20
> Concerning the testEscaping testcase. Just looked this up in the mysql =
docs
> and there it says that the behaviour is expected. For VARCHAR columns
> trailing spaces get stripped, see also
> =
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#=
Col
> umn_types. Informix' behaviour is the same.
>=20
> best regards,
> Florian
>=20
>=20
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>