Configure Log4j - Hibernate Sql Query, Spring

log4j.properties - MyWebApp/src - MyWebApp - webapplication Name

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
log4j.rootLogger=info, stdout
log4j.additivity.org.hibernate.SQL=true
log4j.logger.org.springframework=INFO
log4j.logger.org.springframework.aop=DEBUG

Loggin Hierarcy:-

Debug
Info
Warn
Error
Fatal

Container Managed Security in Tomcat 6.0 By Datasource Realm

In Tomcat/conf/server.xml

Hibernate RelationShip

Both uni direction and bi direction
a.one-to-one
b.one-to-many
c.many-to many

Hibernate Concepts

1.Table RelationShip ( one-to-one, one-to-many,many-to-many ) Uni direction and bi direction
2.

JSF 2.0 + Richface 4.0 config

1. com.sun.facelets.FaceletViewHandler is not required in faces.config.xml
2. jsf-facelet.jar not required in library.
3. richface ajax4jsf filer not required in web.xml

J2EE clarification

1.What type of table are used in production? innob,Heap,

MySql java.lang.ClassNotFoundException: org.aspectj.lang.Signature

Problem:-   MySql java.lang.ClassNotFoundException: org.aspectj.lang.Signature

Stack Trace -
Exception in thread "main" java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at database.ConnectionTesting.main(ConnectionTesting.java:17)
Caused by: java.lang.ClassNotFoundException: org.aspectj.lang.Signature
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    ... 3 more

Solution:- Need to use mysql-connector-java-5.0.8-bin.jar. Here we need to use appropiate thin driver. MySql shipped with two thin driver.  1. mysql-connector-java-5.0.8-bin-g.jar 2. mysql-connector-java-5.0.8-bin.

Install MySql Instance in Microsoft Windows 7 with 64 bit

1.Download MySql Installer ( mysql-5.5.9-winx64.msi) From   - http://dev.mysql.com/downloads/mysql/
2.Install MySql. This is Important point don't give default folder Name. Change the name Like MySQL Server5. it should not finish like 5.5
3.On continue to above install my sql Instance. End of installation you need to give username and password. Just remember that.( better to give admin/admin)

 Go to windows command prompt

4. Execute following command ( Login into mysql ):- mysql -u root -p mysql
5. To Create database schema   Execute this :- use mydatabase ( mydatabase is database name )
6. Granting permission to admin for mydatabase schema :- GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'admin' WITH GRANT OPTION;
7. Connect this database from external system by following credentials
Database: mydatabase
URL: jdbc:mysql://localhost:3306/mydatabase
userName: admin
Password: admin


8.Now you are able to create table and persist into it. all the best.


Known Problems:-
1.If you give you default my sql name like *5.5 it will hangup while execute. 
2.After Uninstall windows 7 won't remove service from registry. it may be bug. Here how to remove manually:
go to windows command prompt and enter: regedit and Computer>HKEY_LOCAL_MACHINE>System>CurrentControlSet>Service>MySql.


Find MySql and remove manually.
3.While Uninstall you can remove software data by following:-
windows command prompt and enter: %ALLUSERSPROFILE% and remove MySQL related data.





.