| How to use modelbase standalone [message #21687] |
Fri, 22 September 2006 06:32  |
Eclipse User |
|
|
|
Originally posted by: yavin.gmx.com
Hello,
is it possible to use the SQL statement model in the modelbase
standalone? We are searching for a lib that gives the programmer an easy
API to create complex SQL statements without actualy writing SQL code.
Additionally it would be fantastic if the lib knows about the db schema
and could validate the SQL statement during creation.
Could we use some of the DTP parts for that approach? Do someone know an
alternative?
Regards, Kai
|
|
|
| Re: How to use modelbase standalone [message #21732 is a reply to message #21687] |
Fri, 22 September 2006 20:26  |
| Eclipse User |
|
|
|
Originally posted by: jograham.sybase.com
Kai wrote:
> Hello,
> is it possible to use the SQL statement model in the modelbase
> standalone? We are searching for a lib that gives the programmer an easy
> API to create complex SQL statements without actualy writing SQL code.
> Additionally it would be fantastic if the lib knows about the db schema
> and could validate the SQL statement during creation.
> Could we use some of the DTP parts for that approach? Do someone know an
> alternative?
> Regards, Kai
Hi Kai,
If by "standalone" you mean still in Eclipse with EMF but not the rest of
DTP (connectivity, SQL Dev), then the answer is "yes." The SQL model
consumes a JDBC connection, so, as long as you can provide that, you can
use the model. A SQL model instance for a given JDBC connection knows
about the meta-data, and the SQL Query model uses the SQL model. While
there is no automatic validation like you describe above, all of the
necessary pieces should be there to do so.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
|
|
|
| Re: How to use modelbase standalone [message #21777 is a reply to message #21732] |
Mon, 25 September 2006 05:47 |
| Eclipse User |
|
|
|
Originally posted by: yavin.gmx.com
Hey Graham,
thanks very much for your answer.
> If by "standalone" you mean still in Eclipse with EMF but not the rest
> of DTP (connectivity, SQL Dev), then the answer is "yes."
I mean standalone with all necessary dependencies like EMF but maybe not
in an Eclipse env.
> The SQL model
> consumes a JDBC connection, so, as long as you can provide that, you can
> use the model. A SQL model instance for a given JDBC connection knows
> about the meta-data, and the SQL Query model uses the SQL model. While
> there is no automatic validation like you describe above, all of the
> necessary pieces should be there to do so.
Okay that sounds good. Could you give me a short code example how to use
the model with a JDBC connection? I read the UML docs and the reference
but it seems I didn't hit the right pages.
THX is advance.
|
|
|
| Re: How to use modelbase standalone [message #582391 is a reply to message #21687] |
Fri, 22 September 2006 20:26 |
 John Graham
Messages: 183
Registered: July 2009 |
Senior Member |
|
|
Kai wrote:
> Hello,
> is it possible to use the SQL statement model in the modelbase
> standalone? We are searching for a lib that gives the programmer an easy
> API to create complex SQL statements without actualy writing SQL code.
> Additionally it would be fantastic if the lib knows about the db schema
> and could validate the SQL statement during creation.
> Could we use some of the DTP parts for that approach? Do someone know an
> alternative?
> Regards, Kai
Hi Kai,
If by "standalone" you mean still in Eclipse with EMF but not the rest of
DTP (connectivity, SQL Dev), then the answer is "yes." The SQL model
consumes a JDBC connection, so, as long as you can provide that, you can
use the model. A SQL model instance for a given JDBC connection knows
about the meta-data, and the SQL Query model uses the SQL model. While
there is no automatic validation like you describe above, all of the
necessary pieces should be there to do so.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
|
|
|
|
Powered by
FUDForum. Page generated in 0.03381 seconds
] 
Search
Help
Register
Login
Home
