CaptnTony Posted August 7, 2007 Share Posted August 7, 2007 Aug 6, 2007 4:07:55 PM net.sf.jasperreports.engine.query.JRJdbcQueryExecuter <init>WARNING: The supplied java.sql.Connection object is null. Aug 6, 2007 4:07:57 PM net.sf.jasperreports.engine.query.JRJdbcQueryExecuter <init>WARNING: The supplied java.sql.Connection object is null. the two lines of code that are generating these errors are: // create JasperPrint using fillReport() methodJasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, CIMS.conCIMS.connection); and // You can use JasperPrint to create PDFJasperExportManager.exportReportToPdfFile(jasperPrint, "F:\Shared\CIMS\Invoices\Test\Temp\Todd\" + mInvoice.getInvoiceID() + ".pdf"); I should be using the newest versions of JasperReports and iReport. This just started happening today (has been working fine for over 5 months). I modified some of the sub-report queries to use Views in MS SQL Server 2000. These views join data across 2 different databases (the queries work fine both in SQL Manager and when I print the reports using iReport (as a preview with data)). The reports produce fine and show up in the preview perfectly, but I'd like to avoid this error if possible. Is it possible the the error is because the query crosses multiple databases and doesn't use any connections or user information specified within the report? If you need any more information, let me know. Thanks in advance. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now