Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to change jdbc password dynamically?

 
ubri fra
Greenhorn
Posts: 1
  • 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: 256
Fedora Firefox Browser Netbeans IDE
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic