topic Re: Activiti initial fail when deploy war to JBoss 6.2 in Alfresco Archive

Activiti initial fail when deploy war to JBoss 6.2

huntter — Tue, 31 Mar 2015 02:33:39 GMT

I'm trying to deploy an activiti based bpm application to JBoss 6.2, but unfortunately when start JBoss, it is failed due to the sql statement13:50:35,867 INFO [stdout] (Thread-94) ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'where'.13:50:35,867 INF

Re: Activiti initial fail when deploy war to JBoss 6.2

huntter — Tue, 31 Mar 2015 02:45:59 GMT

And from the activiti guide,

databaseType: it’s normally not necessary to specify this property as it is automatically analyzed from the database connection meta data. Should only be specified in case automatic detection fails. Possible values: {h2, mysql, oracle, postgres, mssql, db2}. This property is required when not using the default H2 database. This setting will determine which create/drop scripts and queries will be used. See the supported databases section for an overview of which types are supported.

It is mentioned the databaseType configuration, In general it is automatially analyzed from the database connection meta data, and I have tried to give the dedicate value mssql in the activiti configuration. but still encounter the same issue when startup.

Re: Activiti initial fail when deploy war to JBoss 6.2

huntter — Tue, 31 Mar 2015 07:07:51 GMT

I'm using the JBoss datasource, maybe this is caused by the activiti cannot parse the datasouce and get the real dataType.

Re: Activiti initial fail when deploy war to JBoss 6.2

jbarrez — Tue, 31 Mar 2015 09:26:00 GMT

> I'm using the JBoss datasource, maybe this is caused by the activiti cannot parse the datasouce and get the real dataType.

Hmm could be it, althought the metadata returned should be the same. Did you try setting the db type?

Re: Activiti initial fail when deploy war to JBoss 6.2

huntter — Wed, 01 Apr 2015 09:15:02 GMT

Yes, I set the databaseType to mssql in the spring confgiration.
<code><property name="databaseType" value="mssql" /></code>

And I have tried with a simple jsp file, it can return the correct database type from the JBoss datasource.

<code>
<%@ page import="javax.naming.InitialContext" %>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DatabaseMetaData" %>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
         pageEncoding="ISO-8859-1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <title>Insert title here</title>
</head>
<body>
<%
    InitialContext context = new InitialContext();
    DataSource dataSource = (DataSource) context.lookup("jdbc/activitiDB");
    Connection connection = dataSource.getConnection();

    DatabaseMetaData metaData = connection.getMetaData();
    String databaseProductName = metaData.getDatabaseProductName();

    out.print(databaseProductName);
%>
</body>
</html>
</code>

Re: Activiti initial fail when deploy war to JBoss 6.2

trademak — Wed, 01 Apr 2015 11:15:12 GMT

Hi,

Are you using the same DB driver in JBoss and Tomcat 7?

Best regards,

Re: Activiti initial fail when deploy war to JBoss 6.2

huntter — Thu, 02 Apr 2015 01:27:00 GMT

Really sorry about it. now I have found the root cause, this is not activiti issue or JBoss issue, in our application, they defined another datasource which only used for the data migration, and I didn,t update the databaseType to mssql consistently.

Thanks guys for all your help.

Re: Activiti initial fail when deploy war to JBoss 6.2

jbarrez — Tue, 07 Apr 2015 12:49:11 GMT

No prob, thanks for posting back your solution.