Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Populating JPA managed Entity from non-JPA managed entity

 
Mat Michel
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

We have requirement where we have one Schema with all Tables are managed using JPA so has mapping between Tables and POJO is in place.

Now everyday some process runs brings new data in Non- JPA managed tables from those tables based on some ETL presently system loads
JPA managed tables.

Now we have requirement is to populate JPA managed POJO’s from Non_JPA managed tables using queries which used by ETL before and
Persist it to database via cache write back

Does anyone come across such situation where JPA managed database tables are populated by querying different non-JPA managed tables being in different schema?
What should be approach to handle such migration?

One approach I have is to use Native query feature of JPA to query data from Non-JPA based tables and perform population using return SqlResultSet.
When I checked JPA implementation of Hibernate it has very few details… so being concern about Native query approach.

Please provide you input on such requirement.

Matt
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic