Java process parameter driven

• Project ID:

  754081

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Need a java process to do the following:

Build SQL (generate SQL) based on selections made by a user. Users will submit their request (SELECT columns, WHERE clause filters) in a table. This process will scan the table, build the SQL dynamically and process the results against the DB. It will then produce a csv output from the SQL.


Following are the set of parameters:

- XML based list of tables / data model listing tables / join conditions (example "sales and marketing database tables VS. order databse"). Yes, there will be multiple Databases having different data models. This is the key to the project.
- Table where users will submit the SELECT and WHERE clause items (example columns to see = a, b, c, sum(d) and filters a = "chicago" ).

Output:

- The process will generate a complete SQL for each new request submitted (example i want to select column a, b, c, sum(d) WHERE a = "chicago" group by .....).
- Using a new thread, the process will execute the SQL against the DB
- The process will output the results to a CSV file


Ping me if you have any questions.

Regards,

Skills required:

J2EE, Java