Increase Column size of OOTB table

[former_member646143]

Can anybody provide me the groovy script for ALTER table

[mpern]

Downvote:

• no description what you want to do

• you can solve this question yourself in 5min on google and/or searching here

[former_member646143]

I need groovy script to ALTER the OOTB column size

[arvind-kumar_avinash]

Hi - I believe, you are looking for a Groovy script to alter the database table. Please try the following and let me know if it works:

  import de.hybris.platform.core.Registry
  
  conn = Registry.getCurrentTenant().getDataSource().getConnection()
  stmt = conn.createStatement()
  ddlQuery = "YOUR SQL ALTER COMMAND"
  stmt.executeUpdate(ddlQuery)

[Former Member]

Hi Mohammed , You can do like coulmntype in items .xml

                         <columntype database="oracle">
                             <value>CLOB</value>                    
                         </columntype>
                         <columntype database="sqlserver">
                             <value>nvarchar(max)</value>
                         </columntype>
                         <columntype database="mysql">
                             <value>TEXT</value>
                         </columntype>
                         <columntype>
                             <value>HYBRIS.LONG_STRING</value>
                         </columntype>
                     </persistence>

thanks, prabhakar

[former_member646143]

Thanks Prabhakar,

Can you provide me the groovy script if you have so that i can directly ALTER the column size in DB