Constructing the Database Connection String Dynamically at Run Time

[ajaxjagadish1]

Hello,

Im developing a project where in the connection to DataBase is static i.e Im hard coding the details of the database in createConnection() method.
Now Im required to dynamically connect to a database i.e in the first page of my project, the user enters the database details(servername,port,username,passowrd,servicen ame) and using this details my project should be connected to respective database.

One solution to this is to have my createConnection() method as createConnection(String serverName,String portNumber,
String userName,String pword,String s_id).
But my project is very vast and everywhere I have used createConnection() to connect to database, changing this method to createConnection(String serverName,String portNumber,
String userName,String pword,String s_id) everywhere is not possible.
So im looking for an alternative solution.
Thanks in Advance :-)

P.S: The project may be accessed by more than one user, so I cannot store the database details in a file and then use this file to retrieve the information.

[Tolls]

What sort of app is this?
Desktop, web?

[ajaxjagadish1]

Hi Tolls, Thanks for the reply...It's a Web application developed using struts framework.

[ajaxjagadish1]

My web application connects to a database. I have a DAOFactory class where in I have createConnection() method that connects to the database. I have many classes in my project which uses this method to connect
to the database. Now I have been given a requirement like, my application should connect to the database to which the user wants to connect.
So now the first page of my project is a form wherein the user will enter the Database information(servername,port,username,passowrd,sid) .
Depending on this info provided by the user my project should work on this DB which the user has given the details about.

Now, since I have to connect to database which user want I need to have the createCOnnection() method as
createConnection(String serverName,String portNumber,String userName,String pword,String s_id)
but changing replacing the former with the latter in the project is not possible. So im looking for a solution for this which should work even when multiple users acces my application.


P.S: Static variables cannot be used to store the servername,port,username,passowrd and sid since this case would fail when multiple users acces my application.

[Tolls]

Why can't you change the method signature?

[ajaxjagadish1]

That's not possible...I have a vast project.

[Tolls]

Where is the createConnection() method?
Is it a static method or is it part of an object?

[ajaxjagadish1]

it is part of object...

[d3n1s]

ever heard of refactoring? It wouldn't be THAT difficult to change all your methods...

[Tolls]

And that object is created when?
You;re going to have to give us more of a design here, as otherwise this could take some time to get to a solution.

If you create a DB-connection-making-object once per session then simply give that class a constructor that takes those connection parameters.