Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [dtp-dev] documentation

Ritika,

That looks like a bug since there are two "name" columns in your select list.  Go ahead and open a bug report in Bugzilla (bugs.eclipse.org).

I'm surprised the SQL is getting generated with some, but not all, of the identifiers quoted, including the function avg.  What options are you using?  Also, I'm wondering why you are using "ritikam" as a schema qualifier on some of the Employee columns, but not on the Employee table reference in the FROM clause.

Regards,
Brian

Brian Payton
SQL and XML Query Tools Development
IBM Silicon Valley Laboratory


Re: [dtp-dev] documentation

Ritika Maheshwari to: DTP development mailing list
02/20/2009 11:52 AM

Sent by: dtp-dev-bounces@xxxxxxxxxxx
Cc: DTP development mailing list, dtp-dev-bounces

Please respond to DTP development mailing list







Hi
      I am using the SQLQueryParserManager  to parse a query "select avg(e.salary),ritikam.e.name ,d.name,ritikam.e.id from Employee e, Department d group by ritikam.e.name  having ritikam.e.no > 9 order by ritikam.e.name ".

It parses ok but when  I try to get the SQL from the SQLQueryParseResult Object like  result.getSQLStatement().getSQL(). I get the following statement

SELECT "avg"(e."salary"), "ritikam"."e"."name", d."name", "ritikam"."e"."id"
 FROM Employee AS "e", Department AS "d"
 GROUP BY "ritikam"."e"."name"
 HAVING "ritikam"."e"."no" > 9
 ORDER BY "name"

Somehow the order by column is missing the qualifications.I tried playing around with the SQLQuerySourceFormat  which I pass to the ParserManager by setting the setting the qualifyIdentifiers value other than 0 (1,3).But that does not seem to help.

Any suggestions?

ritika

Hemant S Kolwalkar/Redmond/IBM@IBMUS
Sent by: dtp-dev-bounces@xxxxxxxxxxx

02/20/2009 10:58 AM

Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>
To
DTP development mailing list <dtp-dev@xxxxxxxxxxx>
cc
dtp-dev@xxxxxxxxxxx, dtp-dev-bounces@xxxxxxxxxxx
Subject
Re: [dtp-dev] documentation








Hi Ritika,

the SQL UML documentation is published at http://www.eclipse.org/datatools/project_modelbase/index.php

its at the bottom of the webpage.

thanks,

Hemant Kolwalkar

Data Management Tooling
IBM  Information Management
Seattle
tel : 1-206-587-5953 (T/L: 277-5953)
fax: 1-206-587-4415
Ritika Maheshwari/Santa Teresa/IBM@IBMUS
Sent by: dtp-dev-bounces@xxxxxxxxxxx

02/20/2009 10:24 AM

Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>
To
dtp-dev@xxxxxxxxxxx
cc
Subject
[dtp-dev] documentation







Where can I find documentation for the classes in org.eclipse.datatools.modelbase.* and org.eclipse.datatools.sqltools.parsrers.*. Could you please let me know the link

ritika_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev

Back to the top