Menu

#456 Driver does not support get/set network timeout for connections

Connection
closed
None
5
2021-11-01
2021-11-01
No

Hello,
I have some issues when using the new versions of the driver and Spring Boot. Basically, if I use the jt400 driver from version 10.1 to 10.7 with Spring 2.5.5, I get the error/warning below. While if I use the jt400 driver version 9.8 it is working fine (just switch the jt400 driver version in the same application). I am using OpenJDK 11.

HikariPool-1 - Driver does not support get/set network timeout for connections. (The driver does not support this function. (thread used != false))

    <dependency>
        <groupId>net.sf.jt400</groupId>
        <artifactId>jt400-jdk8</artifactId>
        <version>10.7</version>
    </dependency>

What can be the problem?
Thanks!

Discussion

  • John Eberhard

    John Eberhard - 2021-11-01
    • status: open --> closed
    • assigned_to: John Eberhard
     
  • John Eberhard

    John Eberhard - 2021-11-01

    The get/set network timeout does not work using a threaded server. If the network timeout was actually used, early versions of the jt400 driver would not behave correctly. To prevent this problem, later version of the driver detect that a threaded server is being used and disallows those method. The change was made in JTOpen 10.4

    Fixes and enhancements in JTOpen 10.4 (released 2020-06-30)
    JDBC: setNetworkTimeout not supported when "thread used=true"

    To use network timeout, you need to set the following JDBC property on your connections:

    thread used=false

     

Log in to post a comment.