error when i connect to AS400 server

[haiwei1991]

when i connect to my AS400 server, there is an error , I can not solve it ,please help me .
see the log bellow:

2023.03.11 18:50:05.698990 [ 13433 ] {646bc397-3168-45f7-a12e-6df38e4ff5b7} <Error> ReadWriteBufferFromHTTP: HTTP request to http://127.0.0.1:9019/columns_info?version=1&connection_string=as400&table=select%20%2A%20from%20PGR05LB.MHL59P&external_table_functions_use_nulls=1` failed at try 1/1 with bytes read: 0/unknown. Error: DB::Exception: Received error from remote server /columns_info?version=1&connection_string=as400&table=select%20%2A%20from%20PGR05LB.MHL59P&external_table_functions_use_nulls=1. HTTP status code: 500 Internal Server Error, body: Failed to infer schema from [as400] due to: Failed to access [as400] due to: as400 - Connection is not available, request timed out after 30000ms.. (Current backoff wait is 100/1600 ms)
2023.03.11 18:50:05.799663 [ 13433 ] {646bc397-3168-45f7-a12e-6df38e4ff5b7} executeQuery: Code: 86. DB::Exception: Received error from remote server /columns_info?version=1&connection_string=as400&table=select%20%2A%20from%20PGR05LB.MHL59P&external_table_functions_use_nulls=1. HTTP status code: 500 Internal Server Error, body: Failed to infer schema from [as400] due to: Failed to access [as400] due to: as400 - Connection is not available, request timed out after 30000ms. (RECEIVED_ERROR_FROM_REMOTE_IO_SERVER) (version 22.9.4.32 (official build)) (from [::ffff:172.31.76.22]:60177) (in query: select * from jdbc('as400', 'select * from PGR05LB.MHL59P') FORMAT TabSeparatedWithNamesAndTypes;), Stack trace (when copying this message, always include the lines below):
`

[haiwei1991]

my version

clickhouse-server-22.9.4.32-1.x86_64
clickhouse-client-22.9.4.32-1.x86_64
clickhouse-common-static-dbg-22.9.4.32-1.x86_64
clickhouse-jdbc-bridge-2.1.0-1.noarch
clickhouse-common-static-22.9.4.32-1.x86_64

[haiwei1991]

@zhicwu

[zhicwu]

as400 - Connection is not available, request timed out after 30000ms.

Hi @haiwei1991, have you validated the datasource configuration on JDBC bridge servder? It seems not working.

[haiwei1991]

as400 - Connection is not available, request timed out after 30000ms.

Hi @haiwei1991, have you validated the datasource configuration on JDBC bridge servder? It seems not working.

I executed select * from jdbc('', 'show datasources') and I can see the datasource of AS400 。
I‘m not sure if it is the validation you said. are there any other way to validate the datasource configuration.