Meaningless Drivel is fun!*
The moose likes IDEs, Version Control and other tools and the fly likes Active Query Builder-Product Question! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Active Query Builder-Product Question!" Watch "Active Query Builder-Product Question!" New topic
Author

Active Query Builder-Product Question!

palla sridhar
Ranch Hand

Joined: Oct 15, 2007
Posts: 111
Hello Sergey,
Very nice to promote your software on java ranch.

Can you please tell me what is the difference between your product and other products?
Also how fast and easy can SQL developers adopt this product?
Can we develop PL/SQL queries on this?
How to use this product with common databases like Oracle, DB2, MySQL etc


Thanks and Regards,
[url]www.techlikes.com[/url]
*Nothing is CONSTANT in life, except CHANGE*
Sergey Smagin
Acitve Query Builder Support
Greenhorn

Joined: Apr 23, 2009
Posts: 3
Hello Palla,

Thank you for your interest to our product and for your questions.

Can you please tell me what is the difference between your product and other products?

First of all, we did not find any other products with similar functionality for Java. There are some query builders to build simple SQL queries programmatically, there are some implementations of visual query building functionality, but they aren't present as Java beans. Please correct me if I mistaken.

Our component allows visual building of complex SQL queries (with unions, sub-queries, derived tables and many fine points of different SQL dialects) for most of today popular database servers, including Oracle, DB2, MySQL, etc. Also Active Query Builder has fast and sophisticated SQL parser, so it's normal practice to combine visual query building with direct SQL text editing. Of course, the component can be used to analyze, modify or create SQL queries programmatically from scratch.

Also how fast and easy can SQL developers adopt this product?

The Quick Start Guide for Active Query Builder consists of several simple steps, so I hope there shouldn't be any problems with that. We provided various demo projects to illustrate all other aspects of Active Query Builder's functionality.

Can we develop PL/SQL queries on this?

The component has full support of Oracle SQL syntax. However, you should note that the component is capable to build only single SELECT statements, so if you need to develop an SQL script builder, you'll have to implement some additional steps to extract single SELECT statements and pass them to the visual query builder and back.

How to use this product with common databases like Oracle, DB2, MySQL etc

Active Query Builder has a syntax provider for each supported database server, so the component will generate server-specific queries depending on the syntax provider being used.

Should you have any other questions, please do not hesitate to ask.


Active Query Builder Java Edition - Javabean to parse and build SQL queries visually.
 
 
subject: Active Query Builder-Product Question!
 
Similar Threads
OutOfMemoryError when using ResultSet
Copy field in the same table
What can I do to pre-select something from database?
Importing a SQLServer Schema using java
What can I do to pre-select something ?