Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqlMap.queryForList("getResultSet", parameterMap);
- <select id='getResultSet' parameterClass='java.util.Map' fetchSize="1000" resultSetType="FORWARD_ONLY">
- @Override
- public void handleRow(Object queryResult) {
- if(queryResult != null) {
- try {
- tempResultMap = (ClassName) queryResult;
- resultList.add(tempResultMap);
- System.out.println("List Size -> " + reportList.size());
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
- <bean id="sourceName" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
- <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
- <property name="url" value="jdbc:oracle:thin:@host:port:sid" />
- <property name="username" value="$uname" />
- <property name="password" value="$pwd" />
- <!--
- Some thing like this
- <property name="configName(Instead of Driver.useCursorFetch)" value="true/false" />
- -->
- </bean>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement