SQL Query Builder [Off Topic]

[Howard Miller <h....@admin.gla.ac.uk>]

Hi,

This is completely off-topic, and I'm sorry in advance, but this is where
all the usefull people live!!!

Has anybody come accross a SQL query builder, or even query-by-example
builder in java. That is something to visually put together a query for
non-sql-savy users. Its to live in a Struts application, so must be
Servlet/JSP/Applet based. 

Trying to save myself some work!!

Howard Miller



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: SQL Query Builder [Off Topic]

[James Mitchell <jm...@telocity.com>]

Well, I'm pretty proficient in sql.  But for extremely complex queries that
require multiple outer joins (like more than 8 tables), I rely on the visual
query building capabilities of Visual Interdev (ya ya ya M$ sucks).

I'd love to hear about any open source project that can do what Interdev
does:

It gives you 4 panes.
1. Tables
2. Fields selected
3. Sql used
4. Results of query (if you run it)

Truly wysiwyg, drop a new table in the table pane, and all panes are
updated.  Modify the sql pane and all the other panes are updated as well.

When you connect to an ODBC source (yes, this requires ODBC, but the sql
generated works regardless) you can just drag in all the tables you want.
Add filter params and order by, do grouping, sum, count, whatever.

This also requires that you know your database relationships (to a certain
extent).  Interdev will read the metadata off the connection and do a best
guess based on

The reason I use Interdev is that it creates the vendor specific sql syntax,
which can be different for Oracle vs. DB2 vs. MySql

Then I just copy from the sql pane into my application (be it a resource
file or into the code) and I'm done.



James Mitchell
Software Engineer\Struts Evangelist
Struts-Atlanta, the "Open Minded Developer Network"
http://www.open-tools.org/struts-atlanta




> -----Original Message-----
> From: Howard Miller [mailto:h.miller@admin.gla.ac.uk]
> Sent: Tuesday, September 17, 2002 11:15 AM
> To: 'struts-user@jakarta.apache.org'
> Subject: SQL Query Builder [Off Topic]
>
>
> Hi,
>
> This is completely off-topic, and I'm sorry in advance, but this is where
> all the usefull people live!!!
>
> Has anybody come accross a SQL query builder, or even query-by-example
> builder in java. That is something to visually put together a query for
> non-sql-savy users. Its to live in a Struts application, so must be
> Servlet/JSP/Applet based.
>
> Trying to save myself some work!!
>
> Howard Miller
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>