I have created a jrxml design (HTML) using Jasper Assistant. There is a queryString value, very extensive, multiple joins.... I have created a bean wtihin context file:
<bean id="oracleDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@myURL"/>
<property name="username" value="user"/>
<property name="password" value="pass"/>
My question is, Since I already have a very complex query within my design file and already contain a bean to ference the data source, how can i tie them together without having to make a Factory class to obtaina List or Collection of retrieved records?
I have read through the chapter 13 documentation and been through the samples within Jasper Reports but no luck. Any suggestions?