janelee2 / datamining Goto Github PK

2021-05-12 16:20:22.678 INFO 52465 --- [ main] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} inited
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
Caused by: org.postgresql.util.PSQLException: 尝试连线已失败。
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:292)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:454)
at org.postgresql.Driver.connect(Driver.java:256)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148)
at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:785)
at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:785)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:220)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1466)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1529)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:734)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1069)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1065)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104)
at com.ruijie.toolbox.databasedoc.dao.DbSchemaDao.getDetailTableInfoList(DbSchemaDao.java:37)
at com.ruijie.toolbox.databasedoc.service.AttributeAnalysisService.start(AttributeAnalysisService.java:35)
at com.ruijie.toolbox.databasedoc.DatabasedocApplication.main(DatabasedocApplication.java:26)
... 8 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
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.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.(PGStream.java:70)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:91)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
... 29 more
2021-05-12 16:20:22.681 INFO 52465 --- [ Thread-2] s.c.a.AnnotationConfigApplicationContext : Closing org.springframework.context.annotation.AnnotationConfigApplicationContext@7cef4e59: startup date [Wed May 12 16:20:11 CST 2021]; root of context hierarchy

给作者提交一个bug：

在postgres数据库测试中有问题：

TableInfo类需要改一下：

public static List<TableInfo> fromDatabaseMetaDataResultSet(ResultSet rs) throws SQLException
	{
		List<TableInfo> infoList = new ArrayList<>();
		if (rs == null) return infoList;
		while (rs.next())
		{
                        //rs对象放在rs循环中
			List<ColumnInfo> ci = ColumnInfo.fromResultSet(rs);
			TableInfo ti = new TableInfo();
			for (ColumnInfo columnInfo : ci) {
				switch (columnInfo.getColumnName().toUpperCase())
				{
					case "TABLE_CAT":
						ti.catalogName = rs.getString(columnInfo.getColumnName());
						break;
					case "TABLE_SCHEM":
						ti.schemaName = rs.getString(columnInfo.getColumnName());
						break;
					case "TABLE_NAME":
						ti.tableName = rs.getString(columnInfo.getColumnName());
						ti.alias = rs.getString(columnInfo.getColumnName());
						break;
					case "TABLE_TYPE":
						ti.tableType = Type.fromDatabaseMetaDataTypeName(rs.getString(columnInfo.getColumnName()));
						break;
					case "REMARKS":
						ti.remarks = rs.getString(columnInfo.getColumnName());
						break;
					case "TYPE_CAT":
						ti.catalogType = rs.getString(columnInfo.getColumnName());
						break;
					case "TYPE_SCHEM":
						ti.schemaType = rs.getString(columnInfo.getColumnName());
						break;
					case "TYPE_NAME":
						ti.typeName = rs.getString(columnInfo.getColumnName());
						break;
					case "SELF_REFERENCING_COL_NAME":
						ti.idColName = rs.getString(columnInfo.getColumnName());
						break;
					case "REF_GENERATION":
						ti.idGeneration = PrimaryKeyGeneration.fromDatabaseMetaDataRefGeneration(rs.getString(columnInfo.getColumnName()));
						break;
				}
			}
			infoList.add(ti);
		}
		return infoList;
	}