I am trying to set up an installer for my application and in that i have to ask the user for the database he want to use for the application and the database parameters like URL,username and password.
So i wish to know if java can create a database user for the selected database and execute the application specific SQL scripts based on the given parameters. Also let me know if there are any other API which is available to do this?
So far i have done it only far oracle so i dint use any java code i used the SQLPlus client to create user and execute the SQL. Currently i need to provide support for SQLSERVER,MYSQL & Oracle.