Does BPMS 6.0.x support Sybase database (version 15.7.0) ?

Solution Unverified - Updated -

Issue

  • While using BPMS 6.0.x with Sybase ASE 15.7.0 database the business-central.war deploys nicely and works fine too, but in case of dashbuilder.war it throws the following ERROR.
ERROR [org.jboss.dashboard.annotation.StartableProcessor] (ServerService Thread Pool -- 56) Error starting bean org.jboss.dashboard.database.hibernate.HibernateInitializer$Proxy$_$$_WeldClientProxy: java.lang.Exception: The underlying database is unknown or the system is unable to recognize it.
  • The issue is specifically with the BAM (dashboard) module. When configured with a Sybase JDBC driver, the aforementioned error happens at start-up.
  • The list of supported databases for dashbuilder.war application seems to be hardcoded in the dashbuider code, more specifically in the class org.jboss.dashboard.database.hibernate.HibernateInitializer. For reference, here is the code snippet from org.jboss.dashboard.database.hibernate.HibernateInitializer
...
    public String inferDatabaseName(DataSource ds) throws Exception {
        Connection connection = null;
        try {
            connection = ds.getConnection();
            String dbProductName = connection.getMetaData().getDatabaseProductName().toLowerCase();
            if (dbProductName.contains("h2")) return DB_H2;
            if (dbProductName.contains("postgre") || dbProductName.contains("enterprisedb")) return DB_POSTGRES;
            if (dbProductName.contains("mysql")) return DB_MYSQL;
            if (dbProductName.contains("oracle")) return DB_ORACLE;
            if (dbProductName.contains("microsoft") || dbProductName.contains("sqlserver") || dbProductName.contains("sql server")) return DB_SQLSERVER;
            if (dbProductName.contains("db2")) return DB_DB2;
            if (dbProductName.contains("teiid")) return DB_TEIID;
        } finally {
            if (connection != null) {
                connection.close();
            }
        }
        return null;
    }
...
  • What is the status of supporting BPMS 6 completely on Sybase ASE ?

Environment

  • Red Hat JBoss BPM Suite (BPMS)
    • 6.0.1
  • Sybase ASE (Sybase)
    • 15.7.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.