I had a program written that would JDBC connect to a given Informix server, log in, retrieve data, then export it to a PDF file user jasperReports, and start the default PDF viewer on it.
Due to security constraints, though, the customer has decided they want it to be initiated from the server side (which is not a problem with the framework we are using) by sending a CSV file to the windows box the user is on, then starting a java program that will load the data, and create the PDF file. So, I am rewriting my app to use a local CSV file with jasperReports rather than a remote Informix connection. As the first step in my process, I am only using iReports to parse a CSV file on my local hard drive. Just to make certain that it can be done. I thought that I could get away with just using a JDBC driver built for CSV. I've tried three different ones, and gotten nowhere so far. (In case you're curious, I've tried HXXT, StelsCSV, and cvsjdbc. HXXT gives me compile errors in iReports, StelsCSV doesn't break apart the headers correctly, and cvsjdbc doesn't support PreparedStatement). So, does anyone know of a CSV JDBC driver that they _know_ works with iReports and jasperreports? Or, do I need to parse the CSV manually, and fill up a JRDataSource myself? I certainly hope not... Any clues will be appreciated! Dave ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
