Skip to main content


Eclipse Community Forums

      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 11: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 310 times)
Re: SQL Editor using ODA conx - 1 attachment [message #40846 is a reply to message #40655] Thu, 24 January 2008 19:00 Go to previous message
Eclipse UserFriend
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] Thu, 24 January 2008 19:00 Go to previous message
Eclipse UserFriend
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: Fri Apr 25 20:17:47 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly