gglulu

hi can you say which data base ? I think you can use the other sql syntaxe example : Code:SELECT CASE WHEN (<column_value>= <value>) THEN WHEN (<column_value> = <value>) THEN ELSE <value>FROM <table_name>;

I forget the java code Code:import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.HashMap;import java.util.Map;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JasperCompileManager;import net.sf.jasperreports.engine.JasperExportManager;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.JasperReport;import net.sf.jasperreports.engine.design.JasperDesign;import net.sf.jasperreports.engine.xml.JRXmlLoader;import java.sql.*;public class GeneratePDF { public static void main(String[] args) { String connectionURL = null; Connection conn=null; System.out.println("debut"); // - Paramètres de connexion à la base de données String url = "jdbc:oracle:thin:@xxxxxxxxxxxxxxxxxx:xxxx:xxxx"; String login = "xxxxxxxxx"; String password = "xxxxxxxxxxxxx"; Connection connection = null; try { // - Connexion à la base try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); } catch (ClassNotFoundException e) { System.out.println("Oops! Can't find class oracle.jdbc.driver.OracleDriver"); System.exit(1); } catch (IllegalAccessException e) { System.out .println("Uh Oh! You can't load oracle.jdbc.driver.OracleDriver"); System.exit(2); } catch (InstantiationException e) { System.out .println("Geez! Can't instantiate oracle.jdbc.driver.OracleDriver"); System.exit(3); } //Driver monDriver = new com.mysql.jdbc.Driver(); //DriverManager.registerDriver(monDriver); connection = DriverManager.getConnection(url, login, password); // - Chargement et compilation du rapport JasperDesign jasperDesign = JRXmlLoader.load("C:\\reportporeleaseparam.jrxml"); JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign); // - Paramètres à envoyer au rapport Map parameters = new HashMap(); //parameters.put("Titre", "Titre"); parameters.put("release_id", Integer.parseInt(args[0])); // - Execution du rapport JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, connection); // - Création du rapport au format PDF JasperExportManager.exportReportToPdfFile(jasperPrint, "C:\\reportporeleaseparamclassic.pdf"); } catch (JRException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } } }}

Hello all, I use the ireport version 3.7.1 I built a report on windows workstation, I execute without problem. I use a java program to create the pdf with the lib in my classpath no problem (I have Java 1.6). I send the file GeneratePDF.java and reportporeleaseparam.jrxml on my unix server (java 1.4). I compile the java file on a server unix, no problem but when I want to execute I have a message here below Can you help me please ? Code:Exception in thread "main" java.lang.UnsupportedClassVersionError: com/jaspersoft/ireport/designer/jrctx/JRCTXExtensionsRegistryFactory (Unsupported major.minor version 49.0) at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:509) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at java.net.URLClassLoader.defineClass(URLClassLoader.java:246) at java.net.URLClassLoader.access$100(URLClassLoader.java:54) at java.net.URLClassLoader$1.run(URLClassLoader.java:193) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:186) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265) at java.lang.ClassLoader.loadClass(ClassLoader.java:262) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:322) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:207) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115) at net.sf.jasperreports.engine.util.ClassUtils.instantiateClass(ClassUtils.java:53) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:198) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:175) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:135) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:121) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:98) at net.sf.jasperreports.engine.component.ComponentsEnvironment.findComponentBundles(ComponentsEnvironment.java:90) at net.sf.jasperreports.engine.component.ComponentsEnvironment.getCachedComponentBundles(ComponentsEnvironment.java:78) at net.sf.jasperreports.engine.component.ComponentsEnvironment.getComponentBundles(ComponentsEnvironment.java:66) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.getSchemaLocations(JRReportSaxParserFactory.java:158) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.configureParser(JRReportSaxParserFactory.java:139) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.createParser(JRReportSaxParserFactory.java:104) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1332) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1307) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:199) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:164) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:148) at GeneratePDF.main(GeneratePDF.java:59)