2

I have created one application which can able to perform a DML operation on database. Now there is one condition the user created new table in that database(by using front-end) but that table is not accessible due to model class is not available, so there is any type of Framework in JAVA which can able to perform this type of operations without respective model classes dependencies.

In short there is any framework which handle all types of DLL and DML operation without model classes? i know its stupid question.

dhinchak developer
  • 141
  • 1
  • 7

1 Answers1

2

I'll provide an answer for a few APIs that you've tagged your question with, plus JDBC:

JPA

JPA requires a model at compile time (technically at the time when you load the entities), so it doesn't work well with ad-hoc models like yours. You could, of course, use runtime Java compilation and load those runtime generated entities dynamically, but that seems quite complicated.

jOOQ

jOOQ can work that way as stated e.g. in the tutorial. You can use jOOQ:

In jOOQ, generated code is completely optional, adding additional type safety to your client code, but you don't have to use it. All DDL and DML statements can be expressed with ad-hoc identifiers, or even plain SQL templating.

JDBC

When using Java/Spring/etc. you can always resort to using JDBC, the lower level API that is used by most of the above APIs behind the scenes. In Spring, there's also a thin API on top of JDBC called JdbcTemplate, which makes using JDBC a bit more convenient.

(Disclaimer: I work for the company behind jOOQ)

Lukas Eder
  • 211,314
  • 129
  • 689
  • 1,509