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
