I'm going to start my first project with Java
Let me know how I was handling These things ... So far, I am working on APP, which is the Com + Component created with VB6.
The component is registered through com + a console admin user with a domain, some lile my_company_domain \ my_app_account
Component is configured to reach DB with integrated security udl Reads the configuration from the file.
I call the server from ASP .createobject, the component runs with the specified domain account, and therefore every DB access goes with this account ...
This approach What I like from:
-
Use of integrated security - Any SQL user
-
DB (edit udl file) or domain There is no need to recompile anything to change the account (edit the COM + component configuration)
-
Collected connections (as I am always using the same connection string)
-
Change the configuration without leaving the account password on the production staff text file
...
> Well, what would be the best way to achieve something like this on Java ???
I have already seen something about Commons-DBC, is it possible to use integrated security with this ???
Thank you very much ...
-
Added to the reply to a comment
By Integrated Security I mean that I Configure only one domain account, and that is, I do not use any SQL Server accounts, only the account under which VB6 com + component is run.
OK, maybe it might not be an epuprove word, but I hope you think ...
- Data source & amp; Configure Connection bridge on the app-server side.
- Get a datasource from the JNDI environment with your web-application.
Comments
Post a Comment