Search found 5 matches

by iDevDaly
Tue May 31, 2022 6:14 pm
Forum: JDBCR4
Topic: Exception Handling
Replies: 2
Views: 4484

Re: Exception Handling

Thanks. I'll look into it.
by iDevDaly
Thu May 26, 2022 4:05 pm
Forum: JDBCR4
Topic: Exception Handling
Replies: 2
Views: 4484

Exception Handling

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?
by iDevDaly
Thu May 26, 2022 4:00 pm
Forum: JDBCR4
Topic: Troubleshooting connection errors
Replies: 3
Views: 6797

Re: Troubleshooting connection errors

It turns out there were 2 issues:

1. they were using a different port than the standard, and
2. I was using an outdated JDBC driver

All is okay now.
by iDevDaly
Mon Mar 28, 2022 5:28 pm
Forum: JDBCR4
Topic: Troubleshooting connection errors
Replies: 3
Views: 6797

Troubleshooting connection errors

I'm using JDBCR4 to attempt connection to a SQL Server database. I've written several other programs that connect to one MSSQL database. But this is a new database, and I'm having issues. The error that gets returned by jdbc_ConnProp() is "Login failed for user." I have an SQL client runni...
by iDevDaly
Fri Jan 21, 2022 5:29 pm
Forum: CSVR4
Topic: CSV file locked even after csv_close()
Replies: 1
Views: 6501

CSV file locked even after csv_close()

I have written a program to process csv files from the /QNTC files system and load the data into DB2 on i tables. When processing the files in an ILE RPG program, after reading through the file I execute the csv_close() procedure and then set on LR and exit the program. In the ILE CL program that ca...