Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. sqlMap.queryForList("getResultSet", parameterMap);
  2.  
  3. <select id='getResultSet' parameterClass='java.util.Map' fetchSize="1000" resultSetType="FORWARD_ONLY">
  4.  
  5. @Override
  6. public void handleRow(Object queryResult) {
  7.  
  8. if(queryResult != null) {
  9.  
  10. try {
  11.  
  12. tempResultMap = (ClassName) queryResult;
  13. resultList.add(tempResultMap);
  14. System.out.println("List Size -> " + reportList.size());
  15. } catch (Exception e) {
  16. e.printStackTrace();
  17. }
  18. }
  19. }
  20.  
  21. <bean id="sourceName" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  22. <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
  23. <property name="url" value="jdbc:oracle:thin:@host:port:sid" />
  24. <property name="username" value="$uname" />
  25. <property name="password" value="$pwd" />
  26. <!--
  27. Some thing like this
  28. <property name="configName(Instead of Driver.useCursorFetch)" value="true/false" />
  29. -->
  30.  
  31. </bean>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement