AS400 Hanging On Query When Prompted for Password Expiry

[adam133]

Describe the issue

Example flow step - prompt=false may be part of it, but that is needed so it accepts the username/password instead of trying to open a prompt.

  - id: "run_query"
    type: io.kestra.plugin.jdbc.as400.Query
    url: "jdbc:as400://{{envs.db_host}}/{{envs.db_name}}/prompt=false;libraries={{envs.db_name}}"
    username: "{{ envs.db_user }}"
    password: "{{ envs.db_password }}"
    sql: "SELECT <stuff> FROM <table>"
    fetch: true
    store: true

Seems the JDBC plugin for AS400 might need to handle this at com.ibm.as400.access.ToolboxSignonHandler.passwordAboutToExpire(ToolboxSignonHandler.java:88) prompt somehow. I'm not sure how that would work but a warning or error about this would be super helpful. I'm not sure if other databases would have the same issue.

Example thread dump:

"WorkerThread" #109 [7528] prio=5 os_prio=0 cpu=312.50ms elapsed=1108.90s tid=0x00000250e9d27030 nid=7528 in Object.wait()  [0x00000075917fe000]
   java.lang.Thread.State: WAITING (on object monitor)
	at java.lang.Object.wait0([email protected]/Native Method)
	- waiting on <no object reference available>
	at java.lang.Object.wait([email protected]/Unknown Source)
	at java.lang.Object.wait([email protected]/Unknown Source)
	at java.awt.WaitDispatchSupport.enter([email protected]/Unknown Source)
	- locked <0x0000000085b9ab40> (a java.awt.Component$AWTTreeLock)
	at java.awt.Dialog.show([email protected]/Unknown Source)
	at com.ibm.as400.access.MessageDialog.display(MessageDialog.java:121)
	at com.ibm.as400.access.ToolboxSignonHandler.displayMessage(ToolboxSignonHandler.java:337)
	at com.ibm.as400.access.ToolboxSignonHandler.passwordAboutToExpire(ToolboxSignonHandler.java:88)
	at com.ibm.as400.access.AS400.promptSignon(AS400.java:3387)
	at com.ibm.as400.access.AS400.signon(AS400.java:4736)
	- locked <0x0000000085b9b030> (a com.ibm.as400.access.AS400)
	at com.ibm.as400.access.AS400.connectService(AS400.java:1667)
	at com.ibm.as400.access.AS400.connectService(AS400.java:1624)
	at com.ibm.as400.access.AS400JDBCConnectionImpl.setProperties(AS400JDBCConnectionImpl.java:3550)
	at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1540)
	at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1374)
	at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:511)
	at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:316)
	at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:289)
	at java.sql.DriverManager.getConnection([email protected]/Unknown Source)
	at java.sql.DriverManager.getConnection([email protected]/Unknown Source)
	at io.kestra.plugin.jdbc.JdbcConnectionInterface.connection(JdbcConnectionInterface.java:63)
	at io.kestra.plugin.jdbc.AbstractJdbcQuery.run(AbstractJdbcQuery.java:77)
	at io.kestra.plugin.jdbc.as400.Query.run(Query.java:24)
	at io.kestra.core.runners.WorkerTaskThread.doRun(WorkerTaskThread.java:77)
	at io.kestra.core.runners.AbstractWorkerThread.run(AbstractWorkerThread.java:56)

Environment

• Kestra Version: 0.17.19 batch cmd on Windows
• plugin version: plugin-jdbc-as400-0.17.0.jar
• java openjdk jre 21.0.3+9.