× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. January 2002

Re: Java and Relations DBs..

Brad,

Have you considered creating an "SQLManager" class that is responsible for
maintaining your connections, and constructing and returning SQLDataSet
objects as required?


John Taylor

----- Original Message -----
From: "Brad Stone" <brad@bvstools.com>
To: <java400-l@midrange.com>
Sent: Wednesday, January 09, 2002 2:56 PM
Subject: Re: Java and Relations DBs..


> Ok, here's my question now.
>
> To create a container, I return a result set to the
> container class from an "SQLDataSet" class.  This SQL class
> does the query and returns the result set so I can load my
> container class.
>
> I'm finding that (and suspected this) that connection
> pooling really isn't helping me here.  Since I create a new
> SQLDataSet class for each creation of the container.  This
> means a new connection pool is created each time, etc.
>
> Any hints?

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.