Loading presentation...
Prezi is an interactive zooming presentation

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Querying Firebird with JPA and jOOQ

No description
by

Mark Rotteveel

on 26 October 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Querying Firebird with JPA and jOOQ

Querying Firebird with
JPA & jOOQ
Mark Rotteveel @avalanche1979,
Jaybird developer
Introduction
Mark Rotteveel
Delft, The Netherlands
C# dev by day
Java dev by night
JPA
Java
Persistence
API
What is JPA
Java standard API for object/relational persistence
(JSR-220/-317)
Current version JPA 2.1
Specification of object to schema mapping
Common API
SQL-like query language (JPQL)
Criteria API
Multiple
implementations
+ others
http://www.eclipse.org/eclipselink/
http://www.datanucleus.org/
http://hibernate.org/
jOOQ
Java Object-Oriented Query
What is jOOQ
Library for type safe construction of SQL
Open-source for open-source databases
Enterprise license for
commercial databases
Single
implementation
Supports multiple database dialects
http://www.jooq.org/
Preparation
Hibernate
Classes
Layout of the objects, mapping to database
Persistence unit
META-INF/persistence.xml: the configuration
Optionally more xml config in META-INF/orm.xml
jOOQ
Generate mapping using Maven plugin
Live coding session
Based on employee.fdb
Using Firebird 3
Warning
: bad typist and demo effect ahead
(snapshot 3.0.0.31352)
Jaybird developer
Sample code: https://github.com/mrotteveel/talk2014
Full transcript