Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #624

Re: Local database library

Show all headers | View raw

On Wed, 2 Oct 2013 19:49:39 +0000 (UTC)
Martin Gregorie <martin@address-in-sig.invalid> wrote:

>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
>

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" and right now I have a "connect.java" file in
that makes the connection to the database and a "transaction.java" that
works with the transaction table. My source file in a different project
is not seeing these, but I think it might be improper setup in NetBeans
since I'm learning *that* too! :-)


>[*] 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. 
>

I have some free tools for this under Linux and plan to do this.
However, I am quite familiar with the data structure since I worked
with it (under C, and later C++) for six years (some time ago) and not
too much has changed. But I believe there are probably some poor design
choices being used since it was originally designed by someone with
minimal programming experience and almost no data experience. I cleaned
up a few things when I worked for them previously and want to do more
once we get the new version up and running. I know that's the backward
way to do it, but we're quickly reaching the point where we cannot make
changes to the code (under Qt3) while trying to upgrade the clients'
computers.

You will probably see me posting in here again! :-) Thanks for the tips!


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

Linux 3.7.10-1.16-desktop
 10:38am  up 15 days 20:51,  14 users,  load average: 0.87, 0.75, 0.64

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Local database library Kevin Nathan <knathan@project54.com> - 2013-10-01 13:52 -0700
  Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-01 17:38 -0400
    Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-01 15:41 -0700
      Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-01 20:53 -0400
        Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-02 10:09 -0700
          Re: Local database library Martin Gregorie <martin@address-in-sig.invalid> - 2013-10-02 19:49 +0000
            Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-04 10:48 -0700
              Re: Local database library Martin Gregorie <martin@address-in-sig.invalid> - 2013-10-05 15:43 +0000
                Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-05 11:19 -0700
          Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-02 22:05 -0400
            Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-04 10:57 -0700
              Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-04 22:00 -0400
                Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-05 11:28 -0700
                Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-05 15:15 -0400
                Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-05 12:49 -0700
  Re: Local database library "John B. Matthews" <nospam@nospam.invalid> - 2013-10-02 15:37 -0400
    Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-04 11:02 -0700
      Re: Local database library Lew <lewbloch@gmail.com> - 2013-10-04 15:56 -0700
        Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-05 12:06 -0700
          Re: Local database library Lew <lewbloch@gmail.com> - 2013-10-15 16:41 -0700
            Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-26 12:08 -0700
              Re: Local database library Martin Gregorie <martin@address-in-sig.invalid> - 2013-10-26 21:04 +0000
                Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-26 18:58 -0700
              Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-26 18:39 -0400
                Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-26 19:04 -0700
            Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-26 18:33 -0400

csiph-web