麦粉社区
>
帖子详情

导入本地Excel数据报错

数据连接 发表于 2020-3-10 11:32
发表于 2020-3-10 11:32:59
510595e670a36729ec.png

406585e670a488eec6.png

-------------------------------------------------------------
SQL错误:Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at smartbi.connectionpool.ConnectionPool$5.createConnection(ConnectionPool.java:725)
        at ...(...)
        at smartbi.connectionpool.ConnectionPool$5.createConnection(ConnectionPool.java:719)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:357)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2482)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.GeneratedConstructorAccessor130.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
        at smartbi.connectionpool.ConnectionPool$5.createConnection(ConnectionPool.java:719)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
        at smartbi.connectionpool.ConnectionPool$6.makeObject(ConnectionPool.java:777)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
        at smartbi.connectionpool.ConnectionPool$4.borrowObject(ConnectionPool.java:680)
        at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
        at smartbi.connectionpool.ConnectionPool.driverConnect(ConnectionPool.java:336)
        at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:496)
        at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:461)
        at smartbi.freequery.util.sftp.CopyCSVToDBUtil.getConnection(CopyCSVToDBUtil.java:213)
        at smartbi.datapackage.importer.BaseImporter.isTableExists(BaseImporter.java:1147)
        at smartbi.datapackage.importer.BaseImporter.assertName(BaseImporter.java:1011)
        at smartbi.datapackage.importer.BaseImporter.assertInput(BaseImporter.java:327)
        at smartbi.datapackage.importer.BaseImporter.doImport(BaseImporter.java:131)
        at smartbi.datapackage.service.DataPackageService.insertData(DataPackageService.java:704)
        at smartbi.datapackage.DataPackageServlet.processRequest(DataPackageServlet.java:204)
        at smartbi.datapackage.DataPackageServlet.service(DataPackageServlet.java:106)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
        at smartbi.extension.Extension.processMatchServlet(Extension.java:473)
        at smartbi.extension.ExtensionFilter.processInternal(ExtensionFilter.java:209)
        at smartbi.extension.ExtensionFilter.access$000(ExtensionFilter.java:42)
        at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:159)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:149)
        at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:106)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:149)
        at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:69)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:149)
        at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:172)
        at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:62)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:61)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2575)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2564)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.DualStackPlainSocketImpl.connect0(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:589)
        at java.net.Socket.connect(Socket.java:538)
        at java.net.Socket.<init>(Socket.java:434)
        at java.net.Socket.<init>(Socket.java:244)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:307)
        ... 62 more


发表于 2020-3-10 12:12:18
错误已经很明显了~数据库连不上。可以检查一下所选择的那个数据源。
768045e671398d8b5a.png
回复

使用道具 举报

发表于 2020-3-10 14:27:36
Jaylin 发表于 2020-3-10 12:12
错误已经很明显了~数据库连不上。可以检查一下所选择的那个数据源。

432505e67334753705.png

默认的数据库密码不是 manager  么?一直提示不对的?
回复

使用道具 举报

发表于 2020-3-10 15:35:55
Jaylin 发表于 2020-3-10 12:12
错误已经很明显了~数据库连不上。可以检查一下所选择的那个数据源。

MySQL服务有启动,但就是访问不了:
811815e67432026fa3.png


103975e6743597ca16.png
回复

使用道具 举报

发表于 2020-3-11 08:43:16
没指定端口?
回复

使用道具 举报

发表于 2020-3-11 09:40:13

端口是默认的6688呢
回复

使用道具 举报

发表于 2020-3-11 09:53:55
如果是内置的Mysql数据库,其用户名和密码都是admin。确认下是否用户名密码错误
回复

使用道具 举报

发表于 2020-3-11 10:33:17
Jaylin 发表于 2020-3-11 09:53
如果是内置的Mysql数据库,其用户名和密码都是admin。确认下是否用户名密码错误 ...

确实是。现在可以正常登陆了,谢谢你
回复

使用道具 举报

发表于 2020-3-11 14:31:30
mysql的默认端口是3306,6688是smartbi自己定的
回复

使用道具 举报

发表于 2020-3-13 11:18:06
马拉爱跑 发表于 2020-3-11 14:31
mysql的默认端口是3306,6688是smartbi自己定的

是的,端口也可以自己定义。
回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表