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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
