title: Map SQL Query to Data Object - J2EE spec
body: <p>We are upgrading our environment in house, we are currently using <code>Jersey -&gt; Spring DI -&gt; Spring JDBC</code> for all our data operations. and ofcourse JMS, schedulers,Dozer etc., and a lot other libraries are used based on need.</p>
  
  <p>Our plan is to move towards complete J2EE spec, So to use <code>Jax-rs(jersey)/Jax-ws - &gt; CDI -&gt;  (???)</code> </p>
  
  <p>Our application has a lot of tables(~5000) and data is not always from one table. Which j2ee spec allows us to perform CRUD operations on the database without us having to manually map the data to the DO? </p>
  
  <p>I've looked at JPA, JDO, JDBC as options, but none of these can help us as it requires Entity mapped to the table, which is not an option. Our DO/Entity will be a join from more than one database table. </p>
  
  <p>Thank you. </p>