• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Active Query Builder-Product Question!

 
Ranch Hand
Posts: 111
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Acitve Query Builder Support
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic