we have our own custom JDBC driver which will interpret mysql connection, but while clicking on schema we are not able to see the column names and showing the following errors

[balaji kothakota]

ERROR 2019-05-25T12:33:31,574+0000 [spotfireadmin, #5, #469] api.common.InformationModelServiceCommon: An Internal Error has occurred. Table sbtest1does not exist

com.spotfire.ws.api.common.InformationModelWebServiceException: An Internal Error has occurred. Table sbtest1 does not exist

at com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:684) ~[spotfire-server-is.jar:]

at com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:606) ~[spotfire-server-is.jar:]

at com.spotfire.ws.api.element.ElementManagerService.listDataSourceElements(ElementManagerService.java:379) ~[spotfire-server-is.jar:]

at sun.reflect.GeneratedMethodAccessor434.invoke(Unknown Source) ~[:]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[:1.8.0_201]

at java.lang.reflect.Method.invoke(Method.java:498) ~[:1.8.0_201]

at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179) ~[cxf-core.jar:3.2.6]

at org.apache.cxf.jaxws.JAXWSMethodInvoker.performInvocation(JAXWSMethodInvoker.java:66) ~[cxf-rt-frontend-jaxws.jar:3.2.6]

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) ~[cxf-core.jar:3.2.6]

at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:232) ~[cxf-rt-frontend-jaxws.jar:3.2.6]

at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:85) ~[cxf-rt-frontend-jaxws.jar:3.2.6]

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:74) ~[cxf-core.jar:3.2.6]

at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) ~[cxf-core.jar:3.2.6]

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[:1.8.0_201]

at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[:1.8.0_201]

at org.apache.cxf.interceptor.ServiceInvokerInterceptor$2.run(ServiceInvokerInterceptor.java:126) ~[cxf-core.jar:3.2.6]

at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) ~[cxf-core.jar:3.2.6]

at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:131) ~[cxf-core.jar:3.2.6]

at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308) ~[cxf-core.jar:3.2.6]

at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) ~[cxf-core.jar:3.2.6]

at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:267) ~[cxf-rt-transports-http.jar:3.2.6]

at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) ~[cxf-rt-transports-http.jar:3.2.6]

at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) ~[cxf-rt-transports-http.jar:3.2.6]

at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) ~[cxf-rt-transports-http.jar:3.2.6]

at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:216) ~[cxf-rt-transports-http.jar:3.2.6]

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:301) ~[cxf-rt-transports-http.jar:3.2.6]

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:220) ~[cxf-rt-transports-http.jar:3.2.6]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) ~[servlet-api.jar:]

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:276) ~[cxf-rt-transports-http.jar:3.2.6]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[catalina.jar:9.0.13]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.13]

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.13]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.13]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.13]

at com.spotfire.server.security.SecurityFilter$InternalFilterChain.doFilter(SecurityFilter.java:1026) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$AuthConstraintFilter.doFilter(SecurityFilter.java:925) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$InternalFilter.doFilter(SecurityFilter.java:992) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$InternalFilterChain.doFilter(SecurityFilter.java:1021) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$AuthenticationFilter.doFilter(SecurityFilter.java:338) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$InternalFilter.doFilter(SecurityFilter.java:992) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$InternalFilterChain.doFilter(SecurityFilter.java:1021) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$UserDataConstraintFilter.doFilter(SecurityFilter.java:853) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$InternalFilter.doFilter(SecurityFilter.java:992) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$InternalFilterChain.doFilter(SecurityFilter.java:1021) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$ConnectorFilter.doFilter(SecurityFilter.java:813) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$InternalFilter.doFilter(SecurityFilter.java:992) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter$InternalFilterChain.doFilter(SecurityFilter.java:1021) ~[spotfire-server.jar:]

at com.spotfire.server.security.SecurityFilter.doFilter(SecurityFilter.java:160) ~[spotfire-server.jar:]

at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:124) ~[spotfire-server.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) ~[secured-jar-with-dependencies.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) ~[secured-jar-with-dependencies.jar:]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.13]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.13]

at com.spotfire.server.security.CustomAuthFilterWrapper.doFilter(CustomAuthFilterWrapper.java:89) ~[spotfire-server.jar:]

at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:124) ~[spotfire-server.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) ~[secured-jar-with-dependencies.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) ~[secured-jar-with-dependencies.jar:]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.13]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.13]

at com.spotfire.server.security.CsrfFilter.doFilter(CsrfFilter.java:74) ~[spotfire-server.jar:]

at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:124) ~[spotfire-server.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) ~[secured-jar-with-dependencies.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) ~[secured-jar-with-dependencies.jar:]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.13]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.13]

at com.spotfire.server.security.HttpMethodsFilter.doFilter(HttpMethodsFilter.java:192) ~[spotfire-server.jar:]

at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:124) ~[spotfire-server.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) ~[secured-jar-with-dependencies.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) ~[secured-jar-with-dependencies.jar:]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.13]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.13]

at com.spotfire.server.security.headers.HeadersFilter.doFilter(HeadersFilter.java:257) ~[spotfire-server.jar:]

at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:124) ~[spotfire-server.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) ~[secured-jar-with-dependencies.jar:]

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) ~[secured-jar-with-dependencies.jar:]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.13]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.13]

at com.spotfire.server.security.AccessLogFilter.doFilter(AccessLogFilter.java:73) ~[spo

[Seema Krishnani]

Are you able to use your custom JDBC driver to connect to the database using the third party tool like DBvisulaizer

You can find the sample data source templates at the below link

https://community.spotfire.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details

[balaji kothakota]

yes we connected custom JDBC driver to database using DBVisualizer, jar is working fine there