Re: Can I Trace a JDBC connection on IBM i

Mark Murphy <[email protected]> Thu, 22 Jun 2023 16:59:37 -0400
Newsgroups gmane.comp.lang.as400.java
Message-ID <CAK1FvwY2wVJFevO+M-SxLadJEiPFcGmF3a6O2p8dufRDt=_HyQ@mail.gmail.com>
Is there a way to trace a JDBC connection to see if there is something
strange going on? I see nothing in the job log.


On Thu, Jun 22, 2023 at 4:58 PM Mark Murphy <[email protected]> wrote:

> I am having sort of intermittent slow JDBC connections. That is, I am
> having a slow connection between one Windows server and an IBM i, but when
> I use an older server against the same IBM i, the connection is 100 times
> faster. literally. Same driver on both Windows servers.
>
> IBM i v7.2
> jtOpen 9.8
>
> old server: Windows Server 2016 Datacenter - openj9 - works fine
>    JDK: jdk-8.0.292.10-openj9
>
> new server: Windows Server 2022 Datacenter - hotspot - slow JDBC connection
>    JDK: jdk-8.0.362.9.hotspot
>
> I suppose I could try to find the open j9 jdk and see if that fixes things
> on the 2022 server. since that is the only difference other than the newer
> version of Windows. But the new server is a lot faster than the old server.
>
>
-- 
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.