• Post Reply Bookmark Topic Watch Topic
  • New Topic

DDL & DML executor  RSS feed

jeff rusty
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ranchers,

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.

It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!