Hi Tom,
First of all I'd like to congratulate you on a great book. Clearly you have put a great deal of time and effort into this book, not to mention the hours it must have taken to create your SP/SV prototypes and service programs. I really appreciate it.
Anyway, I'm working my way through the book (I'm up to Chapter 9) and have noticed a problem with the CRTPGM command in example AIR09_03. The comment in the source code shows the following:
CRTPGM PGM(AIRLIB/AIR09_03)
BNDSRVPGM(SVAIRJAVA SVAIRJDBC) ACTGRP(AIR09_03)
There is no SVAIRJDBC service program in the supplied examples. I believe that this should probably be SVAIREXCEL (which is what I have used and it has created the program). No doubt SVAIRJDBC is something you have developed to allow you to use JDBC in an RPG program. (I could see this as quite useful to allow access to other DB's such as SQL Server, Oracle etc). Is this source code available or is this going to be a subject in another book ?
Anyway, I should also mention that I'm on a V6R1 machine and have Java 1.5 and 6 available but have decided to use Java 1.4.2 to follow your examples (so as to minimize any potential problems). I did have a problem however when compiling SVAIRJAVA. I had to comment out the JNI_VERSION_1_4... Constant in SPAIRJAVA source member, because this constant is also defined in the JNI member in QSYSINC/QRPGLESRC under V6R1. When trying to compile SVAIRJAVA it failed because the constant was already defined (I thought is was better to comment it out in SPAIRJAVA, than to alter the JNI member in QSYSINC). This will probably also be an issue for anyone else on V6R1.
Keep up the great work. I will let you know of any other V6R1 issues I encounter (if any) as I continue to work through the book.
Best Regards,
Mike Heidbrink
First of all I'd like to congratulate you on a great book. Clearly you have put a great deal of time and effort into this book, not to mention the hours it must have taken to create your SP/SV prototypes and service programs. I really appreciate it.
Anyway, I'm working my way through the book (I'm up to Chapter 9) and have noticed a problem with the CRTPGM command in example AIR09_03. The comment in the source code shows the following:
CRTPGM PGM(AIRLIB/AIR09_03)
BNDSRVPGM(SVAIRJAVA SVAIRJDBC) ACTGRP(AIR09_03)
There is no SVAIRJDBC service program in the supplied examples. I believe that this should probably be SVAIREXCEL (which is what I have used and it has created the program). No doubt SVAIRJDBC is something you have developed to allow you to use JDBC in an RPG program. (I could see this as quite useful to allow access to other DB's such as SQL Server, Oracle etc). Is this source code available or is this going to be a subject in another book ?
Anyway, I should also mention that I'm on a V6R1 machine and have Java 1.5 and 6 available but have decided to use Java 1.4.2 to follow your examples (so as to minimize any potential problems). I did have a problem however when compiling SVAIRJAVA. I had to comment out the JNI_VERSION_1_4... Constant in SPAIRJAVA source member, because this constant is also defined in the JNI member in QSYSINC/QRPGLESRC under V6R1. When trying to compile SVAIRJAVA it failed because the constant was already defined (I thought is was better to comment it out in SPAIRJAVA, than to alter the JNI member in QSYSINC). This will probably also be an issue for anyone else on V6R1.
Keep up the great work. I will let you know of any other V6R1 issues I encounter (if any) as I continue to work through the book.
Best Regards,
Mike Heidbrink
Comment