Just wondering any comments on my proposal ? I will definitely support the application. I think it will benefit to the developers and user community as basically no coding (no jsp/java/html) is needed to bring up the application. The most important it is Open source and not tied to any vendor's framework.
Regards, Stephen -----Original Message----- From: Stephen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 6:22 PM To: [EMAIL PROTECTED] Cc: Noel J. Bergman Subject: RE: Questions about donating code Hello, Below is my proposal on DB project. Background: This project is intended to build a single table maintenance Java based Web application on fly without coding (or with minimum coding). As a developer, we always come across requests from our employer or customers to build a simple maintenance web application. The task is not complex but it is tedious. Developer have to deal with paging, SQL, validation, conversion, presentation, searching, ordering, editing, performance, updating, logging and security etc. This project is intended to facilitate developers to build this kind of application with minimum coding effort (or no coding effort at all) so they can focus on more important issues. I have built a working prototype which will support Oracle, NCR Teradata, Microsoft SQLServer and MySQL dbs with all the mentioned functions. It is a very lightweight application. It makes use of Struts and Log4j. I would like to donate the code as I think it will be benefit to the developers and users community. Thanks, Stephen -----Original Message----- From: Noel J. Bergman [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 12:15 AM To: Stephen Cc: [EMAIL PROTECTED] Subject: RE: Questions about donating code As others have said, you want to contact the Incubator. I'll tell you that we will be looking for support from within the ASF for adopting your project, and a community. You should probably check with the DB project to see what interest is there. Also, you should look at existing ASF projects to see where you may have some overlap. --- Noel -----Original Message----- From: Stephen [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 21:18 Subject: Questions about donating code Hello, My name is Kam Fu. I would like to donate the source codes for the tool I just created to the community. However, I am not quite sure what procedure I should follow. Below is a brief description of the tool I created. 1) The tool is developed using JSP/Servlet/Java Classes/html. It uses Struts as Controller and Log4j for logging. 2) It allows developer to create a database maintenance web application on fly without coding. All the screen and database configurations can be specified in a xml files which can easily be generated by the tool I created. 3) It supports multiple databases i.e Oracle, Teradata, MySQL, MSSQL etc. Right now, it works for Oracle, Teradata, MSSQL and MySQL. 4) The web application contains list view which display the important information. The information shown on the list view can be configured via xml file. 5) It supports paging and allows user to view previous page, next page, first page and last page without maintaining an open cursor or using JDBC savepoint. 6) It provides simple cache algorithm to cache certain pages (forward and backward pages) as specified in a xml file to speed up paging. 7) It allows search and sort by different criteria as specified in xml file. It also support wildcard search, greater than, less than, Date searches etc. 8) It provides form view which display all the information from the table. 9) It allows user to edit and update the data in the form view. The key fields will be protected during editing. 10) It allows user to add a new records. 11) It provides a validation engine to validate the data. The validation rule can be specified in xml file. 12) It provides a conversion engine to convert the data to certain format (i.e CCYYMMDD hh:mm:ss to DDMMMCCYY etc). The conversion rule can be specified in xml file. 13) It also allows developer to develop a specific validation rule if needed. 14) It allows user to delete a record. 15) It provides logging to log the SQL statements or messages using log4j. 16) It allows developer to specify whether the input data need to be converted to uppercase in xml file. 17) It allows developer to specify which functions are allowed per table in xml file i.e list, view, add, update and delete. 18) All values of the html form, list heading, form description, drop down box etc can be specified in an xml file. 19) Developer can specify which fields allow edit. 20) It provides ability to reference other column from different table as specified in a xml file. 21) It provides performance measurement for database query/update as specified in a xml file. 22) It allows user to download data in text or Excel csv format. 23) It provides a very easy to use web interface. The application makes use of the following design patterns. 1) Factory method. 2) ValueListHandler. 3) Value Object. 4) Data Access Object. 5) Singleton. Basically, I can bring up any single table maintenance web app in less than 15 minutes with all the above functionality. Appreciate your advise. Stephen --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
