• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Populating JPA managed Entity from non-JPA managed entity

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Dinner will be steamed monkey heads with a side of tiny ads.
New web page for Paul's Rocket Mass Heaters movies
https://coderanch.com/t/785239/web-page-Paul-Rocket-Mass
reply
    Bookmark Topic Watch Topic
  • New Topic