Eclipse Community Forums: DTP » Executing SQL statement

Help

Home

Home » Eclipse Projects » DTP » Executing SQL statement

Show: Today's Messages :: Show Polls :: Message Navigator

Executing SQL statement [message #51367]

Tue, 11 November 2008 17:08

Eclipse User

Originally posted by: andi.hotz.adsl.li

Up until now when I was interested in the contents of a table I accessed
the contents through an SQL statement using the java.sql.* package.
With DTP this is something like the flowing:

IConnectionProfile profile;
....
String sql = "select * from some_table";
Connection conn = (Connection)
profile.createConnection("java.sql.Connection").getRawConnection();
try {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()){
// something found found so do something
} else {
// nothing found so do something else
}
} catch (SQLException e){
e.printStackTrace();
}

I noticed there are classes/interfaces like
org.eclipse.datatools.modelbase.sql.query.impl.QuerySelectSt atementImpl.
How can I make use of this to access the data in my database table while
ignoring the underling connection infrastructure (JDBC connection will
only work if the data source driver is a JDBC driver).
So here is the question: How do I access my data in an abstract way?

I hope someone has some helpful thoughts.

Cheers

Andy

Report message to a moderator

Re: Executing SQL statement [message #51395 is a reply to message #51367]

Wed, 12 November 2008 02:25

Brian Payton

Messages: 154
Registered: July 2009

Senior Member

The Query model classes such as QuerySelectStatement are not really
intended to be used to access the data in your tables. They are used to
analyze and build SQL statements, particularly DML (Select, Insert,
Update, Delete).

If you want to work with your table data at a level of abstraction above
JDBC, you might want to look at the ODA (Open Data Access) component of
DTP. Other possibilities are non-Eclipse frameworks such as Spring and
Hibernate.

Andi Hotz wrote:
> Up until now when I was interested in the contents of a table I accessed
> the contents through an SQL statement using the java.sql.* package.
> With DTP this is something like the flowing:
>
> IConnectionProfile profile;
> ...
> String sql = "select * from some_table";
> Connection conn = (Connection)
> profile.createConnection("java.sql.Connection").getRawConnection();
> try {
> Statement stmt = conn.createStatement();
> ResultSet rs = stmt.executeQuery(sql);
> if (rs.next()){
> // something found found so do something
> } else {
> // nothing found so do something else
> }
> } catch (SQLException e){
> e.printStackTrace();
> }
>
> I noticed there are classes/interfaces like
> org.eclipse.datatools.modelbase.sql.query.impl.QuerySelectSt atementImpl.
> How can I make use of this to access the data in my database table while
> ignoring the underling connection infrastructure (JDBC connection will
> only work if the data source driver is a JDBC driver).
> So here is the question: How do I access my data in an abstract way?
>
> I hope someone has some helpful thoughts.
>
> Cheers
>
> Andy

Report message to a moderator

Re: Executing SQL statement [message #51423 is a reply to message #51395]

Wed, 12 November 2008 15:24

Shaun Smith

Messages: 197
Registered: July 2009

Senior Member

Brian Payton wrote:

> If you want to work with your table data at a level of abstraction above
> JDBC, you might want to look at the ODA (Open Data Access) component of
> DTP. Other possibilities are non-Eclipse frameworks such as Spring and
> Hibernate.

You certainly don't need to use Non-Eclipse frameworks for this. :-)

EclipseLink provides the Java Persistence API 2.0 reference implementation
and is available as either a set of OSGi bundles or as a plain Java jar.
If you're looking for object-relational mapping then check out EclipseLink
and the Eclipse Dali Java Persistence Tools project for intelligent design
time tooling.

--Shaun

http://www.eclipse.org/eclipselink
http://www.eclipse.org/dali

NB: Dali uses DTP for database and schema information!

Report message to a moderator

Re: Executing SQL statement [message #51479 is a reply to message #51423]

Wed, 12 November 2008 19:52

Eclipse User

Originally posted by: andi.hotz.adsl.li

Thanks for your tips

I had a look at ODA and found a lot of interfaces and could construct an
example to get my data starting from an IDriver. I could not figure out
how to retrieve any instance of this interface. Is there a way?

I also had a quick look at Eclipselink and Dali. Eclipselink is
certainly interesting but with the vocal point on databases perhaps not
the best choice. Dali seems a bit heavy weight with the installation of
an application server for JPA. I figure the interesting classes are in
the package org.eclipse.jpt.db. What I'm not sure about is if I can use
these classes without JPA since persistence is not my main focus.

So thanks again for your input

Andy

Shaun Smith wrote:
> Brian Payton wrote:
>
>> If you want to work with your table data at a level of abstraction
>> above JDBC, you might want to look at the ODA (Open Data Access)
>> component of DTP. Other possibilities are non-Eclipse frameworks such
>> as Spring and Hibernate.
>
> You certainly don't need to use Non-Eclipse frameworks for this. :-)
>
> EclipseLink provides the Java Persistence API 2.0 reference
> implementation and is available as either a set of OSGi bundles or as a
> plain Java jar. If you're looking for object-relational mapping then
> check out EclipseLink and the Eclipse Dali Java Persistence Tools
> project for intelligent design time tooling.
>
> --Shaun
>
> http://www.eclipse.org/eclipselink
> http://www.eclipse.org/dali
>
> NB: Dali uses DTP for database and schema information!
>

Report message to a moderator