marek.margas Posted September 1, 2017 Share Posted September 1, 2017 1. I am getting the following error and can't fix it: " Exception----------------------------------------------------------------------------------------------------------------------------------------------------Message: java.lang.ClassNotFoundException: com.informix.jdbc.IfxDriverLevel: SEVEREStack Trace:com.informix.jdbc.IfxDriver com.jaspersoft.ireport.designer.connection.JDBCConnection.loadDriver(JDBCConnection.java:63) com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:126) com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:855) org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) " 2. My XML-Code looks like this:"<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Verband-abgleich" language="groovy" pageWidth="566" pageHeight="842" columnWidth="516" leftMargin="25" rightMargin="25" topMargin="25" bottomMargin="25"> <property name="ireport.zoom" value="1.7715610000000017"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="ireport.callouts" value="##Fri Jun 17 11:21:18 CEST 2011ncallouts.1.text=select distinct v500.konto, g693.name_1, v500.rg_nr, v130.rwert_end, v500.vb, TODAY as Datum_bis , (TODAY -7) as Datum_vonnfrom v500,g693, v130, g600, v600nwhere g600.adressid = g693.adressid and g600.konto = v500.konto and v500.rg_nr = v130.rg_nr and g600.konto = v130.kontonand v600.anz_kat = '0' and v500.rg_dat between (TODAY -7) and (TODAY) and g600.ktozentr in ('800002')ncallouts.1.bounds=12,150,580,110"/> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["I:\iReport\Reports\"]]></defaultValueExpression> </parameter> <queryString language="SQL"> <![CDATA[select distinct v500.konto, g693.name_1, v500.rg_nr, v130.rwert_end, v500.vb, (TODAY) as Datum_bis , (TODAY -7) as Datum_vonfrom v500,g693, v130, g600, v600where g600.adressid = g693.adressid and g600.konto = v500.konto and v500.rg_nr = v130.rg_nr and g600.konto = v130.kontoand v600.anz_kat = '0' and v500.rg_dat between (TODAY -7) and (TODAY) and g600.ktozentr in ('800002') and v500.aufnr in (select v100.aufnr from v100 where v100.best_nr not like '%intern%')and g600.satzart = '1']]> </queryString> <field name="konto" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="name_1" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="rg_nr" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="rwert_end" class="java.lang.Double"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="vb" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="datum_bis" class="java.sql.Date"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="datum_von" class="java.sql.Date"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <variable name="variable1" class="java.lang.Double" calculation="Sum"> <variableExpression><![CDATA[$F{rwert_end}]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="67"> <staticText> <reportElement x="434" y="50" width="82" height="16"/> <textElement> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Wert in €]]></text> </staticText> <staticText> <reportElement x="181" y="50" width="253" height="16"/> <textElement> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement x="110" y="50" width="71" height="16"/> <textElement> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Konto]]></text> </staticText> <staticText> <reportElement x="28" y="50" width="82" height="16"/> <textElement> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[RechnungsNr.]]></text> </staticText> <line> <reportElement x="28" y="66" width="488" height="1"/> </line> <textField pattern="dd/MM/yyyy"> <reportElement x="290" y="0" width="85" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$F{datum_von}]]></textFieldExpression> </textField> <textField pattern="dd/MM/yyyy"> <reportElement x="290" y="13" width="85" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[$F{datum_bis}]]></textFieldExpression> </textField> <staticText> <reportElement x="204" y="0" width="86" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <text><![CDATA[Rechnungen von:]]></text> </staticText> <staticText> <reportElement x="264" y="13" width="26" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <text><![CDATA[bis:]]></text> </staticText> <staticText> <reportElement x="28" y="13" width="91" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <text><![CDATA[Zentralzahlerkonto:]]></text> </staticText> <staticText> <reportElement x="119" y="13" width="69" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <text><![CDATA[800002]]></text> </staticText> <staticText> <reportElement x="28" y="26" width="48" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <text><![CDATA[Konto Nr.:]]></text> </staticText> <staticText> <reportElement x="76" y="26" width="112" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <text><![CDATA[800002 / 800036]]></text> </staticText> <staticText> <reportElement x="28" y="0" width="59" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <text><![CDATA[Nordwest]]></text> </staticText> <staticText> <reportElement x="400" y="0" width="52" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <text><![CDATA[erstellt am:]]></text> </staticText> <textField pattern="dd/MM/yyyy"> <reportElement x="452" y="0" width="64" height="13"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> </band> </pageHeader> <detail> <band height="16" splitType="Stretch"> <textField> <reportElement x="110" y="0" width="71" height="16"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{konto}]]></textFieldExpression> </textField> <textField> <reportElement x="181" y="0" width="253" height="16"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{name_1}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="434" y="0" width="82" height="16"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{rwert_end}]]></textFieldExpression> </textField> <textField> <reportElement x="28" y="0" width="82" height="16"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{rg_nr}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="18"> <textField pattern="#,##0.00"> <reportElement x="434" y="1" width="82" height="16"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{variable1}]]></textFieldExpression> </textField> <staticText> <reportElement x="388" y="1" width="46" height="16"/> <textElement> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[summe:]]></text> </staticText> <line> <reportElement x="388" y="0" width="128" height="1"/> </line> </band> </summary></jasperReport>" 3. My Classpath has the following entries: - jasperreports-extensions-3.5.3.jar - hsqldb-1.8.0-10.jar - ifxjdbc.jar4. My ireport.conf looks like this:" # ${HOME} will be replaced by user home directory according to platformdefault_userdir="${HOME}/.${APPNAME}/3.7.1"default_mac_userdir="${HOME}/Library/Application Support/${APPNAME}/3.7.1"# options used by the launcher by default, can be overridden by explicit# command line switchesdefault_options="--branding ireport -J-Xms256m -J-Xmx512m -J-Dorg.netbeans.ProxyClassLoader.level=1000"# for development purposes you may wish to append: -J-Dnetbeans.logger.console=true -J-ea# default location of JDK/JRE, can be overridden by using --jdkhome <dir> switchjdkhome="\b2apservertoolsJava7jre1.7.0_67"# clusters' paths separated by path.separator (semicolon on Windows, colon on Unices)#extra_clusters= " Link to comment Share on other sites More sharing options...
mlopez_1 Posted September 1, 2017 Share Posted September 1, 2017 You have to add ifxjdbc.jar file using jasperserv webapp for the context can find it.Mariano Link to comment Share on other sites More sharing options...
marek.margas Posted September 1, 2017 Author Share Posted September 1, 2017 @mlopez_1:I do not understand your answer. I have ifxjdbc.jar in my classpath allready.What do you mean? Link to comment Share on other sites More sharing options...
mlopez_1 Posted September 4, 2017 Share Posted September 4, 2017 I understood you badly.This happens to me with other class i use in preview.It's seems to be a bug.Sorry.Mariano 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