Description of problem: We see this error: 2015-09-15 15:48:46,897 ERROR \[org.jboss.dashboard.error.ErrorManager\] (ServerService Thread Pool -- 80) UNEXPECTED ERROR. Error id='1442324926895' Error date='9/15/15 3:48 PM' java.lang.ClassNotFoundException: oracle.sql.BLOB from [Module "deployment.teiid-dashboard-builder.war:main" from Service Module Loader] at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134) Version-Release number of selected component (if applicable): 6.2 How reproducible: Always Steps to Reproduce: 1. Install JDV 6.2 over an existing EAP 6.4 2. In domain.xml replace h2 datasource for Dashboard with an oracle datasource 3. Error arise in deployment time Actual results: java.lang.ClassNotFoundException: oracle.sql.BLOB from [Module "deployment.teiid-dashboard-builder.war:main" from Service Module Loader] Expected results: Dashboard correctly deployed Additional info: It can be fixed adding Oracle driver dependency in jboss-deployment-structure.xml inside teiid-dashboard-builder.war
Can you confirm your issue if you follow the dashboard builder directions [1]. I realize these are for wildfly, but they still apply here. Additionally, these are directions that I plan on getting added to the DV doc's for configuring dashboard builder. [1] https://github.com/droolsjbpm/dashboard-builder/tree/master/builder/src/main/wildfly8#preparing-the-environment-for-running-the-dashboard-builder
Yes, I confirm; against Oracle, I dont know against Postgresql. But I have found in same documentation the correct way of prepare it. It is in eap 6.4 documentation. I guess that dashbuilder over wildfly will need same dependency that over EAP 6.4. The part that is missing in wildfly docs: " Modify the file dashboard-builder/builder/src/main/eap6_4/WEB-INF/jboss-deployment-structure.xml. Add the following snippet of configuration inside the deployment tag, where jdbcDriverModuleName is the name of the JBoss JDBC driver module. <dependencies> <module name="jdbcDriverModuleName" /> </dependencies> " just before explanation about configuration when different schemas exit in db. [1] https://github.com/droolsjbpm/dashboard-builder/tree/master/builder/src/main/eap6_4
Is this an installer issue? Does the installer need to add the aforementioned elements to the DV configuration?
It works. However it would not work for other databases. This should be documented. Something like "If a user wants to use different data source for dashboard builder, he must add a JDBC driver module name into the jboss-deployment-structure.xml in teiid-dashboard-builder.war."
Adding documentation component since the installer related portion of this BZ is solved.