Spring JDBC

This tutorial is about the JdbcTemplate querying type. Generally, there are 3 types of query, which is SimpleTypes, Generic Maps and Domain Objects.

Example 1, using H2 <jdbc:embeded-database id=”datasource” type=”H2″> <jdbc:script location=”classpath:jdbc/schema.sql”/> <jdbc:script location=”classpath:jdbc/test-data.sql”/> </jdbc:embeded> Example 2, <bean id=”dataSource” class=”org.springframework.jdbc.datasource.embeddedDatabaseFactoryBean”> <property name=”databasePopulator” ref=”populator”/> </bean> <bean id=”populator” class=”org.springframework.jdbc.datasource.init.ResourceDatabasePopulator”> <property name=”scripts”> <list> <value>classpath:jdbc/schema.sql</value> </list> </property> </bean>

This tutorial demonstrate using JPA2.0 with JQPL query with untype result and hibernate as vendor provider. This kind of query specifically useful in reporting or join table.

This tutorial demonstrate using JPA2.0 with createNativeQuery and hibernate as vendor provider.

This tutorial demonstrate using JPA2.0 with JQPL with TypeQuery and hibernate as vendor provider.

This tutorial demonstrate using JPA2.0 with NamedQuery and hibernate as vendor provider.