Play! Framework - Using MySQL and MongoDB for same application

Question

Is it possible to user MySQL Database and MongoDb database for same project using Play! framework?

for example: I want

@Entity Person to interact with my MySQL database and  
@Entity PersonData to interact with my MongoDB database?  

How can I do that?

Please let me know
Thank you

Answer 1

Yes, it is possible. Just use the Morphia plugin for Play. I have done it before. It is quite simple.

For the MongoDB models, just do something like this:

import play.modules.morphia.Model;

@Entity
public class YourMongoModel extends Model {
   ...
}

For the MySQL model, do this:

import play.db.jpa.Model;

@Entity
public class LogMessageX extends Model {
  ...
}

Notice the different imports.

Then the application.conf file should contains something like this:

# For MongoDB
morphia.db.host=localhost
morphia.db.port=27017
morphia.db.name=YourMongoDBName

# for MySQL
db=mysql:user:pwd@database_name