Hi,
in the scope of my project I'm customizing the SQL Query Builder from
DTP to leverage select statement creation, I created a custom dtp
enablement project as input for the Query Builder and I intend to use
JPA inside the catalog provider. Getting far from simple Database/SQL...
I found that the work done on modelbase for SQL is really great, and I'm
wondering how it could serve (as basis or example) JPA and JPQL more
generally.
One idea would be to have a JPA Source Explorer similar to display JPA
catalogs provided by plug-ins, and a JPQL Editor with a QueryBuilder
with correct content assist read from JPA catalogs (bundled in plug-in).
I don't know if JPA could be used as the input of DTP defining a
enablement project, or if a fully new datatools.modelbase.jpql and
datatools.jpqltools would be needed.
Maybe the experts could light me up on these part.
In a short term, I'll anyway need to tweak the SQL Query Builder for my
needs, maybe up to the parser. But thinking generally, maybe a part of
all this could be reused.
Any comments are welcomed.
Regards,
Philippe