topic Re: Does Activiti support Teradata database? in Alfresco Forum

Does Activiti support Teradata database?

vamshidharjvr — Wed, 04 Jan 2017 12:07:27 GMT

I'm using Activiti 5.22 and I tried to change the default h2 database to Teradata by modifying the db.properties in the folder webapps\activiti-explorer\WEB-INF\classes as:db=teradatajdbc.driver=com.teradata.jdbc.TeraDriverjdbc.url=jdbc:teradata://10.200.4.116;DB_CLOSE_DELAY=1000jdbc.username=****jd

Re: Does Activiti support Teradata database?

jeenut — Wed, 04 Jan 2017 14:26:05 GMT

I am facing the same issue. Can somebody please help.

Re: Does Activiti support Teradata database?

romschn — Thu, 05 Jan 2017 09:51:30 GMT

The following link points to the supported stack for Activiti Suite 1.0 https://www.alfresco.com/cmis/views/workspace%253A%252F%252FSpacesStore%252F0498cae2-14e5-400e-bccc-528df364eeff , Under Database section, I couldn't see Teradata as an option.

Hope this helps.

Re: Does Activiti support Teradata database?

vamshidharjvr — Thu, 05 Jan 2017 10:31:15 GMT

Is there any similar documentation for activity 5.x? I couldn't find Teradata in supported databases in user guide.
Is there any work around to connect activiti with databases other than those mentioned in the user guide?

Re: Does Activiti support Teradata database?

jearles — Tue, 10 Jan 2017 22:59:45 GMT

The supported platform for all Alfresco Services can be found here: Supported Platforms | Alfresco.
Also, I was unable to find any cases in Activiti that utilized an unsupported database. I did however, find a case of using Teradata with Hibernate, though: JAVAVikings: Using Hibernate with TeraData - which is the underlying JPA system that Activiti uses.

There is a possibility that with the appropriate JDBC drivers, and selecting the TeradataDialect for your hibernate.dialect in the activiti-app.properties, this might work. Check to make sure you have the TeraData drivers in your build, if you haven't.

Best of luck.
JEarles
bp3