This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Active Query Builder-Product Question!

 
palla sridhar
Ranch Hand
Posts: 111
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Sergey Smagin
Acitve Query Builder Support
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic