topic Re: Activiti Spring boot Table names in Alfresco Forum

Activiti Spring boot Table names

deepak90210 — Wed, 23 Aug 2017 09:28:37 GMT

Hi All,I am using spring boot activiti integartion in my app.I am facing a problem. I want the activiti table names to be created in lowercase by default. Is there any configuration way to make this happen? I have tried using ImprovedNamingStrategy of hibernate to achieve this only to realize that a

Re: Activiti Spring boot Table names

ryandawson — Thu, 24 Aug 2017 17:13:30 GMT

I guess what you're encountering is how the engine has classes Activiti/DbSqlSession.java at 6.0-release · Activiti/Activiti · GitHub to run SQL files Activiti/modules/activiti-engine/src/main/resources/org/activiti/db/create at 6.0-release · Activiti/Activiti · GitHub . The only way I can see to change that would be to make a change to the engine code to support a case-change property.

Re: Activiti Spring boot Table names

deepak90210 — Mon, 28 Aug 2017 15:26:56 GMT

Thanks a lot Ryan, I get what you mean and so i wanna know if there is a way to skip the table creation altogether?

I'll give you a background of the problem. My application on production utilizes RDS Mysql as the database. It does not allow me to create upper case table names. However, this does not pose any issue with activiti. Everything runs fine. It's only when i try to take a dump of my prod data and try to restore in dev environment that i lose activiti data.

So if we can skip the table creation please let me know otherwise is it possible to include a case sensitive property in a future release?

Re: Activiti Spring boot Table names

ryandawson — Mon, 28 Aug 2017 15:42:22 GMT

If that's why the lowercase is causing you a problem then have you looked at whether you could run a SQL script to convert the names of all the tables in the database to uppercase? It might be possible to do that by script without needing to hard-code the table names (though in this case hard-coding is also an option, just a bit laborious).