>>>>*param in the struts.xml (<param name="dataSource">???</param>)
The param should be the name of the list object which is used to generate the report.For example, You should have a List<SomePojo> mypojoList; as a property in your database which is used to generate the data in the table list.You should populate the list object in your prepare method. (<param name="dataSource"> mypojoList</param> -----Original Message----- From: Rajeshwari Godbole [mailto:rgodb...@gmail.com] Sent: Tuesday, January 13, 2009 2:12 PM To: user@struts.apache.org Subject: JasperReports Plugin:How to specify JDBC connection? Hello, *Problem*: I created a .jrxml report template in iReports that is using an Oracle database to retrieve data. Now I want to plug in this report into a existing webapp using the Struts2 plugin. The webapp uses JDBC to connect to the database. I'm not able to figure out what value to use for the *datasource *param in the struts.xml (<param name="dataSource">???</param>) so that when I click on view report on the GUI, the compiled report template from the *location *param would be called and the data from the Oracle database given in the *datasource *param would be used to generate the report. *Background*: I've searched high and low and seen the last conversation on this between Milan Milanovic<http://www.nabble.com/user/UserProfile.jtp?user=1020045>and Dave Newton but inspite of downloading the JasperReportResult.java (that Milan has kindly posted), I'm not able to get this to work. After I got the JasperReportResult.java, I got errors while compiling that required the classes com.opensymphony.xwork2.util.logging.Logger and LoggerFactory so I got xwork-2.1.0.jar that has the logging classes (was using xwork-2.0.5 earlier). Now I'm getting an error on line 288 that says Connection cannot be resolved (Connection conn = (Connection)stack.findValue(connection)). I tried importing java.sql package that fixes the compilation but still does not work Now, I get the error: java.lang.ClassCastException: java.lang.String org.apache.struts2.views.jasperreports.JasperReportsResult.doExecute(JasperR eportsResult.java:288) org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSuppor t.java:178) . Please help! Many thanks in advance. Given below is my action class and setting in struts.xml. I've the following in struts.xml: <param name="connection">connect</param> and the following in my action: package com.db.mq.mon.report.ui.test.action; import java.sql.Connection; import java.sql.Driver; import java.sql.DriverManager; import java.util.ArrayList; import com.opensymphony.xwork2.ActionSupport; * * Jan 9, 2009 * */ public class AppReportAction extends ActionSupport { /** * */ private static final long serialVersionUID = 7763977968848348929L; private Connection myConn; private String connect; private ArrayList<Connection> dataSource = new ArrayList<Connection>(); public String execute() throws Exception { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); myConn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.120.102:1521:tvmdev", "user2", "sena120"); connect = "jdbc:oracle:thin:@192.168.120.102:1521:tvmdev"; dataSource.add(myConn); return SUCCESS; } /** * @return the dataSource */ public ArrayList getDataSource() { return dataSource; } /** * @param dataSource the dataSource to set */ public void setDataSource(ArrayList dataSource) { this.dataSource = dataSource; } /** * @return the connect */ public String getConnect() { return connect; } /** * @param connect the connect to set */ public void setConnect(String connect) { this.connect = connect; } } <http://www.nabble.com/user/UserProfile.jtp?user=1020045> --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For additional commands, e-mail: user-h...@struts.apache.org