Tuesday, 6 November 2012

Setting prepared statement cache size on JDBC datasources wsadmin

import re 
for dsName in 'BPEDB PerformanceDB PDWDB TwqlDB TeamWorksDB ProcessDB WPSDB'.split(): 
        for dataSource in AdminConfig.list('DataSource').splitlines(): 
                jndi= AdminConfig.showAttribute(dataSource, 'jndiName') 
                if(re.search(dsName, jndi)): 
                        print "Setting prepared statement cache "+jndi 
                        AdminConfig.modify(dataSource, '[[statementCacheSize "100"]]') 

AdminConfig.save()

No comments:

Post a Comment