Our company code base still has some code that will create the database, tables, stored procedures and the like.Coding the SQL stored procedures line by line in Java, in string format is a real pain.
I was wondering if those out there using alternative methods are willing to give me some pointer in case I'd like to optimize the current code / process. What alternative techniques or possibly pre-existing tools could be used that are useful or popular?
The last couple of years our focus has been more on getting skilled in web development technologies, and we have not given much attention to the maintainability of our stand alone applications, that are years old.
in terms of maintainability I mean readability and how easy it is to make changes and deploy them to the client site.