For the other problems, I need time to investigate, and I don't have
any for now - sorry
Mihai Costache wrote:
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=""#000000">_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
|
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
