Groups > comp.lang.java.programmer > #14163

Re: Apache JDBC utils

From	"John B. Matthews" <nospam@nospam.invalid>
Newsgroups	comp.lang.java.programmer
Subject	Re: Apache JDBC utils
Date	2012-05-02 18:51 -0400
Organization	The Wasteland
Message-ID	<nospam-4668AA.18512402052012@news.aioe.org> (permalink)
References	<jnn1pc$33c$1@dont-email.me> <nospam-E4727E.23373001052012@news.aioe.org> <u78or.34999$Ex1.4127@newsfe18.iad>

Show all headers | View raw

In article <u78or.34999$Ex1.4127@newsfe18.iad>,
 Arved Sandstrom <asandstrom3minus1@eastlink.ca> wrote:

> On 12-05-02 12:37 AM, John B. Matthews wrote:
> > In article <jnn1pc$33c$1@dont-email.me>, markspace <-@.> wrote:
> > 
> >> And: is there a better, light-weight non-ORM package that you 
> >> might recommend instead?  Something a bit more complete.
> > 
> > Having always used JDBC, I wanted to see what a persistence unit 
> > looked like. I used the "New Entity Classes from Database Wizard" 
> > in NetBeans to generate an entity for a database table named 
> > CUSTOMER and clicked the persistence unit button to generate a JPA 
> > controller.
> > 
> > Entity -> Customer.java
> > Persistence unit -> CustomerJpaController.java
> 
> I'll have to run NetBeans tonight to remind myself of what it 
> produces as a "JPA controller". :-) Bear in mind, persistence units 
> are actually what are described in persistence.xml (one or more).

D'oh, I misinterpreted the results of my little experiment. Both 
Customer.java and CustomerJpaController.java are generated by the 
wizard; the Create Persistence Unit button generates the persistence.xml 
file from entries in a dialog. Opening the latter in the IDE is 
something akin to opening a .form file in the GUI designer.
 
> > Then I used these two classes to fill a JComboBox model, as shown 
> > here:
> > 
> > <http://stackoverflow.com/a/2531942/230513>
> > 
> > The example was easy to create, and I can see several things:
> > 
> > 1. The queries, getters, setters and annotations generated in the 
> > entity.
> > 
> > 2. The findCustomerXxx, create, edit and destroy methods generated 
> > in the controller, which appear to correspond roughly to select, 
> > insert, update and delete.
> > 
> Don't get me wrong, I'm a JPA enthusiast. Before it showed up I used 
> the native APIs in Toplink, Toplink Essentials and Hibernate, and 
> even those usually would win out over straight JDBC.
> 
> But what you did above just scratches the surface. It's now your 
> responsibility to read and understand the JPA specification and get 
> the lay of the land for the APIs. I mean "your" in the general sense 
> here.

Thanks for putting this in perspective. I'm a complete tyro to JPA, and 
I couldn't resist a little immediate gratification.

> You've always used JDBC, you say. You're aware then that you have to 
> know quite a lot to use that well. You need to know a lot more - 
> *plus* understanding JDBC, IMO - to use JPA well. We've been throwing 
> around terms like conceptual or architectural weight - with JPA you 
> pull in a fair bit of that.
> 
> I don't believe that *you* would stop here - in fact you'd go ahead 
> and read the spec - but I've seen a fair few programmers that think 
> that's mostly all there is to JPA: use the IDE to generate from the 
> DB, or vice versa. They always run into problems sooner or later.

By way of analogy, I see something similar with people thinking that a 
GUI designer will obviate the need to understand Swing.

-- 
John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>

Thread

Apache JDBC utils markspace <-@.> - 2012-04-30 14:55 -0700
  Re: Apache JDBC utils Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2012-04-30 20:56 -0300
    Re: Apache JDBC utils markspace <-@.> - 2012-04-30 17:50 -0700
  Re: Apache JDBC utils Lew <lewbloch@gmail.com> - 2012-04-30 18:03 -0700
    Re: Apache JDBC utils markspace <-@.> - 2012-04-30 19:27 -0700
      Re: Apache JDBC utils Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2012-05-01 10:29 -0300
        Re: Apache JDBC utils markspace <-@.> - 2012-05-01 08:57 -0700
          Re: Apache JDBC utils Lew <lewbloch@gmail.com> - 2012-05-02 11:16 -0700
            Re: Apache JDBC utils markspace <-@.> - 2012-05-03 07:51 -0700
    Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-01 19:22 -0400
  Re: Apache JDBC utils Daniel Pitts <newsgroup.nospam@virtualinfinity.net> - 2012-05-01 10:32 -0700
    Re: Apache JDBC utils markspace <-@.> - 2012-05-01 11:22 -0700
      Re: Apache JDBC utils Daniel Pitts <newsgroup.nospam@virtualinfinity.net> - 2012-05-01 15:26 -0700
        Re: Apache JDBC utils Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2012-05-01 19:44 -0300
  Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-01 19:26 -0400
    Re: Apache JDBC utils Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2012-05-01 21:14 -0300
      Re: Apache JDBC utils Leif Roar Moldskred <leifm@dimnakorr.com> - 2012-05-01 22:22 -0500
        Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 13:52 -0400
      Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 13:51 -0400
        Re: Apache JDBC utils Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2012-05-03 17:11 -0300
          Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 16:58 -0400
            Re: Apache JDBC utils Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2012-05-03 18:25 -0300
              Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 19:55 -0400
    Re: Apache JDBC utils Leif Roar Moldskred <leifm@dimnakorr.com> - 2012-05-01 22:08 -0500
      Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 13:55 -0400
        Re: Apache JDBC utils Leif Roar Moldskred <leifm@dimnakorr.com> - 2012-05-03 13:44 -0500
          Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 15:06 -0400
  Re: Apache JDBC utils "John B. Matthews" <nospam@nospam.invalid> - 2012-05-01 23:37 -0400
    Re: Apache JDBC utils Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2012-05-02 07:37 -0300
      Re: Apache JDBC utils "John B. Matthews" <nospam@nospam.invalid> - 2012-05-02 18:51 -0400
  Re: Apache JDBC utils Jan Burse <janburse@fastmail.fm> - 2012-05-02 12:22 +0200
    Re: Apache JDBC utils markspace <-@.> - 2012-05-02 08:29 -0700
      Re: Apache JDBC utils Jan Burse <janburse@fastmail.fm> - 2012-05-02 22:02 +0200
        Re: Apache JDBC utils Lew <lewbloch@gmail.com> - 2012-05-02 14:22 -0700
          Re: Apache JDBC utils Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2012-05-02 18:53 -0300
          Re: Apache JDBC utils Jan Burse <janburse@fastmail.fm> - 2012-05-03 00:03 +0200
            Re: Apache JDBC utils Jan Burse <janburse@fastmail.fm> - 2012-05-03 00:14 +0200
            Re: Apache JDBC utils Jan Burse <janburse@fastmail.fm> - 2012-05-03 00:27 +0200
              Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 14:03 -0400
            Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-02 18:58 -0400
            Re: Apache JDBC utils Lew <lewbloch@gmail.com> - 2012-05-02 16:18 -0700
          Re: Apache JDBC utils Daniel Pitts <newsgroup.nospam@virtualinfinity.net> - 2012-05-02 15:25 -0700
            Re: Apache JDBC utils Jan Burse <janburse@fastmail.fm> - 2012-05-03 00:59 +0200
              Re: Apache JDBC utils Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 14:05 -0400
            Re: Apache JDBC utils Lew <lewbloch@gmail.com> - 2012-05-02 16:24 -0700
              Re: Apache JDBC utils Daniel Pitts <newsgroup.nospam@virtualinfinity.net> - 2012-05-02 16:35 -0700
              Re: Apache JDBC utils Jan Burse <janburse@fastmail.fm> - 2012-05-03 01:46 +0200
              Re: Apache JDBC utils Jan Burse <janburse@fastmail.fm> - 2012-05-03 01:49 +0200

csiph-web