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="jdbc:mysql://mysqlserver:3306/database?tinyInt1isBit=false > > > > > > > > > > > > > > > > Cheers, > > > > Gilles. > > > > > > _______________________________________________ > > > Carob mailing list > > > [email protected] > > > https://forge.continuent.org/mailman/listinfo/carob > > >
_______________________________________________ Carob mailing list [email protected] https://forge.continuent.org/mailman/listinfo/carob
