How to increase the column size of the string collection

[Former Member]

I have string collection as "NameCollection". When I am trying to import product with large value for this collection type, error was thrown as column size is small. Please help to solve this error.

[Former Member]

Hello all,

There is one additional point that might be worth to mention. As per other thread https://answers.sap.com/questions/12759895/system-update-does-not-change-type-of-column.html

Once the column type definition has been taken into effect in items.xml, it is not possible change the column type once it has already been created.

"redeclaring attributes" hand in hand with "item type sub-typing" functionality does work to such as, e.g. you can add a ''unique'' flag, disallow writing etc.

make the type of the attribute more specific (only subtypes can be used here)

https://help.hybris.com/6.0.0/hcd/8bffa9cc86691014bb70ac2d012708bc.html

See "Redeclaring Attributes" section for details

Only for modifying DB column type it does no work. You do need to run an alter table in DB server level.

kind regards

Le Li

[Former Member]

you can do this with groovy.

import groovy.sql.Sql sql = Sql.newInstance("jdbc:oracle:thin:localhost", "username", "password", "oracle.jdbc.driver.DatabaseDriver") sql.execute("alter table XYZTable modify p_name varchar(4000)")

[Former Member]

You could do this in *items.xml definition or you could do this with direct SQL (alter...) In *items.xml you can do this with columntype element (https://wiki.hybris.com/display/release5/items.xml+-+5.1.1) . This would require update running system. Advantage with direct SQL is that you can execute it directly.