java.net.BindException: Address already in use: JVM_Bind:8080

This occurs when 8080 port is already used by other application. Check the server.xml in tomcat and change the port as shown below.



this should solve the java.net.BindException: Address already in use: JVM_Bind :80

happy deployment :)

Get table count in MySQL

I was looking for this and got idea from Roland Bouman forum http://forums.mysql.com/read.php?100,48568,48737#msg-48737. Thanks Naveen for (the second query) letting me know this.
1)
select count(*) as number_of_tables from information_schema.tables
where table_schema = 'my_database_schema' and table_type = 'BASE TABLE'
2)
select TABLE_SCHEMA, TABLE_TYPE, ENGINE, count(1)
FROM information_schema.tables GROUP BY TABLE_SCHEMA, TABLE_TYPE, ENGINE;