RE: CGIDEV2 & JDBC connection

You can call off the dogs, it's working correctly now. My best guess is that there was something in the CGI job. I had been working/testing for a while, and it was all in the same CGI job. I've had problems before that were solved by ending the existing CGI job.

Thanks everyone!



For posterity:
The webpage has a button that calls an RPGLE program operating in its own named activation group. That RPGLE program calls a *SRVPGM that does the JDBC. That *SRVPGM keeps the connection in a global variable. If the connection is null (If Conn = *null;), it establishes a new connection before running the JDBC operation. The *SRVPGM returns without closing the connection.

I was the only user on a test server. I clicked the webpage button and the RPGLE program executed. The connection variable in the *SRVPGM was null, so it created a new connection. The RPGLE returned data to my webpage. I immediately clicked the webpage button again. When I got into the *SRVPGM, other global variables were still set but the connection was null.