[ https://forge.continuent.org/jira/browse/CAROB-128?page=all ]
Gilles Rayrat resolved CAROB-128:
---------------------------------
Resolution: Won't Fix
This mysql specific type is returned as a BigInteger java type by mysql.
With java driver, there is no problem because it is using java deserialization
Carob just can't deserialize unknown java objects
The only way to fix this would be to hack sequoia code to implement BigIntegers
serialization, which will probably not be done as it is a mySQL specific issue
with a simple workaround:
_don't use bigint unsigned data type_
> MySQL's bigint unseigned column type not supported
> --------------------------------------------------
>
> Key: CAROB-128
> URL: https://forge.continuent.org/jira/browse/CAROB-128
> Project: Carob
> Type: Bug
> Versions: Carob 0.7.2
> Environment: Sequoia 2.10.5, Carob 0.7.2
> Reporter: Raúl
> Assignee: Gilles Rayrat
>
>
> If you try to define a bigint column type in a table, Carob (not sequoia)
> fails giving a Deserialization error. Example to reproduce the error:
> CREATE TABLE temp (
> id bigint(20) unsigned,
> dest varchar(25)
> );
> INSERT INTO temp VALUES (1507,"666");
> SELECT id FROM temp WHERE dest='666';
> In this last "SELECT", Carob complains about a Deserialization error, thing
> that not happen with JDBC/Sequoia or if you define id in the table temp like
> "int". I tried to investigate more about this problem, but i have no idea
> about Java, and all the problems point to JDBC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
