Book review. Java EE 6 Cookbook for Securing, Tuning, and Extending Enterprise Applications

Hi. Have just finished reading "Java EE 6 Cookbook for Securing, Tuning, and Extending Enterprise Applications".

A good book to scratch the surface from the J2EE development. It gives you an overview of J2EE 6 and gives you direction to further investigation. The cons of this book are a tutorial style which describes how to do something in different containers. In my opinion this information can be obtained from the documentation to that containers.

MySQL table size statistics

If you need to monitor and analyze your MySQL databases size over time you can automate this process.
1) create the database
CREATE DATABASE stat   DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

2) create the table
CREATE  TABLE `stat`.`sizeTable` (
  `idsizeTable` INT NOT NULL AUTO_INCREMENT ,
  `insertdate` DATE NOT NULL ,
  `databaseName` VARCHAR(45) NOT NULL ,
  `sizeMB` DOUBLE NOT NULL ,
  PRIMARY KEY (`idsizeTable`) ,
  INDEX `dateIndex` (`insertdate` ASC) )
ENGINE = InnoDB;

3) schedule the sql to collect statistics:
create event stat_db_evt
on schedule
every 24 hour
do
insert into stat.sizeTable (insertdate,databaseName, sizeMB) SELECT NOW() as insertdate, table_schema databaseName, sum( data_length + index_length ) / 1024 / 1024 sizeMB  FROM information_schema.TABLES GROUP BY table_schema;

Thar is all. This script will run every 24 hours and collect the statistics into the table, which you can analyze later.

Java forever

OCPJP 7 Passed!

Yesterday I have passed 1z0-804 and earned the OCPJP status! Yeah!
So, what did I use for my preparation:

1. Book Oracle Certified Professional Java SE 7 Programmer Exams by Ganesh and Sharma.
2. Tests from http://enthuware.com.

It took me 3 months for preparation.

Tomcat JDBC Connection Pool

One of the notable features of Tomcat is Tomcat own JDBC pool implementation org.apache.tomcat.jdbc.pool.
Here is an interesting article about it http://www.tomcatexpert.com/blog/2012/01/24/using-tomcat-7-jdbc-connection-pool-production.

Java 7 Concurrency Cookbook

Have read Java 7 Concurrency Cookbook.
A very good book about concurrency in Java.
Every feature is accompanied with an example.
Most important thing is that examples are clear and resemble some real problems.
When working with an examples one should be very careful, because of the typos in the text. So it's better to consult errata on the publisher's site.
Also you can get 2 free chapters and source code on the publisher's site.

Spring WS 2.1.0. Expose WSDL with external schema.

It is a good practice to keep schema external to your wsdl.
In Spring WS documentation it is not clearly mentioned how to publish wsdl with external schema.
After some time searching google i managed to found the solution:
<!-- WSDL -->
  <sws:static-wsdl id="BookingFacadeService" location="/WEB-INF/wsdl/BookingFacadeService.wsdl"  />
 
<!-- Schema -->
  <bean
        id="BookingFacadeService_schema"
        class="org.springframework.xml.xsd.SimpleXsdSchema">
        <property
            name="xsd"
            value="/WEB-INF/wsdl/BookingFacadeService_schema.xsd">
        </property>
    </bean>

BookingFacadeService.wsdl is my wsdl which include the external schema BookingFacadeService_schema.xsd.

Manipulate XML with Ant

Sometimes it is necessary to manipulate xml configs with Ant.
This can be done with XMLTask. A great tutorial about this ant task can be found here.

Software in Government

Did you know that http://dorogi.mos.ru is made with:
1) Spring security
2) Apache Wicket
3) Oracle Application Server 11.

Future of Web

Mozilla recently publish the blog note about the web as a future gaming platform. This is really takes the breath away. Watch here.