Re: [gnome-db] Meta Store issue with MySQL.

2009/7/30 Bas Driessen <[email protected]>

>  Hello,
>
> My database is in MySQL. When I run the following command to rebuild the
> MetaStore (which lives in a sqlite3 database):
>
> gda_connection_update_meta_store(connection, NULL, &error)
>
> I get the following error/warning:
>
> ** (process:22406): WARNING **: (+5): Wrong Holder value type, expected
> type 'boolean' when value's type is 'string' (Provider ThreadWrapper)
>
>
> and the MySQL table information is not in the MetaStore. In fact if I do:
>
> select * from _tables;
>
> nothing shows up.
>
> Anyone else having this problem?
>

The reason for this error is that a SELECT statement internally run by the
MySQL provider to get meta data returned a column of type string instead to
a boolean. To solve this, the correction consists in locating the faulty
SELECT, and use gda_connection_statement_execute_select_full() with an array
of expected types for the columns instead of
gda_connection_statement_execute_select(). This is already done at several
places in gda-mysql-meta.c.

If you want to try to correct it, and if you are in the master branch, you
can use the definitions in libgda/providers-support/gda-meta-column-types.h
(which is dynamically generated).

Otherwise, I'd need to have more information to correct the problem myself.

Vivien

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list