Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Martin Gregorie Newsgroups: comp.lang.java.databases Subject: Re: Local database library Date: Wed, 2 Oct 2013 19:49:39 +0000 (UTC) Organization: A noiseless patient Spider Lines: 23 Message-ID: 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> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Wed, 2 Oct 2013 19:49:39 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="19737"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX198j0RHir8NHYNvJgZ3e/Aruuo8hs/LPMk=" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:Wiq8vvwI4AcdP2AyfK+72MQQbbo= Xref: csiph.com comp.lang.java.databases:622 On Wed, 02 Oct 2013 10:09:35 -0700, Kevin Nathan wrote: > Your two code lines above have gotten me thinking of some other options > and questions, so I will be digging into that. That's pretty much the > format used in the C++ code, but that code is very poorly written so > it's hard to understand a lot of what the previous coders were doing. > One JDBC wrapper class per table may work. Then again its likely to lead you into tangles with SQL that accesses more than one table, i.e. doing joins. In that case a bit of data analysis[*] may pay off because things may be easier if you can use a single class to encapsulate all access to a tightly linked group of tables [*] This means looking at the database schema if there is a current version or draw one up if there isn't. There are some good tools for extracting entity-relationship diagrams from the schema if your shop has a budget for this sort of tool. -- martin@ | Martin Gregorie gregorie. | Essex, UK org |