List = ResultSet from Oracle. If you can project your resultset into Objects then you can address properties in the jasper report by fieldName. To be perfectly honest it has been a while since I have worked with raw JDBC objects, so I cannot remember what object you create to execute SQL to return a list. But lets say its a Query object. If you cannot project to objects then your list is usually filled with Objects[]s. Each entry in each array represents a column value in the row. So row = Object array. When you are passing a List<Object[]> to JasperReports I am not sure how to address the fields but I am sure the syntax is something like field[0]. I don't know if there is a keyword like "field" or its just [0].
Mel Rosenberg-2 wrote: > > I have been working on using Jasper with Struts2 2.0.11. Looking at the > documentation it seems that the dataSource param is looking for a list. > The > question is what is in the list. Is it a list of connection parameters to > the database, ie.. url, login name, password... or is it a list of > results? > > Can anyone point me in the right direction? I have searched the web and > cant find an article that shows how to connect to a database and produce a > JasperReport from Struts2. > > Thanks in advance. > Mel > > -----Original Message----- > From: ravindra [mailto:ravin...@btpsoft.com] > Sent: Tuesday, January 13, 2009 2:36 AM > To: 'Struts Users Mailing List' > Subject: RE: JasperReports Plugin:How to specify JDBC connection? > > >>>>>*param in the struts.xml (???) > > 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. > > ( mypojoList > > -----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 (???) 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: > connect > > 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 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@struts.apache.org > For additional commands, e-mail: user-h...@struts.apache.org > > > -- View this message in context: http://www.nabble.com/JasperReports-Plugin%3AHow-to-specify-JDBC-connection--tp21431403p21699607.html Sent from the Struts - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For additional commands, e-mail: user-h...@struts.apache.org
