Re: JDBC Connection issues

wonder what the results would be for the jdbc connected user if they ran
cwbping.

On Wed, Nov 3, 2010 at 4:04 PM, Pete Helgren <pete@xxxxxxxxxx> wrote:

"User Profile issue?"

Thought so, but I double checked and the users are active.

While waiting for a post back, I issued the following commands:

ENDHOSTSVR SERVER(*DATABASE) ENDACTCNN(*DATABASE)

And then STRHOSTSVR *DATABASE

That seemed to take care of the problem although I am still uncertain as
to what caused the issue. On a production machine, you probably wouldn't
want to end the DB connections but in this case, this is a development
machine so bouncing the DB server wasn't a problem.

Pete Helgren
Value Added Software, Inc
www.asaap.com
www.opensource4i.com


On 11/3/2010 1:27 PM, Kirk Goins wrote:

User Profile issue?

On Wed, Nov 3, 2010 at 11:12 AM, Pete Helgren<pete@xxxxxxxxxx> wrote:

I am not sure what changed on my system recently but I have a few Tomcat
instances in Windows that have JDBC connections to my i that are now
failing to connect. The weirdness is that one of the webapps connects
to a MySQL instance on i the other webapp connects to DB2/i. Two
different DB's and ports and yet the same failure.

I suspect a "service" on the i has failed, isn't running properly or
? I ran STRHOSTSVR *ALL and it looks like everything was already
running. I don't have any exit point programs registered for the DB
servers so I am stumped. The connecting user profiles are active.
Everything seems Copacetic. But stack traces indicate that the apps a
cannot connect to the DB's on the i. I get "Connection Refused" which
would seem to indicate the i is rejecting the connection attempt. What
port should be listening for the connection?

Suggestions?

--
Pete Helgren
Value Added Software, Inc
www.asaap.com
www.opensource4i.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.