Which Java database API is easiest to use?

Question

I am coming back to Java from Ruby and ActiveRecord and want to use something as easy as ActiveRecord in Ruby. What options do I have?

You can check this : http://stackoverflow.com/questions/610590/is-there-a-java-implementation-of-the-activerecord-pattern-that-is-built-on-top-o — Colin Hebert, Sep 22 '10 at 17:24

score 7 · Answer 1 · edited Jan 24 '16 at 04:38

7

There is a project that a colleague recently released called ActiveJDBC that is an implementation of ActiveRecord for Java.

edited Jan 24 '16 at 04:38

ipolevoy

5,432
2
31
46

answered Oct 04 '10 at 18:02

Larry Smithmier

2,711
2
23
30

Actually I have used active jdbc. Quite good, except that it needs a precompile stage to add annotations to all the classes representing the models. Another problem is that not many large scale projects using it in production. – yazz.com Oct 05 '10 at 05:56
2

Zubair, ActiveJDBC needs a post-comlile step, not pre-compile, and it takes a fraction of a second to do this – ipolevoy Jan 12 '11 at 17:00

score 3 · Answer 2 · answered Sep 22 '10 at 17:27

3

It'll probably some sort of Object Relational Mapping framework you end up using. Grails (a Java Rails like framework) has GORM:

http://www.grails.org/GORM

If you're not using a web framework like that then it'll prob. be some sort of ORM framework - Hibernate, OpenJPA etc...

http://www.hibernate.org/

If you don't want to do the full heavyweight ORM way then look at something like MyBatis (used to be iBatis) which has SQLMaps:

http://www.mybatis.org/

answered Sep 22 '10 at 17:27

Jonathan Holloway

62,090
32
125
150

I will use only the Java language to access the database. – yazz.com Sep 22 '10 at 17:29
Sure, all of the above are Java frameworks, including Grails - which is built on top of Spring. – Jonathan Holloway Sep 22 '10 at 18:15
Grails is a *Groovy* (not Java) Rails-like framework. Many of its features, including GORM, cannot be used effectively from Java code. – Michael Borgwardt Sep 22 '10 at 19:36
No indeed, which is why I said "If you're not using a web framework like that (Grails) then it'll prob be some sort of ORM framework"... My mistake for blanketing Grails as a Java based framework - it is indeed Groovy not Java... – Jonathan Holloway Sep 22 '10 at 20:59
I will be using this from Vaadin, which is the Java language – yazz.com Sep 23 '10 at 09:44

score 3 · Answer 3 · answered Sep 22 '10 at 18:15

3

Hibernate provides very nice ActiveRecord-like access. There are tools to reverse-engineer models from the database. I keep it simple and it works well for me.

answered Sep 22 '10 at 18:15

Tony Ennis

12,000
7
52
73

Mark Baijens · Answer 4 · 2010-09-22T19:28:56.587

1

I like JPA myself (Java Persistence API). Easy to configure and with the right tools you can generate the database from classes or generate the classes from the database. It's easy to configure your classes with the annotations that you can use.

I use the OpenJPA implementation myself.

edited Sep 22 '10 at 19:28

answered Sep 22 '10 at 17:24

Mark Baijens

13,028
11
47
73

Which Java database API is easiest to use?

4 Answers4