Advertisement
Guest User

Untitled

a guest
May 2nd, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. public class H2Dao {
  2. private NamedParameterJdbcTemplate t;
  3. @Autowired
  4. public H2Dao(@Qualifier("H2JdbcTemplate") NamedParameterJdbcTemplate t) {
  5. this.t=t;
  6. }
  7. }
  8.  
  9. <jdbc:embedded-database id="h2DataSource" type="H2">
  10. <jdbc:script location="classpath:db/sql/h2.init.sql" />
  11. </jdbc:embedded-database>
  12.  
  13. <bean id="H2JdbcTemplate" class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">
  14. <constructor-arg ref="h2DataSource" name="dataSource" />
  15. </bean>
  16.  
  17. CREATE ALIAS ROWNUM_OVER FOR "com.xx.xxxx.h2.H2Function.rowNumOver";
  18. CREATE ALIAS DBO_UFUN_ADDDATETIME FOR "com.xx.xxxx.h2.H2Function.addDateTime";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement