I'm starting to evaluate a TCP/IP based java application using JDBC (IBM DB2 database).
Does anybody have any experience with a similar application or just TCP/IP based applications?
I have just instaled SP 5.1 (to try it's new TCP/IP features) but I didn't find a "how to" reference in on line help neither white papers related, so I don't even how to outline the project since I have selected the "TCP/IP based app" under Internet section but the recorder doesn't record anything. Can anybody help me?
Our application uses JDK 1.1.8 and I
have set the application path in the
application profile to the jre.exe in
the java-directory. The working path is
set to the directory which includes
Just have a look in your .bat or .cmd-file
(which starts the virtual machine) to see what java-file will be started.
JDBC is a complicated protocol and recreating it at a tcpip level is a mammoth task (IMO). As a result, I am not sure if it will be feasable to test JDBC at a TCPIP level. It would be good to hear stories from those that have tried... Certainly, you should be able to record, but replay is likely to be very difficult, even if you make extensive use of the TCPIP recorder rules.
I think that you would be better off looking at the Java frameworks replay-only approach. The drawback here is that you really need to know the client app very well, since you need to make the appropriate calls at the right time.
On a side note, 5.1 supports DB2 CLI which is(according to the Release notes) like ODBC. Could your app be configured to use CLI?