<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
JAAS LoginModule as source of DB conn creds?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/stevemaring">Steve Maring</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/633098#633098">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p><span style="font-family: arial,helvetica,sans-serif;">Normally, we develop apps that use a single set of credentials to create database connections within the pool.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: arial,helvetica,sans-serif;">We specifiy those in the login.xml using SecureIdentityLoginModule</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: arial,helvetica,sans-serif;">Now, I'm developing an application that is for support personel.  They are granted specific write permission to the production database for short periods of time while they make specific modifications.  They connect with their own set of credentials.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: arial,helvetica,sans-serif;">So, I would like to prompt the user for their database credentials and use those as a basis for creating connections.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: arial,helvetica,sans-serif;">I know I could declare </span><code class="jive-code"><span style="font-family: arial,helvetica,sans-serif;"><application-managed-security/> in the datasource config, and then do a DataSource.getConnection(username,password) in my DAOs to get a connection, but I don't want to do straight JDBC.  I have a nice set of JPA entities and a whole bunch of criteria queries.</span></code></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Is there a way to have more control over the connection process, using a specific set of credentials at runtime, and still make use of EntityManager?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks for your thoughts.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>-Steve Maring</p><p>Tampa, FL</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/633098#633098">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>