Best ORM framework to use with Play

[viiveek sankar]

Hi,

 I am building an application with  play framework . I am debating whether to use ebean or hibernate as the orm layer. I heard ebean support would be discontinued. Does any body have any recommendations 

[Kate von Roeder]

If you're using Scala, I strongly recommend Slick -
http://slick.typesafe.com/

I can't speak to a good ORM for the Java side of Play, though.

> --
> You received this message because you are subscribed to the Google
> Groups "play-framework" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to play-framewor...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.

[viiveek sankar]

I am using java for play 

[HHeinz]

Hello viiveek, 

Afaik Ebean is not going to be discontinued yet but Play Framework 2.3 Java is going to use JPA as the default (but if I understood correctly Ebean should still work). 

Ebean recently got a bit more activity and a major release to be expected in March. I do like the concept of Ebean and it works

quite well for my small projects but many seem to have problems with it.

James Roper from Typesafe wrote a statement last year, see Play Framework 2.3 Roadmap

Have a nice week-end.

 

Henning

[Kevin Sheppard]

I stick to using whatever ORM is bundled into Play. It will save you potential headaches due to unforeseen breakages when whenever Play updates.

[Niklas Nylund]

We are happy with Ebean and I would recommend it. Most of the problems we have had seems to actually be in BoneCP and it looks like we will see a fix for these in 2.2.2.

Niklas

[J. O. Meyer]

I use Hibernate and prefer it to EBean. It is quite mature and HQL gives you a lot of flexibility.

I recommend not to bloat your entity bean with business logic. Use the DAO pattern for a clear separation of concerns.

[viiveek sankar]

Thank you. I was also hoping to use hibernate. Is it necessary to use annotation based hibernate can i still use xml based mapping

[J. O. Meyer]

I use JPA and am satisfied with it. Haven't tried XML mapping myself yet.

[sachin walia]

I don't use an ORM and don't recommend one. Once you start using ORM and later on realize performance issues it is hard to go back. For Java there are better options such as JOOQ, ActiveJDBC, QueryDSL, JDBI, sql2o. They help you avoid writing same JDBC code again and again.

[Mathias Bogaert]

Check out http://scalikejdbc.org/.

[Allen]

HI,

I would recommend the Apache Cayenne ORM (https://cayenne.apache.org). 

Very mature, easy to use, includes a Model Editor.

We did wrote a play 1.2 plugin for it. 

https://github.com/mackoy/play12cay

Example project:

https://github.com/mackoy/play12cay-example

A play 2.x plugin is in progress…

Best,

Allen

[David Weinberg]

I have a sample play project using Scala and Hibernate with some macros for convenience.  https://github.com/thymepuns/computer-database-shib

On Saturday, February 8, 2014 1:28:20 PM UTC-8, viiveek sankar wrote:

[sBham]

Can you please expand on what non-ORM you are using in production. I am just getting to discover Play (Java), but we do not do any orm: we use jDBI across all of you projects, I just want to know what "magic" will break out if we do not go through the bundled orm !?

[Łukasz Śliwiński]

I also do not recommend to use heavy ORM framework. You can find a lot of info about that on the net. Personally I like using SQL - it is native language for Database and created for this purpose. I don't need overlay like Hibernate and it's magic that is going inside. Havy ORM like Hibernate can be sequent element in your daily code that gives you big headaches.

Of course in java it is little unpleasant to write code using JDBC. But you can find a lot of "light" orm.

I used with play! JDBI and OrmLight with great success.

But like others say you can select another

Example:

http://en.wikipedia.org/wiki/List_of_object-relational_mapping_software#Java

I recommend OrmLight, for my purposes using it is straightforward.

[K.N S]

hello 

     i am using play framework newly. im not getting. can u help me. how to start a project.

[sunnykaka]

I'm using JPA and Hibernate now.

If you are using Play for Scala, I recommand Slick, otherwise Hibernate would be nice.