Does BPMS 6.0.x support Sybase database (version 15.7.0) ?
Issue
- While using
BPMS 6.0.xwithSybase ASE 15.7.0database thebusiness-central.wardeploys nicely and works fine too, but in case ofdashbuilder.warit 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.warapplication seems to be hardcoded in thedashbuidercode, more specifically in the classorg.jboss.dashboard.database.hibernate.HibernateInitializer. For reference, here is the code snippet fromorg.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 6completely onSybase 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, tools, and much more.