Re: [dtp-dev] documentation

[Ritika Maheshwari <ritikam@xxxxxxxxxx>]

Actually if I remove the second  name
column from select list (d.name) then too I get the same output.I was setting
the SQLQuerySourceFormat  to SQLSourceFormatDefault. There is no particular
reason to not qualify the from clause.

The weird thing is that if I write the
following code

SQLQueryParserManager manager = new SQLQueryParserManager();
SQLQueryParserFactory factory = new SQLQueryParserFactory();
manager.setParserFactory(factory);
SQLQuerySourceFormat sourceFormat = null;
sourceFormat = SQLQuerySourceFormat.copyDefaultFormat();
List postProcessorList;
postProcessorList = new Vector();
SQLQueryParseResult result = manager.parseQuery("select avg(e.salary),ritikam.e.name ,ritikam.e.id from Employee e group by ritikam.e.name having ritikam.e.no > 9 order by ritikam.e.name ");
result.getSQLStatement().getSQL();

Then the output is
 
SELECT AVG(SALARY), RITIKAM.E.NAME, RITIKAM.E.ID
  FROM EMPLOYEE AS E
  GROUP BY RITIKAM.E.NAME
  HAVING RITIKAM.E.NO > 9
  ORDER BY RITIKAM.E.NAME

However if I add the following line to the above piece of code
   
manager.configParser(sourceFormat, postProcessorList)

The output becomes

SELECT AVG(E.SALARY), RITIKAM.E.NAME, RITIKAM.E.ID
  FROM EMPLOYEE AS E
  GROUP BY RITIKAM.E.NAME
  HAVING RITIKAM.E.NO > 9
  ORDER BY NAME

any suggestions?

ritika

Brian Payton/Santa Teresa/IBM@IBMUS
Sent by: dtp-dev-bounces@xxxxxxxxxxx

02/20/2009 12:13 PM

Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>

To	DTP development mailing list <dtp-dev@xxxxxxxxxxx>
cc
Subject	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
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev