Is it possible to use integrated login in web app deployed on GlassFish web container? Clients are Microsoft Domain users; SQL Anywhere database server and GlassFish server are working on the same computer. I can do it when I map 'SYSTEM' ID to 'DBA' for instance, but it doesn't make sense, because I would like to control which MS Domain user is operating on database. Thanks for your patience.
asked 29 Jun '13, 11:53
I assume Glassfish is connecting over JDBC to SQL Anywhere (either SAJDBC or jConnect?)
What is the login mechanism for users connecting to the Glassfish server? If users aren't even logging in over a domain login mecahnism (e.g. NTLM), there won't be any chance for Glassfish to pass them along to the JDBC information.
As far as I'm aware, the JDBC driver connection username/password information for the Glassfish server is hard-coded in the server configuration - this doesn't allow you to dynamically map usernames to JDBC connection information at runtime. It seems that you can dynamically reconfigure the JDBC pool information, but it looks like these types of operations will destroy the pool each time, which wouldn't be very effective for each user logging in...
This seems to be more of a Glassfish question as to how to pass NTLM information to the JDBC connection - perhaps you could try the Glassfish forums?
answered 04 Jul '13, 10:40