Sql query to list rowcount for all table in schema

Some times we face problems that require to find no. of rows in all tables in schema .

Following are sql queries that list table name and their row count,

For Microsoft SQL Server:

SELECT distinct(t.name) AS table_name,i.rows
FROM sys.tables AS t
INNER JOIN sys.sysindexes AS i ON t.object_id = i.id
 

For Oracle

select table_name,num_rows counter
from dba_tables 
where owner = 'XXX'
order by table_name;

Hotdeployment of properties file

Hi,
     In last month we faced another Internationalization problem with properties file hot deployment. Hot deployment is commonly used to deploy updates for live web-application.
    The problem was when we hot deployed web-app the messages of  new screen are not pulled from corresponding properties file. ResourceBundle unable to find new keys ,leading to all labels are showing keys. But when we restarted server the messages are shown perfectly.
     After analyzing we realized that the properties file are not reloaded after hot deployment while all other classes are reloaded properly.This is because of ResourceBundle class, it caches properties file on read and returns retrieve strings from cache. When the class redeployed this cache remain untouched.
     The solution to this to clear this cache. we added static block in our class to clear ResourceBundle cache.
following is the code we currently using :

package com.example;<br /> <br /> import java.lang.reflect.Field;<br /> import java.util.Locale;<br /> import java.util.Map;<br /> import java.util.MissingResourceException;<br /> import java.util.ResourceBundle;<br /> <br /> public class I18NMessages {<br /> <br /> private static String localeCountry = "US";<br /> <br /> private static String localeLang = "en";<br /> <br /> /**<br /> BUNDLE from where the messages will be loaded. Currently set to:<br /> localizationmessages.properties<br /> */<br /> <br /> private static final String BUNDLE_NAME = "com.example.localizationmessages";<br /> <br /> /**<br /> Loads the properties file in the Bundle when the class is loaded.<br /> */<br /> <br /> private static final ResourceBundle RESOURCE_BUNDLE = ResourceBundle<br /> .getBundle(BUNDLE_NAME, new locale(localeLang, localeCountry),<br /> Thread.currentThread().getContextClassLoader());<br /> <br /> /**<br /> * Private constructor.<br /> */<br /> private I18NMessages() {<br /> }<br /> <br /> /**<br /> Static block to clear the cacheList of ResourceBundle to pick up the<br /> changed properties during hot deployment. This code block is just to make<br /> sure that hot deployment of properties work.<br /> */<br /> <br /> static {<br /> System.out.println(" Cleaning Resource Bundle's Cache.");<br /> Class resourceBundleClass = ResourceBundle.getBundle(BUNDLE_NAME)<br /> .getClass().getSuperclass();<br /> Field field;<br /> try {<br /> field = ResourceBundle.class.getDeclaredField("cacheList");<br /> field.setAccessible(true);<br /> Map cacheList = (Map) field.get(null);<br /> cacheList.clear();<br /> } catch (Exception e) {<br /> e.printStackTrace();<br /> }<br /> System.out.println(" Done Cleaning Resource Bundle's Cache.");<br /> <br /> }<br /> <br /> public static String getString(String key) {<br /> <br /> try {<br /> return RESOURCE_BUNDLE.getString(key);<br /> } catch (MissingResourceException e) {<br /> log.warn("Found no entry in I18N Messages for KEY: " + key);<br /> return '!' + key + '!';<br /> }<br /> }<br /> }<br /> <br />