Re: JDBCR4 where no result set returned

On 10/11/2018 1:39 AM, Don Brown wrote:

I am using jtds-1.2.5.jar

The error indicates the method does not exist.

Java exception "java.lang.NoSuchMethodError:
java/sql/Statement.getUpdatecount()I" when calling method "getUpdatecount"
with signature "()I" in class "java.sql.Statement".

Java is not my strong suit and I am having trouble in searching the
available methods in the classes in that jar file.

I can list the classes but I do not know how to link a class to a java
definition Eg the procedure is specifying the
getUpdatecount method in what I thought was class java.sql.Statement but I
can't see that class in the jtds-1.2.5.jar file.

What am I missing or not understanding ?

Any assistance appreciated.

P JDBC_getUpdateCount...
P b Export
D JDBC_getUpdateCount...
D pi 10i 0
D stmt Like(Statement) const
D getUpdateCount pr 10i 0 extproc(*JAVA
D : 'java.sql.Statement'
D : 'getUpdatecount')
c return getUpdateCount(stmt)
P E

The above prototype is looking for a method called 'getUpdatecount'.
TL;DR - it's spelt wrong. Use 'getUpdateCount'. Java is case sensitive.


How did I get there from here?
First, I started with the prototype.
It's in a class called 'java.sql'Statement'.

Because it starts with 'java.sql' I can see that this is from the
'java.sql' class. The JTDS classes all begin 'net.sourceforge.jtds'.
So off I go looking for the Javadoc for the class 'java.sql.Statement'.
I searched the web for 'java.sql javadoc' and got:
https://docs.oracle.com/javase/8/docs/api/java/sql/package-summary.html

That looks like the right place. Now that I have the 'java.sql' API, I
need to go to the 'Statement' class. (I wish there were a better way to
talk about this stuff.)
https://docs.oracle.com/javase/8/docs/api/java/sql/Statement.html

Searching the page (Ctrl-F) for 'getupdate' I can see there's a
'getUpdateCount()' with an upper case C. That returns an int - which the
RPG prototype does, so aside from the issue of incorrect case, that code
should be good to go.