Jasper Reports

[Rob Craig]

Hi I have the following code.

package test;
 
import net.sf.jasperreports.engine.xml.*;
import net.sf.jasperreports.engine.design.*;
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.view.*;
import java.util.*;
import java.io.*;
/**
 *
 * @author RobertC
 */
public class NewClass {
    
    public java.sql.Connection  con = null;
     private final String url = "jdbc:microsoft:sqlserver://";
     private final String serverName= "server";
     private final String portNumber = "port";
     private final String databaseName= "SampleDB";
     private final String userName = "username";
     private final String password = "password";
     private final String selectMethod = "cursor";
 
    
     public NewClass() {
       File fs = new File("classic.xml");
       System.out.println(fs.getName());
        try{
           JasperDesign jasperDesign = JRXmlLoader.load(fs);
           JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
       
        Map parameters = new HashMap();
        parameters.put("phone_number", "5130");
        this.getConnection();
       
        JasperPrint view = JasperFillManager.fillReport(jasperReport, parameters, con);
       
        JasperExportManager.exportReportToPdfFile(view, "report.pdf");
       }
       catch(Exception e)
       {
           System.out.println(e.getMessage() + "\n");
       }
       
    }
    
    private String getConnectionUrl(){
          return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
     }
 
     private java.sql.Connection getConnection(){
          try{
               Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
               con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
               if(con!=null) System.out.println("Connection Successful!");
          }catch(Exception e){
               e.printStackTrace();
               System.out.println("Error Trace in getConnection() : " + e.getMessage());
         }
          return con;
      }
     
     public static void main (String [] args)
     {
         new NewClass();
     }
    
}

When I run this it says it can't find the file classic.xml it is definately in the same folder and I even created it as a file object to check. Any suggestions?

[Chengwei Lee]

Do you really have to compile your XML file during run-time? How about using the provided Ant task to compile it offline into a .jasper file instead? Look into the samples provided with the JasperReport download.

Cheers!