导入本地Excel数据报错

-------------------------------------------------------------
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

错误已经很明显了~数据库连不上。可以检查一下所选择的那个数据源。

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

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

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

MySQL服务有启动，但就是访问不了：

没指定端口？

马拉爱跑 发表于 2020-3-11 08:43
没指定端口？

端口是默认的6688呢

如果是内置的Mysql数据库，其用户名和密码都是admin。确认下是否用户名密码错误

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

确实是。现在可以正常登陆了，谢谢你

mysql的默认端口是3306，6688是smartbi自己定的

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

是的，端口也可以自己定义。