Project structure
pom.xml to bring-in Thymeleaf & Spring jars
Step 1: Add “Thymeleaf“jar dependency, and also override default “maven-war-plugin” by explicitly adding the”failOnMissingWebXml” to false to not have web.xml as we will be using JavaConfigs and AbstractAnnotationConfigDispatcherServletInitializer.
…
Q1. Does Spring dependency injection happen during compile time or runtime? A1. Runtime during creating an object. Q2. What is the difference between prototype scope and singleton scope? Which one is the default? A2. Singleton means single bean instance per IoC container, … Read more ›...
#1. Enable Logging in your log4j.xml, log4j.properties, or myapp-logback.xml
In the log4j.properties file, you can enable Hibernate SQL logging as shown below
|
1 2 |
log4j.logger.org.hibernate.SQL=DEBUG log4j.logger.org.hibernate.type=trace |
or in your log4j.xml or myapp-logback.xml as
|
1 2 3 4 5 6 7 8 |
<logger name="org.hibernate.SQL" additivity="false"> <level value="DEBUG" /> <appender-ref ref="FILE"/> </logger> <logger name="org.hibernate.type" additivity="false"> <level value="TRACE" /> <appender-ref ref="FILE"/> </logger> |
You can then check your logs for the SQLs executed and the parameters passed.
…
Install RESTClient from WizTools.org
Step 1: RESTClient is required to test the RESful web services. Go to
http://download.wiztools.org/rest-client/archive/index.html
Download the latest version of “restclient-ui-3.2.2-jar-with-dependencies.jar” file. Copy it to “c:\tools” and run it by Double-Clicking if you are running on windows.
…
This tutorial extends Spring 4 MVC RESTful Web Service Beginner Tutorial step by step.
Controller that supports GET with path variable & POST methods
Step 1: The “AccountController.java” that has two additional methods to support requests like
GET: http://localhost:8080/simpleWeb/entry/v1/forecasting/account/123
POST: http://localhost:8080/simpleWeb/entry/v1/forecasting/account
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
package com.mytutorial.controller; import java.math.BigDecimal; import org.springframework.http.HttpStatus; import org.springframework.http.MediaType; import org.springframework.http.ResponseEntity; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.ResponseBody; import com.mytutorial.model.Account; @Controller @RequestMapping("/v1/forecasting") public class AccountController { @RequestMapping(value = "/accounts", method = RequestMethod.GET, produces={MediaType.APPLICATION_JSON_VALUE}) public @ResponseBody Account[] getAccounts() { Account[] accounts = new Account[] { new Account("123", "John R", BigDecimal.valueOf(235.00)), new Account("345", "Peter J", BigDecimal.valueOf(2505.60)) }; return accounts; } @RequestMapping(value = "/account/{id}", method = RequestMethod.GET, produces={MediaType.APPLICATION_XML_VALUE}) public @ResponseBody Account getAccount(@PathVariable("id") String id) { //TODO: go to database and get the Account by id Account account = new Account(id, "John R", BigDecimal.valueOf(235.00)); return account; } @RequestMapping(value = "/account", method = RequestMethod.POST) public ResponseEntity<Account> saveAccount(@RequestBody Account account) { System.out.println("Creating:" + account); //TODO: Save to database return new ResponseEntity<Account>(account, HttpStatus.OK); } } |
Step 2: Package as simpleWeb.war and deploy to Tomcat’s “webapps”
…
Hibernate does require the same EntityManager to be available in order to lazily load objects. If you have no EntityManager, then you have no knowledge of the datastore. Once the transaction is committed the objects become detached, and you can’t lazy load detached objects. So, you need to lazily load...
Related Links 1. Spring DIP, DI & IoC in detail interview Q&As. … Read more ›...
Q1. What do you understand by automatic dirty checking in Hibernate? A1. Dirty checking is a feature of hibernate that saves time and effort to update the database when states of objects are modified inside a transaction. All persistent objects are monitored by hibernate.It detects which objects have been modified...
There are certain generic columns that database tables have like Auto generated identity columns. Auditing columns like createdDtTm, createdBy, modifiedDtTm, and modifiedBy. Soft delete or logical delete flags like inactive ‘Y’ or ‘N’. Optimistic locking detection based on columns like Timestamp or version number. … Read more ›...
Example #1 Wiring JDBC Datasource
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
@Configuration @ImportResource("application.yml") public class AppConfig { @Autowired private Environment environment; @Bean public DriverManagerDataSource datasource() { DriverManagerDataSource ds = new DriverManagerDataSource(); ds.setDriverClassName(environment.getRequiredProperty("spring.datasource.driver-class-name")); ds.setUrl(environment.getRequiredProperty("spring.datasource.url")); ds.setUsername(environment.getRequiredProperty("spring.datasource.username")); ds.setPassword(environment.getRequiredProperty("spring.datasource.password")); return ds; } } |
application.yml where the datasource properties are read from.
|
1 2 3 4 5 6 7 8 9 10 11 12 |
############ # Datasource properties ############ spring: datasource: driver-class-name: com.sybase.jdbc4.jdbc.SybDataSource url: jdbc:sybase:Tds:mydbhost:5700/my_db username: user password: pwd |
Example #2 Wiring JDBC Datasource with JNDI
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
@Configuration @ImportResource("application.yml") public class AppConfig { @Autowired private Environment environment; @Bean public DataSource dataSource() { final JndiDataSourceLookup jndiLookup = new JndiDataSourceLookup(); final String dataSourceJndi = environment.getRequiredProperty("spring.datasource.jndi"); return jndiLookup.getDataSource(dataSourceJndi); } } |
Example #3 Wiring the JPA persistence unit processors Callback interface for post-processing a JPA PersistenceUnitInfo. … Read more ›...
Q1. Can you describe the Spring Web MVC framework architecture? A1. Spring Web MVC framework provides a Model View Controller architecture to develop loosely coupled 1) web applications 2) RESTful web services. … Read more ›...
Here is a sample maven pom.xml snippets containing the dependency jars.
|
1 2 3 4 5 6 7 |
.... <hibernate.version>4.1.3.Final</hibernate.version> <hibernate-jpa-2.0-api.version>1.0.1.Final</hibernate-jpa-2.0-api.version> <hibernate-validator-annotation-processor>4.2.0.Final</hibernate-validator-annotation-processor> <hibernate-validator.version>4.3.0.Final</hibernate-validator.version> |
The above snippet defines the version numbers. The snippet below defines the dependencies.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
... <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-core</artifactId> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-entitymanager</artifactId> </dependency> <dependency> <groupId>org.hibernate.javax.persistence</groupId> <artifactId>hibernate-jpa-2.0-api</artifactId> </dependency> <dependency> <groupId>javax.validation</groupId> <artifactId>validation-api</artifactId> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator</artifactId> </dependency> <dependency> <groupId>org.hibernate.javax.persistence</groupId> <artifactId>hibernate-jpa-2.0-api</artifactId> <version>${hibernate-jpa-2.0-api.version}</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator-annotation-processor</artifactId> <version>${hibernate-validator-annotation-processor}</version> </dependency> <!-- bean validation --> <dependency> <groupId>javax.validation</groupId> <artifactId>validation-api</artifactId> <version>1.0.0.GA</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator</artifactId> <version>${hibernate-validator.version}</version> </dependency> |
If you want to auto-generate your hibernate entities from DDL then.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
<build> <resources> <resource> <directory>${basedir}/src/main/resources</directory> <includes> <include>**/*</include> </includes> </resource> </resources> <plugins> <plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>hibernate3-maven-plugin</artifactId> <configuration> <components> <component> <name>hbm2ddl</name> <implementation>jpaconfiguration</implementation> </component> <component> <name>hbmdoc</name> </component> </components> <componentProperties> <persistenceunit>my-data</persistenceunit> <outputfilename>schema.ddl</outputfilename> <drop>true</drop> <create>true</create> <export>false</export> <format>true</format> </componentProperties> </configuration> </plugin> </plugins> </build> |
Finally, … Read more ›...
There are times you want to define a custom data type in Hibernate. Here is an example of using a custom ImageType defined as a Blob databse type to store images, excel files, etc.
Step 1: Define the custom Hibernate data type “ImageTpe”
…