report without any parameter and error :/

[aycansora]

Hello everyone,

i am new in jasperreports and i couldnt find a solution and i need help. currently i am using ireport 4.6 and netbeans 7.1.2 and jdk 1.7 . i am trying to create a report without parameter but i always have problem to run it.  i am using the older version because some reports are created with older version and when i use the newer version its not sufficient. i mean when i change something on the report and compile it i see some other changes that i didnt change  but when i use older version i dont see other changes that i didnt change. So my error message is net.sf.jasperreports.engine.JRException: Error executing SQL statement for   .   And this is my method when i clicked the button

    private void PrintAllProjectsActionPerformed(java.awt.event.ActionEvent evt) {                                                 

     try{

         HashMap parameterMap = new HashMap();

         JasperPrint jasperPrint = JasperFillManager.fillReport(ClassLoader.getSystemResourceAsStream("C:/Users/Sorabatur/Desktop/Projects.jasper"), parameterMap, con);

         JasperViewer.viewReport(jasperPrint, false);

      }

      catch(Exception ex) {

         String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage();

         JOptionPane.showMessageDialog (null,"ERROR -- TDCGUI.runReport: " + ex);

         JOptionPane.showMessageDialog (null, connectMsg);

      }   

    }  

So i dont know what i am doing wrong. And this is my simple sql code without any parameter because i dont need parameter just data from database.

SELECT

     TDCPROJECT."PROJNO" AS TDCPROJECT_PROJNO,

     TDCPROJECT."PROJNAME" AS TDCPROJECT_PROJNAME,

     TDCPROJECT."LOCATION" AS TDCPROJECT_LOCATION,

     TDCPROJECT."CREATIONDATE" AS TDCPROJECT_CREATIONDATE,

     TDCPROJECT."CREATOR" AS TDCPROJECT_CREATOR

FROM

     "TDCOWNER"."TDCPROJECT" TDCPROJECT

 

 

Could you please help me or at least share your opinions. Thank you .

[sanbez]

delete catch-block and show full stacktrace