Exception Handling

[iDevDaly]

When I run one of the JDBC_ExecPrep* functions, and it returns a result code of -1, how do I get more information about the root cause of the exception? Can we call the Java getMessage function from our program where we're calling the JDBCR4 subprocedure?

[Scott Klement]

There should be a message in the job log. You'll want to look at the details of the message -- it should be an SQLException, and the details should tell you what caused the exception.

[iDevDaly]

Thanks. I'll look into it.