Netrexx, JDBC, "Invalid connection handle to DB2/2" problem

[Gunnar_Berthelsen]

With the Netrexx Redbook example as source, I've set up a RMI Client/server
where the server does all the DB2 work and acts as a transaction monitor.
My test client does 10 inserts into the database with

connect,
execute statement,
statement close
connect close, and
terminates.

No problem so far.

But if I try to start  the Client a second time while the server is still
running ,
to insert 10 new rows, the server is not able to connect to the database:
The message is

Connecting to: jdbc:db2:NOSTEST User
SQLException(s) caught while connecting ! SQLState: S1000 Message:
[IBM][JDBC D
river] CLI0600E Invalid connection handle or connection is closed.
SQLSTATE=S100
0 Vendor:   -99999

The statement looks like this:

jdbcCon = Connection DriverManager.getConnection('jdbc:db2:NOSTEST',
userid, password)

Anybody knows what it means when the connect statement returns invalid
handle or connection is closed.

Thanks for listening.
Best regards
Gunnar Berthelsen


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To unsubscribe from this mailing list ( ibm-netrexx ), please send a note to
[hidden email]
with the following message in the body of the note
unsubscribe ibm-netrexx <e-mail address>

[mcbrides]

Sorry. Please disreguard my previous post... I found an answer to my question.

The getMessage method works beautifully...


  catch error = ioexception
  ErrorInRexx = error.getMessage

Mike! You reading this? Is there enough new material to print a New NetRexx
book or are you waiting for 1.2 to be released GA?


--

/--------------------\
| Jerry McBride      |
| [hidden email] |
\--------------------/

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To unsubscribe from this mailing list ( ibm-netrexx ), please send a note to
[hidden email]
with the following message in the body of the note
unsubscribe ibm-netrexx <e-mail address>

[Mike Cowlishaw-2]

No, don't really think it's worth updaing the book at the moment .. the
supplement is quite slim.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Mike Cowlishaw, IBM Fellow, IBM UK Laboratories
mailto:[hidden email]  --  http://www2.hursley.ibm.com



[hidden email] on 07.11.98 01:35:16
Please respond to [hidden email]
To: [hidden email]
cc:
Subject: getMessage


Sorry. Please disreguard my previous post... I found an answer to my question.

The getMessage method works beautifully...


  catch error = ioexception
  ErrorInRexx = error.getMessage

Mike! You reading this? Is there enough new material to print a New NetRexx
book or are you waiting for 1.2 to be released GA?


--

/--------------------\
| Jerry McBride      |
| [hidden email] |
\--------------------/

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To unsubscribe from this mailing list ( ibm-netrexx ), please send a note to
[hidden email]
with the following message in the body of the note
unsubscribe ibm-netrexx <e-mail address>



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To unsubscribe from this mailing list ( ibm-netrexx ), please send a note to
[hidden email]
with the following message in the body of the note
unsubscribe ibm-netrexx <e-mail address>