Re: libmysequoia and INNER JOIN

ok ... so only option to hack the sequoia code can help me

and with the three weird thing from the yesterday post ? only 1/ (too long time execution for create table) and 2/ (the error on table alteration) because 3/ i suppose is related to this unsigned type issue.

thanks,
Mihai


On Wed, 2007-04-11 at 10:58 +0200, Gilles Rayrat wrote:

Yes but unsigned is not a standard sql type, it is only used by mysql

So you have the class org.continuent.sequoia.controller.backend.SequoiaBackendObjectConverter that can be used to convert objects from the backend.
Check javadocs for more info

Gilles.

Mihai Costache wrote:

i search on mysql site about unsigned attribute and mysql connector/j .... and it is supported


On Wed, 2007-04-11 at 10:46 +0300, Mihai Costache wrote:

yes i have tinyint1isBit=false in the backend url ... "getLargeData: Value at row 0 column 2 is not of type blob, clob or byte array" problem !!!

removing unsigned is not an option because this is a supplementary protection rule for the values to be always positive numbers
so ... how must hack the sequoia code and how difficult is that


thanks,
mihai

On Wed, 2007-04-11 at 09:24 +0200, Gilles Rayrat wrote:

OK, this is the problem:
>  `IdmerchantPS` bigint(20) unsigned NOT NULL default '0',

The bigint unsigned is weirdly handled by mysql, which returns a BigInteger java type instead of a regular BigDecimal.
The quickest workaround is to remove this 'unsigned'
If you can't, you will have to hack sequoia code in order to cast BigInteger to BigDecimals in ResultSet retrieval

Second potential issue:

  `Enabled` tinyint(1) NOT NULL default '0',

Did you put tinyint1isBit=false in the backend url of you vdb.xml ?

ie:
url=""
      

Cheers,
Gilles.

_______________________________________________
Carob mailing list
Carob-RyYwo1q5J+pm4DMUGMHt/jIQnlzKTOB+HZ5vskTnxNA@xxxxxxxxxxxxxxxx
https://forge.continuent.org/mailman/listinfo/carob
    

_______________________________________________
Carob mailing list
Carob-RyYwo1q5J+pm4DMUGMHt/jIQnlzKTOB+HZ5vskTnxNA@xxxxxxxxxxxxxxxx
https://forge.continuent.org/mailman/listinfo/carob