Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Etat HTTP 500 - java.lang.AbstractMethodError:org.apache.tomcat.dbcp.dbcp.PoolingDataSource....

+1 vote
1 view

I defined a MySQL datasource type jndi, and I created a business model, then when I try to configure the META WEB ,this error appear :

java.lang.AbstractMethodError:org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getSchema()Ljava/lang/String;

description: The server encountered an internal error that did prevented from satisfying the query.

exception :

org.jboss.resteasy.spi.UnhandledException: java.lang.AbstractMethodError: org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getSchema()Ljava/lang/String;
	org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(ExceptionHandler.java:78)
	org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler.java:222)
	org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:171)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:414)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
	org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

cause :

java.lang.AbstractMethodError: org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getSchema()Ljava/lang/String;
	it.eng.spagobi.utilities.database.MySQLDataBase.getSchema(MySQLDataBase.java:126)
	it.eng.spagobi.api.v2.DataSourceResource.getTableMetadata(DataSourceResource.java:367)
	it.eng.spagobi.api.v2.DataSourceResource.getDataSourceStruct(DataSourceResource.java:329)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
	org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
	org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
	org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
	org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Environment knowage 6.2 CE + windows 10 + mysql 5.5 + google chrome
in Business Model by (260 points)

We are having the same issue.

by (210 points)

1 Answer

0 votes

I was able to solve this by adjusting the JDBC resource configuration in the server.xml file.

Add the factory setting in front of the type setting:

          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" type="javax.sql.DataSource"

by (210 points)
Powered by Question2Answer
...