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

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

Re: From Hibernate to straight JPA

Show key headers only | View raw

On Sat, 18 Jul 2015 20:48:50 +0100, Eternal Hope wrote:

> As I read this thread I thought it was about time I had a look at this
> JPA stuff. I've been writing Java for circa 15 years now, I've done
> everything from writing byte streams to firmware interfaces to high
> availability container managed business applications and Swing based
> UIs. In all this time I have relied on a JDBC driver in my classpath,
> container managed connection pools, hand coded SQL and 'in code'
> transaction management. I do my own OR mapping; actually we don't call
> it 'OR mapping' it's just relational database stuff, and quite frankly
> I've never found the need to use some persistance framework.
>
I'm also interested in the answers you get.

I suspect out backgrounds might be similar: I have a fairly solid 
background in relational database design, and the associated skills of 
normalisation, database performance tuning and writing both an RDBMS's 
dialect of SQL and ODBC as well as writing database applications in Perl, 
C and COBOL. So, when I've needed to implement database applications in 
Java, naturally I went for JDBC.

With my background I really wonder what benefits I'd get from using a JPA 
and, with an eye on performance, how does ease of performance tuning 
compare between the JPA world and that of using JDBC and traditional SQL.

The uniformly worst performance I've seen has been the result of the 
automatically generated SQL that 4GLs (e.g. PowerBuilder) have produced, 
and the resulting dreadful performance resulting from (a) the use of 
ridiculously small test databases, (b) nobody sanity-checking the auto-
generated SQL, especially w.r.t. whether it tried to use DB indexes and 
(c) whether either DBA or programmers had attempted to support high 
volume queries with indexes.
    


-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |

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

Thread

From Hibernate to straight JPA Cecil Westerhof <Cecil@decebal.nl> - 2015-07-10 20:13 +0200
  Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-11 10:56 -0400
    Re: From Hibernate to straight JPA Cecil Westerhof <Cecil@decebal.nl> - 2015-07-11 21:06 +0200
  Re: From Hibernate to straight JPA Lew <lewbloch@gmail.com> - 2015-07-16 17:15 -0700
    Re: From Hibernate to straight JPA Arne Vajhøj <arne@vajhoej.dk> - 2015-07-16 20:44 -0400
      Re: From Hibernate to straight JPA Cecil Westerhof <Cecil@decebal.nl> - 2015-07-17 10:01 +0200
        Re: From Hibernate to straight JPA Arne Vajhøj <arne@vajhoej.dk> - 2015-07-27 22:18 -0400
  Re: From Hibernate to straight JPA Eternal Hope <laughingspam99@gmail.com> - 2015-07-18 20:48 +0100
    Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-18 16:51 -0400
    Re: From Hibernate to straight JPA Arne Vajhøj <arne@vajhoej.dk> - 2015-07-18 17:21 -0400
    Re: From Hibernate to straight JPA Martin Gregorie <martin@address-in-sig.invalid> - 2015-07-18 23:24 +0000
      Re: From Hibernate to straight JPA Arne Vajhøj <arne@vajhoej.dk> - 2015-07-18 19:43 -0400
      Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-18 19:50 -0400
        Re: From Hibernate to straight JPA Arne Vajhøj <arne@vajhoej.dk> - 2015-07-18 20:23 -0400
      Re: From Hibernate to straight JPA Eternal Hope <laughingspam99@gmail.com> - 2015-07-19 09:22 +0100
        Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-19 06:20 -0400
          Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-19 07:49 -0400
            Re: From Hibernate to straight JPA Eternal Hope <laughingspam99@gmail.com> - 2015-07-19 13:28 +0100
              Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-19 09:20 -0400
                Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-19 09:50 -0400
              Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-20 13:16 -0400
                Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-20 13:42 -0400
                Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-20 14:07 -0400
                Re: From Hibernate to straight JPA Eternal Hope <laughingspam99@gmail.com> - 2015-07-20 20:46 +0100
                Re: From Hibernate to straight JPA Martin Gregorie <martin@address-in-sig.invalid> - 2015-07-20 21:01 +0000
                Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-20 22:19 -0400
                Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-20 23:52 -0400
                Re: From Hibernate to straight JPA Joerg Meier <joergmmeier@arcor.de> - 2015-07-21 12:04 +0200
                Re: From Hibernate to straight JPA Eternal Hope <laughingspam99@gmail.com> - 2015-07-21 12:43 +0100
    Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-18 20:25 -0400
      Re: From Hibernate to straight JPA Jeff Higgins <jeff@invalid.invalid> - 2015-07-18 20:44 -0400

csiph-web