I am going to start my first project using java
Let me tell you how I used these things ...
So far I have been working on asp with a lump + component created using VB6.
The component is registered through the com + admin console with a domain user, something lile my_company_domain \ my_app_account
Components read the configuration from the udl file configured to access the database with integrated security.
I call the component from asp using server.createobject, the component starts with the specified domain account, and therefore every access to the database is done with this account ...
I like this approach:
use of integrated security - no sql users
no need to recompile anything to change db (edit udl file) or domain account (change com + component configuration)
merged connections (as I always use the same connection string)
production personnel can change the configuration without leaving the account password in a text file
...
well, what would be the best way to achieve something like this in java ???
I already saw something in Commons-DBCP, is it possible to use integrated protection with this?
Thank you very much...
-
added in response to comment
Integrated protection I mean that I need to set up a domain account, and that I do not use SQL server accounts, but only the account under which the command + VB6 component is executed.
Well, maybe this is not a suitable term, but I hope you get the idea ...
source share