An elegant solution

Hello All, What is SQLlite ? In my recent project I need to use SQL lite and hibernate, But Hibernate is not providing default dialect for SQLlite, so one need to write. SQL Lite Dialect. Enjoy.

Code Names Let us write down all java versions, its code name and release date Java 8: Spider - 18th March, 2014 Java 7: Dolphin - 28th July, 2011 Java 6: Mustang - 11th December, 2006 Java 5.0 (1.5): - Tiger - 30th September, 2004 J2SE 1.4: Merlin - 6th February, 2002 J2SE 1.3: Ketrel - 8th May, 2000  J2SE 1.2: Playground - 8th December, 1998 J2SE 1.1: 19 February 1997 JDK 1.0: Oak - 23 January 1996 Happy Reading...!!! Ref:Wikipedia

Connection pooling, but what it is and what it do ? It is set of database connections that can be used in future.  This connection can be used across many sessions, once execution completes, it returns connection to connection pool.   Source: docs.oracle.com It will boost performance, because creating connection for every-user and action it will degrade performance, So how can we add connection pooling in java. Hibernate configuration using c3p0 hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.connection.url=jdbc:mysql://localhost/connectionpool hibernate.connection.username=root hibernate.connection.password=<password> hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect hibernate.show_sql=false hibernate.c3p0.max_size=1 hibernate.c3p0.min_size=0 hibernate.c3p0.timeout=5000 hibernate.c3p0.max_statements=100 hibernate.c3p0.idle_test_period=300 hibernate.c3p0.acquire_increment=2 For more informat...

For fast understanding of new project's database, I want to know all relationship, table structure and so. I found one interesting utility which gives overview of full database. SchemaSpy is a Java-based tool (requires Java 5 or higher ) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. Check Schemyspy Happy Reading..!!!