SQL-Lite with Hibernate

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.



Enjoy.

Comments

Post a Comment

Popular posts from this blog

Create BeanShell Script to Make Database call

BeanShell Script BeanShell is a small, free, embeddable Java source interpreter with object scripting language features, written in Java. BeanShell dynamically executes standard Java syntax and extends it with common scripting conveniences such as loose types, commands, and method closures like those in Perl and JavaScript. Following script make database connection and every iteration it takes 50 records from database and populate them in hashmap. This has been created to use with jmeter using beanshell sampler. import com.postgresql.jdbc.Driver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.HashMap; import java.util.Map; System.out.println("Postgres Connect Example."); Connection conn = null; Statement stmt = null; ResultSet rs = null; String url = "jdbc:postgresql://192.168.3.99:5432/"; String dbName = "DB";
Read more

JAX-WS - SOAP Handlers

What is SOAP Handlers ? SOAP Handlers are interceptor to do additional processing of incoming and outgoing message at Client as well as Server level. For example, to check properties in handler, to audit req/response or to do any filtering. SOAP message contains three parts as below:- SOAP Header [Optional] SOAP Body Attachments [Optional] JAX-WS 2.0 defines 2 types of Handlers - Logical and Message Handler. Logical Handlers operates on message context properties and message payload only. Logical handlers are handlers that implements - javax.xml.ws.handler.LogicalHandler Message Handlers operates all parts of SOAP, i.e. SOAP Header, Body and attachments. it implements - javax.xml.ws.handler.soap.SOAPHandler There are three methods of handlers as follows:- handleMessage() - This method is called for both incoming and outgoing message for any additional processing handleFault() - This handles any fault generated by service implementation or exception generated f
Read more

Connection Pooling

Image
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 information, che
Read more