Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #39996

Hibernate get fields

Show all headers | View raw

Currently using Hibernate 5.6.15.Final as we're currently stuck with Java 8.
I have a table with say 50 fields.
I have a DTO with 50 fields.
So the DTO looks something like this.
@Table
public class MyDTO implements Serializable {
    @Id
    @Column(name = "FIELD_ONE")
    private String fieldOne;
    @Column(name = "FIELD_TWO")
    private String fieldTwo;
...
}

Now I write a query in my DAO to get just those 2 fields from all records.
This works. Is there a cleaner way without creating a new file containing an interface to reference just those 2 fields?
  private static final String MY_QUERY = "SELECT fieldOne, fieldTwo FROM MyDTO";
  try (Session session = MyHibernateUtil.getSessionFactory().openSession();) {
    Query<? extends Object[]> query = session.createQuery(MY_QUERY,(new Object[]{}).getClass());
    List<? extends Object[]> results = query.list();
    final Map<String,String> resultMap = new HashMap<>(100);
    results.stream().forEach(result -> resultMap.put(String.valueOf(((Object[])result)[0]), String.valueOf(((Object[])result)[1])));
}

Back to comp.lang.java.programmer | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Hibernate get fields "e.d.pro...@gmail.com" <e.d.programmer@gmail.com> - 2023-08-23 07:15 -0700
  Re: Hibernate get fields Daniele Futtorovic <da.futt.news@laposte-dot-net.invalid> - 2023-08-23 19:43 +0200
    Re: Hibernate get fields "e.d.pro...@gmail.com" <e.d.programmer@gmail.com> - 2023-08-24 06:11 -0700
  Re: Hibernate get fields Arne Vajhøj <arne@vajhoej.dk> - 2023-08-25 19:58 -0400

csiph-web