Re: Unable to connect using JDBCR4...

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Rob,

The errors from JDBCR4 are written to the STDERR data stream.  By 
default, these would appear on the display if you're in an interactive 
job, but a common issue is that they scroll off the display faster than 
they can be read.

I would suggest doing something like this:

OVRPRTF FILE(STDOUT) TOFILE(QSYSPRT) HOLD(*YES)
OVRPRTF FILE(STDERR) TOFILE(QSYSPRT) HOLD(*YES)
call your jdbcr4 program
SIGNOFF (or end job)

This should result in error information being sent to spooled files that 
you can look at after the job has ended.

The error messages will be much more helpful than debugging the code.


On 5/3/17 6:38 PM, Robert Rogerson wrote:
> Our network folks can't see any reason why TELNET can access the server
> but JDBCR4 can not.
>
> Does anyone know if there's a log file (or can one be turned on) that
> might shed some light on the issue?
>
> Thanks,
>
> Rob