<!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;">
CAN'T CHANGE DB PASS WHILE JBOSS RUNNING ????? HELP ????
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/dryna">marcin van dei</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/592412#592412">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>we have a situation in which we must allow database password change (ORACLE DB)  while Jboss server is running. </p><p>I'm trying to do it by using JAAS login modules: </p><p>- I've created a module which loges me in (works) </p><p>- I've created an password vault which changes password in DB and gives me the new password (works in background)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>So far so good - everything works fine. I can change password and work on the server - no problem. </p><p>The problem starts when jboss looses the connection (session) to DB (for example iddle time reason) - it then (I'm guessing) tries to connect again using old credentials and thus locks my account. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Is there any way to get this working ? </p><p>I have few ideas which could help me out, but I'm not that good with Jboss. Can  anybody help please ? </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>- if Jboss did not use (cached?) credentials to create new connections in case they are snipped </p><p>(setting parameter DefaultCacheTimeout to 0 does not help, still get the:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>2011-03-10 12:33:09,889 INFO  [STDOUT:156] [Thread-18]    ----------   sqlQuery: ALTER USER user IDENTIFIED BY counter3</p><p>2011-03-10 12:33:13,857 INFO  [STDOUT:156] [EJB-Timer-1299756281646[target=jboss.j2ee:ear=auc-server.ear,jar=gastro_keymanagement.jar,name=StatusRepositoryService,service=EJB3]]     !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!         PASSWORD USED: counter3</p><p>2011-03-10 12:33:13,888 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool:363] [EJB-Timer-1299756281646[target=jboss.j2ee:ear=auc-server.ear,jar=gastro_keymanagement.jar,name=StatusRepositoryService,service=EJB3]] Throwable while attempting to get a new connection: null</p><p>org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-01017: invalid username/password; logon denied</p><p>)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>here STDOUT prints what's done on DB (alter user)  and password used by login modules to log in. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>- if jboss did not lost the DB connections at all this would help too, i guess (setting DB parameter IDLE_TIME to huge number of minutes did not help neither - got the same login error. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>It looks to me as Jboss uses some old password (cached?) when trying to reconnect lost sessions (new sessions seem to be getting correct password and they connect to DB ok).  How does this work ? </p><p>Is there a solution to my problem ?  can DB pass be changed safely without the risk of locking the account ? </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    PLEASE HLEP!!! </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>thank you </p><p>martin</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/592412#592412">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>