Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » SQL Editor using ODA conx - 1 attachment
SQL Editor using ODA conx - 1 attachment [message #40655] Sun, 20 January 2008 16:18 Go to next message
Eclipse UserFriend
Originally posted by: none.none.com

Hi, All-

I'm new to DTP, and I've set up some sample Flat and JDBC ODA connections,
which all ping fine. But the SQL Editor won't allow me to select any ODA
connection to use for running an ad hoc query.

I've reviewed all the "intro" docs I can find relating to DTP, and I can't
find any info one way or the other concerning whether this should be
possible, or if not, then why.

I'm running Europa (3.3.1.1) on XP pro. Attaching a screecap of my plug-in
versions. Would someone kindly advise this newbie?

Best regards,
Elliott Wade

  • Attachment: dtpvers.JPG
    (Size: 185.59KB, Downloaded 246 times)
Re: SQL Editor using ODA conx - 1 attachment [message #40846 is a reply to message #40655] Fri, 25 January 2008 00:00 Go to previous message
Linda ChanFriend
Messages: 845
Registered: July 2009
Senior Member
Elliott,

The SQL Editor is, as implied by its name, specific for relational databases
and SQL statements. Thus it consumes the Database (JDBC) connection profile
type only (i.e. those listed under the "Databases" category folder in the
Data Source Explorer view) .
The ODA framework is for heterogenous data sources, which are not
necessarily SQL-based.
BIRT (www.eclipse.org/birt) on the other hand is an ODA consumer
application, and thus supports any DTP ODA provider. We are adding
integration in Ganymede (DTP 1.6) to allow an ODA consumer application to
consume the "Databases" connection profile type as well.

Linda
Re: SQL Editor using ODA conx - 1 attachment [message #589691 is a reply to message #40655] Fri, 25 January 2008 00:00 Go to previous message
Linda ChanFriend
Messages: 845
Registered: July 2009
Senior Member
Elliott,

The SQL Editor is, as implied by its name, specific for relational databases
and SQL statements. Thus it consumes the Database (JDBC) connection profile
type only (i.e. those listed under the "Databases" category folder in the
Data Source Explorer view) .
The ODA framework is for heterogenous data sources, which are not
necessarily SQL-based.
BIRT (www.eclipse.org/birt) on the other hand is an ODA consumer
application, and thus supports any DTP ODA provider. We are adding
integration in Ganymede (DTP 1.6) to allow an ODA consumer application to
consume the "Databases" connection profile type as well.

Linda
Previous Topic:Can't see SQL Query Parser classes (install probs?)
Next Topic:Problem with Data Converter in XML ODA driver
Goto Forum:
  


Current Time: Tue Nov 24 23:57:11 GMT 2020

Powered by FUDForum. Page generated in 0.02401 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top