Re: jdbc question

Hi Eric,

Unless you're getting some errors (you didn't say whether you are or aren't) then this means that there's no data to return.

Is there any metadata available from rsmd?

The numbers in "rs" and "rsmd" (and other things like "conn" as well) are not useful for debugging.  These just refer to objects within the Java Virtual Machine (JVM) -- so you have the 23rd object and 32nd object, respectively.  That's not helpful for debugging, it's only useful to the JVM at the time you run this, not to us.

Instead, look for messages printed to the screen and/or spooled files when you run this.  Look at the data in the metadata by calling JDBC_getColCount, JDBC_getColName, etc to see if there's any metadata.

Assuming there are no errors and the metadata is what you would expect -- then there simply isn't any data to read in the table. In that case, maybe you are in the wrong database?

-SK


On 7/18/22 9:35 PM, eric bothes wrote:

I'm trying to access an SQL server table from the iseries using JDBC by Mr. Klement.

When debugging variables i get the following values:

rs = 23
rsmd = 32

but when jdbc_nextRow(rs) is run, it drops to end of do.

Not sure how to debug what is happening. I'm able to run a query via MS Access with the same select clause and get results.

Code:
sql = 'SELECT * FROM xre.bi_XRE_Account_Detail';
rs = jdbc_ExecQry( conn : %trim(sql) );
if (rs = *null);
  dsply 'null found';
endif;
rsmd = jdbc_GetMetaData(rs);
dow (jdbc_nextRow(rs));
...
enddo