Need to configuration steps for play2+hibernate(JPA)+mySQL

8,860 views
Skip to first unread message

gsp

unread,
May 14, 2012, 6:16:30 AM5/14/12
to play-fr...@googlegroups.com
Hi,

This is siva, I am newly learning playframe work , I am trying to connect play 2.0 project with mySQL database by using hibernate(JPA). Still I didn't get solution. Could you tell exact steps for that configuration or could you share that project to me. 

--
Thanks&Regards,
Sivaprasad.gudluri,
+91-7418674647.

gopala

unread,
May 14, 2012, 6:58:16 AM5/14/12
to play-fr...@googlegroups.com
Hi Siva,

 You need to add mysql configuration stuff in floder conf/application.conf file.I have given the stuff u just copy and paste.

db.default.driver=com.mysql.jdbc.Driver
db.default.user=root
db.default.pass=root
db.default.url="jdbc:mysql://localhost/databasename".

gsp

unread,
May 14, 2012, 7:28:41 AM5/14/12
to play-fr...@googlegroups.com
Hi Gopala,

Thank you for response.
I want to steps for play2+jpa+mysql

I configured MySQL db details,

 conf/application.conf
----------------------------------

db.default.driver=com.mysql.jdbc.Driver
db.default.url="jdbc:mysql://182.897:3456/mydb"
db.default.user=****
db.default.password=****
db.default.jndiName=DefaultDS
jpa.default=defaultPersistenceUnit

Build.scala
---------------

"org.hibernate" % "hibernate-entitymanager" % "3.6.9.Final",
      "mysql" % "mysql-connector-java" % "5.1.18"

persistence.xml
-----------------------

             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             version="2.0">
             
    <persistence-unit name="defaultPersistenceUnit" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <non-jta-data-source>DefaultDS</non-jta-data-source>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
        </properties>
    </persistence-unit>
    
</persistence>


I am trying to run my application I got Unexpected exception:

                      PersistenceException: [PersistenceUnit: defaultPersistenceUnit] Unable to build EntityManagerFactory

No source available, here is the exception stack trace:

->javax.persistence.PersistenceException: [PersistenceUnit: defaultPersistenceUnit] Unable to build EntityManagerFactory
     org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)
     org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
     javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)


please let me know solution for this exception.



--
You received this message because you are subscribed to the Google Groups "play-framework" group.
To view this discussion on the web visit https://groups.google.com/d/msg/play-framework/-/-Wh51OwR62YJ.
To post to this group, send email to play-fr...@googlegroups.com.
To unsubscribe from this group, send email to play-framewor...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/play-framework?hl=en.



--
Thanks&Regards,
Sivaprasad.gudluri,
+91-7418674647.

Nilanjan

unread,
May 14, 2012, 10:37:29 AM5/14/12
to play-framework
Could you be having similar problem:

http://stackoverflow.com/questions/4757662/unable-to-build-entitymanagerfactory

Nilanjan

On May 14, 5:28 am, gsp <gsp....@gmail.com> wrote:
> Hi Gopala,
>
> Thank you for response.
> I want to steps for play2+jpa+mysql
>
> I configured MySQL db details,
>
>  *conf/application.conf*
> *----------------------------------*
> *
> *
> db.default.driver=com.mysql.jdbc.Driver
> db.default.url="jdbc:mysql://182.897:3456/mydb"
> db.default.user=****
> db.default.password=****
> db.default.jndiName=DefaultDS
> jpa.default=defaultPersistenceUnit
>
> *Build.scala*
> *---------------*
> *
> *
> "org.hibernate" % "hibernate-entitymanager" % "3.6.9.Final",
>       "mysql" % "mysql-connector-java" % "5.1.18"
>
> *persistence.xml*
> *-----------------------*
> *
> *
> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://java.sun.com/xml/ns/persistencehttp://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"

gsp

unread,
May 15, 2012, 7:45:46 AM5/15/12
to play-fr...@googlegroups.com
Hi Nilanjan,

Thank you for response.

I am trying jpa with play frame work.
Could u give any sample app for play+jpa+mysql.

Leonard Punt

unread,
May 15, 2012, 10:57:52 AM5/15/12
to play-fr...@googlegroups.com
Play has a sample of JPA+H2: https://github.com/playframework/Play20/tree/master/samples/java/computer-database-jpa

Is the stacktrace you posted the whole stacktrace? If not, can you provide the whole stacktrace?

gsp

unread,
May 15, 2012, 11:50:31 PM5/15/12
to play-fr...@googlegroups.com
Hi  Leonard Punt,

Thank you for response.

I am trying to configure play2.0+mysql+jpa.
Could you tell configurations steps for mysql+jpa

On Tue, May 15, 2012 at 8:27 PM, Leonard Punt <leona...@gmail.com> wrote:
Play has a sample of JPA+H2: https://github.com/playframework/Play20/tree/master/samples/java/computer-database-jpa

Is the stacktrace you posted the whole stacktrace? If not, can you provide the whole stacktrace?

--
You received this message because you are subscribed to the Google Groups "play-framework" group.
To view this discussion on the web visit https://groups.google.com/d/msg/play-framework/-/i1LUOKnqXUEJ.

To post to this group, send email to play-fr...@googlegroups.com.
To unsubscribe from this group, send email to play-framewor...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/play-framework?hl=en.



--
Thanks&Regards,
Sivaprasad.gudluri,
+91-7418674647.

Leonard Punt

unread,
May 16, 2012, 4:27:33 AM5/16/12
to play-fr...@googlegroups.com
This is how to configure Play 2 + Hibernate + MySQL. If you are using a different JPA implementation, some steps will probably be slightly different.

1. conf/application.conf:
db.default.driver=com.mysql.jdbc.Driver
db.default.url="jdbc:mysql://localhost/database_name"
db.default.user=mysql_user
db.default.password=mysql_user_password
2. project/Build.scala:
val appDependencies = Seq(
    		"org.hibernate" % "hibernate-entitymanager" % "3.6.9.Final",
    		"mysql" % "mysql-connector-java" % "5.1.18"
3. conf/META-INF/persistence.xml:
"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
             version="2.0">
             
    <persistence-unit name="defaultPersistenceUnit" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <non-jta-data-source>DefaultDS</non-jta-data-source>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
            <property name="hibernate.hbm2ddl.auto" value="update"/>
        </properties>
    </persistence-unit>
    
</persistence>
4. Annotate your Controller methods with:
@play.db.jpa.Transactional
or
@play.db.jpa.Transactional(readOnly = true)
5. Annotate your Model classes with
@javax.persistence.Entity

emeet

unread,
May 25, 2012, 2:08:22 PM5/25/12
to play-fr...@googlegroups.com
thanks Leonard, your post did it for me. Looked for hours, this worked for me.

Mohit Garg

unread,
Feb 13, 2013, 8:07:17 AM2/13/13
to play-fr...@googlegroups.com

Unexpected exception

PersistenceException: [PersistenceUnit: defaultPersistenceUnit] Unable to build EntityManagerFactory

No source available, here is the exception stack trace:

->javax.persistence.PersistenceException: [PersistenceUnit: defaultPersistenceUnit] Unable to build EntityManagerFactory
     org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)
     org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
     javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)
     javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47)
     play.db.jpa.JPAPlugin.onStart(JPAPlugin.java:35)
     play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:63)
     play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:63)
     scala.collection.immutable.List.foreach(List.scala:309)
     play.api.Play$$anonfun$start$1.apply$mcV$sp(Play.scala:63)
     play.api.Play$$anonfun$start$1.apply(Play.scala:63)
     play.api.Play$$anonfun$start$1.apply(Play.scala:63)
     play.utils.Threads$.withContextClassLoader(Threads.scala:18)
     play.api.Play$.start(Play.scala:62)
     play.core.ReloadableApplication$$anonfun$get$1$$anonfun$1.apply(ApplicationProvider.scala:133)
     play.core.ReloadableApplication$$anonfun$get$1$$anonfun$1.apply(ApplicationProvider.scala:106)
     scala.Option.map(Option.scala:145)
     play.core.ReloadableApplication$$anonfun$get$1.apply(ApplicationProvider.scala:106)
     play.core.ReloadableApplication$$anonfun$get$1.apply(ApplicationProvider.scala:104)
     scala.util.Either$RightProjection.flatMap(Either.scala:523)
     play.core.ReloadableApplication.get(ApplicationProvider.scala:104)
     play.core.server.Server$class.sendHandler$1(Server.scala:56)
     play.core.server.Server$$anonfun$getHandlerFor$4.apply(Server.scala:88)
     play.core.server.Server$$anonfun$getHandlerFor$4.apply(Server.scala:87)
     scala.util.Either$RightProjection.flatMap(Either.scala:523)
     play.core.server.Server$class.getHandlerFor(Server.scala:87)
     play.core.server.NettyServer.getHandlerFor(NettyServer.scala:34)
     play.core.server.netty.PlayDefaultUpstreamHandler.messageReceived(PlayDefaultUpstreamHandler.scala:103)
     org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:75)
     org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:565)
     org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:793)
     org.jboss.netty.handler.codec.http.HttpContentDecoder.messageReceived(HttpContentDecoder.java:104)
     org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:75)
     org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:565)
     org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:793)
     org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
     org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:455)
     org.jboss.netty.handler.codec.replay.ReplayingDecoder.callDecode(ReplayingDecoder.java:538)
     org.jboss.netty.handler.codec.replay.ReplayingDecoder.messageReceived(ReplayingDecoder.java:437)
     org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:75)
     org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:565)
     org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560)
     org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)
     org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)
     org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:84)
     org.jboss.netty.channel.socket.nio.AbstractNioWorker.processSelectedKeys(AbstractNioWorker.java:472)
     org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:333)
     org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:35)
     org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:102)
     org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
     java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
     java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     java.lang.Thread.run(Unknown Source)

Here is my complete stack trace.
I am also running into this problem with Play 2.1 java

Please give some suggestion.

Thanks in advance. :)

Marcos Pereira

unread,
Feb 13, 2013, 10:22:02 AM2/13/13
to play-framework
I think that is better look at the stack trace in your console. Maybe there is more information there. Also, could you give us more details about how are you configuring your app to use jpa?

--
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.
 
 

Neha Choudhary

unread,
Feb 15, 2013, 7:13:16 AM2/15/13
to play-fr...@googlegroups.com
I'm running into the same problem.
I have specified the class name in persistence.xml also:

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
             version="2.0">
             
    <persistence-unit name="samplePersistenceUnit" transaction-type="RESOURCE_LOCAL">

        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <non-jta-data-source>DefaultDS</non-jta-data-source>
        <class>models.Employee</class>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
        </properties>
    </persistence-unit>
    
</persistence>


Here is the complete stack trace 
 Internal server error, for (GET) [/] ->
play.api.Application$$anon$1: Execution exception[[PersistenceException: [PersistenceUnit: samplePersistenceUnit] class or package not found]]
        at play.api.Application$class.handleError(Application.scala:289) ~[play_2.10.jar:2.1.0]
        at play.api.DefaultApplication.handleError(Application.scala:383) [play_2.10.jar:2.1.0]
        at play.core.server.netty.PlayDefaultUpstreamHandler$$anon$2$$anonfun$handle$1.apply(PlayDefaultUpstreamHandler.scala:132) [play_2.10.jar:2.1.0]
        at play.core.server.netty.PlayDefaultUpstreamHandler$$anon$2$$anonfun$handle$1.apply(PlayDefaultUpstreamHandler.scala:128) [play_2.10.jar:2.1.0]
        at play.api.libs.concurrent.PlayPromise$$anonfun$extend1$1.apply(Promise.scala:113) [play_2.10.jar:2.1.0]
        at play.api.libs.concurrent.PlayPromise$$anonfun$extend1$1.apply(Promise.scala:113) [play_2.10.jar:2.1.0]
javax.persistence.PersistenceException: [PersistenceUnit: samplePersistenceUnit] class or package not found
        at org.hibernate.ejb.Ejb3Configuration.addNamedAnnotatedClasses(Ejb3Configuration.java:1386) ~[hibernate-entitymanager-3.6.9.Final.jar:3.6.9.Final]
        at org.hibernate.ejb.Ejb3Configuration.addClassesToSessionFactory(Ejb3Configuration.java:1159) ~[hibernate-entitymanager-3.6.9.Final.jar:3.6.9.Final]
        at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:1004) ~[hibernate-entitymanager-3.6.9.Final.jar:3.6.9.Final]
        at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:282) ~[hibernate-entitymanager-3.6.9.Final.jar:3.6.9.Final]
        at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:366) ~[hibernate-entitymanager-3.6.9.Final.jar:3.6.9.Final]
        at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:56) ~[hibernate-entitymanager-3.6.9.Final.jar:3.6.9.Final]
Caused by: java.lang.ClassNotFoundException: models.Employee
        at java.net.URLClassLoader$1.run(URLClassLoader.java:366) ~[na:1.7.0]
        at java.net.URLClassLoader$1.run(URLClassLoader.java:355) ~[na:1.7.0]
        at java.security.AccessController.doPrivileged(Native Method) ~[na:1.7.0]
        at java.net.URLClassLoader.findClass(URLClassLoader.java:354) ~[na:1.7.0]
        at java.lang.ClassLoader.loadClass(ClassLoader.java:423) ~[na:1.7.0]
        at java.lang.ClassLoader.loadClass(ClassLoader.java:356) ~[na:1.7.0]

Shishir Lamichhane

unread,
Apr 9, 2013, 9:03:30 AM4/9/13
to play-fr...@googlegroups.com
Hi,

We have selected play2.1, scala 2.1.0 and hibernate for a large enterprise product's backend REST services development. Can you please suggest if we have choosen the right technologies? about using Scala and Hibernate, and also can you please show a good sample configuration for Play2.1, Scala 2.1.0 and Hibernate, MySQL project.

Any help would be greatly appreciated.

Thanks,


Nathan Murthy

unread,
Apr 11, 2013, 5:05:54 PM4/11/13
to play-fr...@googlegroups.com
I'm having nearly the identical problem as Neha:

persistence.xml

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
             version="2.0">
    <persistence-unit name="Events" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <jar-file>lib/oadr2-model-0.1-SNAPSHOT.jar</jar-file>
        <class>org.enernoc.open.oadr2.model.EiEvent</class>
        <class>models.Program</class>
        <class>models.VEN</class>
        <class>protocol.BaseProtocol</class>

        <properties>
               <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
               <property name="hibernate.hbm2ddl.auto" value="update"/>
               <property name="hibernate.connection.url" value="jdbc:h2:~/Events"/>
        </properties>
    </persistence-unit>
</persistence>

Stack trace:

[error] application -

! @6e0pj447c - Internal server error, for (GET) [/] ->

play.api.Application$$anon$1: Execution exception[[RuntimeException: java.lang.ExceptionInInitializerError]]
    at play.api.Application$class.handleError(Application.scala:289) ~[play_2.10.jar:2.1.1]
    at play.api.DefaultApplication.handleError(Application.scala:383) [play_2.10.jar:2.1.1]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anon$2$$anonfun$handle$1.apply(PlayDefaultUpstreamHandler.scala:144) [play_2.10.jar:2.1.1]
    at play.core.server.netty.PlayDefaultUpstreamHandler$$anon$2$$anonfun$handle$1.apply(PlayDefaultUpstreamHandler.scala:140) [play_2.10.jar:2.1.1]
    at play.api.libs.concurrent.PlayPromise$$anonfun$extend1$1.apply(Promise.scala:113) [play_2.10.jar:2.1.1]
    at play.api.libs.concurrent.PlayPromise$$anonfun$extend1$1.apply(Promise.scala:113) [play_2.10.jar:2.1.1]
java.lang.RuntimeException: java.lang.ExceptionInInitializerError
    at play.libs.F$Promise$6.apply(F.java:401) ~[play_2.10.jar:2.1.1]
    at scala.concurrent.Future$$anonfun$map$1.liftedTree2$1(Future.scala:253) ~[scala-library.jar:na]
    at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:249) ~[scala-library.jar:na]
    at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:249) ~[scala-library.jar:na]
    at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:29) ~[scala-library.jar:na]
    at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.liftedTree1$1(BatchingExecutor.scala:67) ~[akka-actor_2.10.jar:na]
Caused by: java.lang.ExceptionInInitializerError: null
    at Routes$$anonfun$routes$1$$anonfun$applyOrElse$1$$anonfun$apply$1.apply(routes_routing.scala:129) ~[na:na]
    at Routes$$anonfun$routes$1$$anonfun$applyOrElse$1$$anonfun$apply$1.apply(routes_routing.scala:129) ~[na:na]
    at play.core.Router$HandlerInvoker$$anon$6$$anon$2.invocation(Router.scala:164) ~[play_2.10.jar:2.1.1]
    at play.core.Router$Routes$$anon$1.invocation(Router.scala:345) ~[play_2.10.jar:2.1.1]
    at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:31) ~[play_2.10.jar:2.1.1]
    at play.core.j.JavaAction$$anon$2.apply(JavaAction.scala:74) ~[play_2.10.jar:2.1.1]
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: Events] class or package not found
    at org.hibernate.ejb.Ejb3Configuration.addNamedAnnotatedClasses(Ejb3Configuration.java:1401) ~[hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final]
    at org.hibernate.ejb.Ejb3Configuration.addClassesToSessionFactory(Ejb3Configuration.java:1184) ~[hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final]
    at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:1048) ~[hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final]
    at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:291) ~[hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final]
    at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:373) ~[hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final]
    at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:56) ~[hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final]
Caused by: java.lang.ClassNotFoundException: models.Program
    at java.net.URLClassLoader$1.run(URLClassLoader.java:366) ~[na:1.7.0_15]
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355) ~[na:1.7.0_15]
    at java.security.AccessController.doPrivileged(Native Method) ~[na:1.7.0_15]
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354) ~[na:1.7.0_15]
    at java.lang.ClassLoader.loadClass(ClassLoader.java:423) ~[na:1.7.0_15]
    at java.lang.ClassLoader.loadClass(ClassLoader.java:356) ~[na:1.7.0_15]


Also would appreciate some insight into this...
Nathan
Message has been deleted
Message has been deleted

Shishir Lamichhane

unread,
Apr 15, 2013, 8:11:44 AM4/15/13
to play-fr...@googlegroups.com
Hi, I have created a basic sample for the configuration of Play 2.1.1 Framework, Scala 2.10 Language, Spring3 for dependency injection and Hibernate4 as ORM.

Log4j.jar is used for logging.

Checkout the project : https://github.com/ceecer1/play211-scala210-spring3-Hibernate4.git

Edit the following to suit your db requirement in spring-context-data.xml.

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="org.postgresql.Driver"/>
        <property name="url" value="jdbc:postgresql://localhost:5432/scalaspringhibernate"/>
        <property name="username" value="test"/>
        <property name="password" value="test"/>
    </bean>


cmd -> play run

Creates tables in the database.

Insert 1 or 2 rows manually in the User table after the db is created.

Change <prop key="hibernate.hbm2ddl.auto">
create</prop> to update

got to : http://localhost:9000/ and see the JSON result

This might be really helpful for you guys.

Enjoy SCALA.

Thanks,
ceecer.l...@gmail.com

Luís Loureiro

unread,
Apr 22, 2013, 5:34:44 PM4/22/13
to play-fr...@googlegroups.com
Hi!
I was having the same problem as you!

Although the dependency "javaJpa" was in the "Build.scala" file, i wasn't able to use the play.db.jpa.JPA helper, so i tried to follow the j2ee 6 official tutorial (http://docs.oracle.com/javaee/6/tutorial/doc/bnbpy.html).
Following the tutorial those problems occurred.

All the examples are using the JPA helper, so i needed to use too. So i cleaned the project, forced the application to update the dependencies (using play update) and then i was able to use the JPA helper.

Using the helper those errors disappeared.
Clean the project, force the update of the dependencies and use the JPA helper!
In the worst case clean the sbt dependencies or create a new play installation folder.

Now i've got others, but it's my fault!

I hope it helps!

Luís Loureiro

Sagiruddin Mondal

unread,
May 17, 2016, 3:18:02 AM5/17/16
to play-framework
Hi Sivaprasad,

Play 2.5.3 + Spring Data Jpa

To have play and mysql working together using spring data jpa we ca do these tweak in our code,
  1. First we need to have persistant unit for mysql. We can follow the official play documentation for that,
  2. Then we can have repository which is built using play spring data jpa,
  3. and finally the most important we can inject the repository implementation using Spring Guice injection  module.

I have done this in this ( https://github.com/beingsagir/play-java-spring-data-jpa ) open source project which you can fork and explore further. Let me know if you face any issue and create issue in the Github.



Nishith

unread,
Jun 1, 2016, 2:20:59 AM6/1/16
to play-framework
Hi Sagiruddin, 

I am getting issue while using multiple data sources. I have defined mulitple persistence unit and updated application.conf but unable to load multiple entitymagaer in springdatajpaconfiguration. How can I declare multiple entitymanager ? 
Reply all
Reply to author
Forward
0 new messages