This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to change jdbc password dynamically?

 
ubri fra
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I need to find a way to change the jdbc password dynamically every quarter and at runtime without lost active connection already in the pool (obviously without restert services, JVM).

Thanks a lots.
Sterzo
 
Ramakanta Sahoo
Ranch Hand
Posts: 255
Fedora Firefox Browser Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can change it via wlst like below but I don't think WITHOUT server restart all changes will take effect. Dynamic changes usually dont need a restart but if its an non-dynamic then yes you have to restart

serverConfig()
edit()
cd('JDBCSystemResources/JDBC Data Source-0/JDBCResource/JDBC DataSource-0/JDBCDriverParams/JDBC Data Source-0')
startEdit()
cmo.setPassword('*****')
activate()
Activating all your changes, this may take a while ... The edit lock associated with this edit session is released once the activation is completed.

If you get any non-dynamic ds entries password changed then you must restart the server to make this effective.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic