Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Kevin Nathan <knathan@project54.com>
Newsgroups: comp.lang.java.databases
Subject: Re: Local database library
Date: Sat, 5 Oct 2013 11:19:01 -0700
Lines: 34
Message-ID: <20131005111901.75595916@efreet.linux>
References: <20131001135230.66af12f9@efreet.linux> <524b40ba$0$304$14726298@news.sunsite.dk> <20131001154157.7f37e588@efreet.linux> <524b6e8d$0$304$14726298@news.sunsite.dk> <20131002100935.0eacf609@efreet.linux> <l2htcj$j8p$1@dont-email.me> <20131004104829.4bd78e5b@efreet.linux> <l2pc3f$442$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Trace: individual.net vQ43MleZzBOfL8eqWrgF7wkCtYVdg8EgrGLDAgZ2bMcyiCxA7Y
Cancel-Lock: sha1:8tqc9KpXLt7bj5fijVO/ES6ifOw=
X-Newsreader: Claws Mail 3.9.0 (GTK+ 2.24.18; i586-suse-linux-gnu)
X-Face: %/gp4MCQT=`#JS##?-]V9ksid6OSR@(wbF"bK6wSLO$u,%(N@X~bVhAD+\A_[gRhx*T6=fq "N_5H8.v[&;q0iw!s_wuL05B0xg#OYUkbn#@&U_]fL%o==~2sphc?*L+bicO!POJLG#p'N.]J0/p_w Z^(.kOB%Ob914-V>?GI;
Xref: csiph.com comp.lang.java.databases:631

On Sat, 5 Oct 2013 15:43:43 +0000 (UTC)
Martin Gregorie <martin@address-in-sig.invalid> wrote:

>On Fri, 04 Oct 2013 10:48:29 -0700, Kevin Nathan wrote:
>
>> I hadn't thought of that. What I have started to do (and it's not yet
>> working) is to create a "DBaccess" library under
>> "net.companyname.connect" 
>>
>The following summarises what I did for a small system that has non-
>interactive CLI programs as well as a few GUI utilities that do
>updates and run enquiries on the DB.
>
>I ended with a superclass containing the methods connect() and close()
>to start and stop the database connection plus other methods to handle 
>common requirements such as reporting DB access failures. There's a 
>subclass for each program. The methods in these each encapsulate an
>SQL transaction. Data is passed as arguments and the return value
>indicates success or failure. Where a transaction fills a JTable a
>reference to its Model is passed into the method, which can put all
>the rows returned by the SQL query into the Model.
>

Sounds like just about what I need! I will look into doing it that
way...


-- 
Kevin Nathan (Arizona, USA)  
Linux is not a destination, it's a journey -- enjoy the trip!

Linux 3.7.10-1.16-desktop
 11:17am  up 16 days 21:30,  14 users,  load average: 0.80, 0.62, 0.61