I'm wondering if there's anyway of suspending / returning to weblogic 10 jdbc datasources through the command line. I know will be able to do that within the admin console, but because our application has numerous different datasources it's a little of the discomfort.
The explanation for this really is our testers do error flow tests and also have to simulate the db heading down. Ideally i must give a softball bat apply for suspending all datasources and the other one for returning to all datasources.
You should use the WLST scripting to achieve that. In the command line, run $BEA_HOME/wlserver10./common/bin/wlst.sh (.cmd on Home windows): Connect with the running server. Make use of the handled server port because this is a server runtime property:
Visit the serverRuntime tree: wls:/mydomain/serverConfig> serverRuntime()
Visit the JDBCService, for your handled server title, the JDBCDataSource Runtime and lastly for your datasource title:
Then just suspend and resume it:
wls:/mydomain/serverRuntime/JDBCServiceRuntime/managedsrv1/JDBCDataSourceRuntimeMBeans/MyDS> cmo.suspend() wls:/mydomain/serverRuntime/JDBCServiceRuntime/managedsrv1/JDBCDataSourceRuntimeMBeans/MyDS> cmo.resume()
use command ls() to determine the another variables and procedures.