Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » JPA Catalog Explorer and JPQL Query Builder
JPA Catalog Explorer and JPQL Query Builder [message #50731] Wed, 08 October 2008 07:27 Go to next message
Eclipse User
Originally posted by: philippeweber57.yahoo.fr

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
Re: JPA Catalog Explorer and JPQL Query Builder [message #50926 is a reply to message #50731] Wed, 15 October 2008 20:39 Go to previous messageGo to next message
Brian Payton is currently offline Brian Payton
Messages: 152
Registered: July 2009
Senior Member
Can you describe how JPQL is similar or different from standard SQL?

Suggestions (and patches) on how to generalize the SQL Query Builder to
handle more SQL (or semi-SQL) dialects would be welcome.

Philippe Weber wrote:
> 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
Re: JPA Catalog Explorer and JPQL Query Builder [message #50953 is a reply to message #50926] Thu, 16 October 2008 15:06 Go to previous message
Neil Hauge is currently offline Neil Hauge
Messages: 469
Registered: July 2009
Senior Member
Brian,

The main conceptual difference between JPQL and SQL is that JPQL queries
are defined against JPA entities (objects), as opposed to being directly
written against a database schema. When data needs to be stored or
retrieved from a relational database a JPA runtime will generally do this
on the back-end via SQL.

Take a look at this article for the basics on JPQL and how it relates to
SQL - http://www.oracle.com/technology/pub/articles/vasiliev-jpql. html

Neil

Brian Payton wrote:

> Can you describe how JPQL is similar or different from standard SQL?

> Suggestions (and patches) on how to generalize the SQL Query Builder to
> handle more SQL (or semi-SQL) dialects would be welcome.

> Philippe Weber wrote:
>> 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
Re: JPA Catalog Explorer and JPQL Query Builder [message #593552 is a reply to message #50731] Wed, 15 October 2008 20:39 Go to previous message
Brian Payton is currently offline Brian Payton
Messages: 152
Registered: July 2009
Senior Member
Can you describe how JPQL is similar or different from standard SQL?

Suggestions (and patches) on how to generalize the SQL Query Builder to
handle more SQL (or semi-SQL) dialects would be welcome.

Philippe Weber wrote:
> 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
Re: JPA Catalog Explorer and JPQL Query Builder [message #593562 is a reply to message #50926] Thu, 16 October 2008 15:06 Go to previous message
Neil Hauge is currently offline Neil Hauge
Messages: 469
Registered: July 2009
Senior Member
Brian,

The main conceptual difference between JPQL and SQL is that JPQL queries
are defined against JPA entities (objects), as opposed to being directly
written against a database schema. When data needs to be stored or
retrieved from a relational database a JPA runtime will generally do this
on the back-end via SQL.

Take a look at this article for the basics on JPQL and how it relates to
SQL - http://www.oracle.com/technology/pub/articles/vasiliev-jpql. html

Neil

Brian Payton wrote:

> Can you describe how JPQL is similar or different from standard SQL?

> Suggestions (and patches) on how to generalize the SQL Query Builder to
> handle more SQL (or semi-SQL) dialects would be welcome.

> Philippe Weber wrote:
>> 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
Previous Topic:Is org.eclipse.datatools.sqltools.parsers.sql.query.vendorExtension used ?
Next Topic:standalone sync plugin
Goto Forum:
  


Current Time: Fri Aug 01 12:13:26 EDT 2014

Powered by FUDForum. Page generated in 0.02177 seconds