首页 文章

从docker容器上运行的jasperserver sqlserver连接失败了吗?

提问于
浏览
0

我在docker容器上运行jasperserver-pro(trail版本)运行正常 . 我在azure Cloud 上有一个sqlserver . 当我尝试创建从在docker容器上运行的jasperserver到sqlserver的连接时,我无法连接 .

我下载了mysql jdbc驱动程序并上传到jasperserver . 以下是错误 .

java.sql.SQLNonTransientConnectionException:无法连接到buyeatest2sqldwserver.database.windows.net:1433:在org.mariadb.jdbc的org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:123)处重置连接.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)位于java.sql.DriverManager的java.sql.DriverManager.getConnection(未知来源)的org.mariadb.jdbc.Driver.connect(Driver.java:110)位于org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)的.getConnection(未知来源)位于com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java: 36)在org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)org.apache.commons.pool.imp.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)org.apache.commons.dbcp上的org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) .PoolingDataSource.getConnection(P oolingDataSource.java:106)com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.testConnection(JdbcDataSourceService.java:85)at com.jaspersoft.jasperserver.remote.connection.JdbcConnectionStrategy.createConnection(JdbcConnectionStrategy . java:75)com.jaspersoft.jasperserver.remote.connection.JdbcConnectionStrategy.createConnection(JdbcConnectionStrategy.java:55)at com.jaspersoft.jasperserver.remote.connection.ConnectionsManager.createConnection(ConnectionsManager.java:88)at com.jaspersoft .jasperserver.jaxrs.connection.ConnectionsJaxrsService.createConnection(ConnectionsJaxrsService.java:90)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(来自com.sun.jers上的com.sun.jersey.spi.container.JavaMethodInvokerFactory $ 1.invoke(JavaMethodInvokerFactory.java:60)的java.lang.reflect.Method.invoke(未知来源)的未知来源ey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider $ ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75 )com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) )com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) )com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)at com . com.sun.jersey.server上的sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) .impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)位于com.sun.jersey.spi.container.servlet的com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) .ServletContainer.service(ServletContainer.java:558)位于com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)的javax.servlet.http.HttpServlet.service(HttpServlet.java:729) )org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)org.apache.tomcat.websocket.server . 位于org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)的wsFilter.doFilter(WsFilter.java:52)org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)at org .owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88)at com.jaspersoft.jasperserver.api.security.csrf.JSC srfGuardFilter.doFilter(JSCsrfGuardFilter.java:72)at atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)org.apringframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:240)org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atg.appasoftoft.jasperserver.api.security.csrf.CrossDomainCommunicationFilter.doFilter(CrossDomainCommunicationFilter.java:116)org位于org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain .java:240)atg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)at com.jaspersoft.ji.jaxrs.diagnostic.DiagnosticLoggingFilterPRO.doFilter(DiagnosticL) ogFpeterPRO.java:43)org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)org.apringframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)atg.apache.catalina位于org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java)的org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207).core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) :330)org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)at at org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)at o rg.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)位于org.springframework.security.web的org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) . FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)atg.springframework.security.web.FilterChainProxy VirtualFilterChain.doFilter(FilterChainProxy.java:342)位于org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)的com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:99) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)org.springframework.security.web.FilterChainProxy $ Virtua lFilterChain.doFilter(FilterChainProxy.java:342)位于org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)的com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:194) .springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)atg.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter (UserPreferencesFilter.java:235)在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)在org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.j) ava:43)在org.springframework.security.web的org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) .FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235)atorg.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)位于org.springframework.security的com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) . web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80)at org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter( FilterChainProxy.java:342)位于org.springframework.web的org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)的com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) .filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)atg.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter (Encry ptionFilter.java:150)org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)at org .springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:86)at org.springframework.security.web.FilterChainProxy $ VirtualFilterChain .doFilter(FilterChainProxy.java:342)在org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)在org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)在有机在org.apache.catalina.core.ApplicationFilterChain.internalDo的org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)上的springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)过滤器(ApplicationFilterChain.java:240)维持在com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63)org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)在组织位于org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain的.java:240)在org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)在com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)在org.springframework . web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)位于org.apache.catalina.core.ApplicationFilterChain.internalDoFi的org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) lter(ApplicationFilterChain.java:240)位于org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)的com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:77)at org位于org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain的.java:240)在org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)在com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43)在org.apache.catalina . core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)在o rg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)在org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:616)在org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:141)在org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)在org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)在Org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)org.apache.coyote.http11.AbstractHttp11Processor.process(在org.apache.coyote.AbstractProtocol $ AbstractConnectionHandler.process(AbstractProtocol.java:684)org.apache.tomcat.util.net.AprEndpoint $ SocketProcessor.doRun(AprEndpoint.java:2521)org上的AbstractHttp11Processor.java:1132) .apache.tomcat.util.net.AprEndpoint $ SocketProcessor.run(AprEndpoint.java:2510)at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)at java.util.concurrent.ThreadPoolExecutor $ Worker.run(Unknown Source )atg.apache.tomcat.util.threads.TaskThread $ WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Unknown Source)引起:org.mariadb.jdbc.internal.util.dao .QueryException:无法连接到buyeatest2sqldwserver.database.windows.net:1433:在org.mariadb.jdbc.internal.protocol.AbstractConnectProtoco重置连接l.handleConnectionPhases(AbstractConnectProtocol.java:439)位于org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:351)org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java: 664)org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:587)org.mariadb.jdbc.Driver.connect(Driver.java:105)... 134更多引起:java . net.SocketException:java.io.BuedInputStream.read1上的java..S.InputStream.read(未知源)java.net.SocketInputStream.read(未知源)处的java.net.SocketInputStream.read(未知源)连接重置(未知来源)位于org.mariadb.jdbc.internal.packet的org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.getReusableBuffer(ReadPacketFetcher.java:83)的java.io.BufferedInputStream.read(未知来源) . read.ReadInitialConnectPacket . (ReadInitialConnectPacket.java:86)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handle ConnectionPhases(AbstractConnectProtocol.java:399)...... 138更多

1 回答

  • 0

    您需要使用Microsoft JDBC Driver for SQL Server连接到Jasper Server的SQL Azure数据库 . 请访问this文档 .

    现在this Jasper Soft的文章专门用于Azure SQL数据源 .

    希望这可以帮助 .

相关问题