Re: dataSource.getConnection jt400

["Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx>]

    Hey,

    Sorry to prolong the thread, but I should mention the following:

    You should probably add something at the end of your apps, or better, a
shutdown hook in your ToolboxDataSource class, that invokes
AS400JDBCConnectionPool.close() so you don't leave tied up resources on
the database side.

    Fortunately, there's already a finalizer that will handle cleanup for 
you on garbage collection.  Best,


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO         -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?             http://www.jguru.com/faq/Java400


----- Original Message -----
From: "Patrick L Archibald" <Patrick.Archibald@xxxxxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Wednesday, July 30, 2003 11:18 AM
Subject: Re: dataSource.getConnection jt400


> Joe Sam
>
> Thanks for the help and the tips. I will change the class accordingly.
> Let me know if you publish an article on this.  I will definitely check
> it out.
>
> Rock on, PLA
>