Can't open Preview with SQL-Database // Msg: com.informix.jdbc.IfxDriver

Posted on August 31, 2017 at 10:23pm

1. I am getting the following error and can't fix it:

" Exception
----------------------------------------------------------------------------------------------------------------------------------------------------

Message:
    java.lang.ClassNotFoundException: com.informix.jdbc.IfxDriver
Level:
    SEVERE
Stack 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 2011\ncallouts.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_von\nfrom v500,g693, v130, g600, v600\nwhere g600.adressid \= g693.adressid and g600.konto \= v500.konto and v500.rg_nr \= v130.rg_nr and g600.konto \= v130.konto\nand 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_von
from v500,g693, v130, g600, v600
where g600.adressid = g693.adressid and g600.konto = v500.konto and v500.rg_nr = v130.rg_nr and g600.konto = v130.konto
and 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>
 
 </textElement>
 <text><![CDATA[Wert in €]]></text>
 </staticText>
 <staticText>
 <reportElement x="181" y="50" width="253" height="16"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[Name]]></text>
 </staticText>
 <staticText>
 <reportElement x="110" y="50" width="71" height="16"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[Konto]]></text>
 </staticText>
 <staticText>
 <reportElement x="28" y="50" width="82" height="16"/>
 <textElement>
 
 </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>
 
 </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>
 
 </textElement>
 <textFieldExpression class="java.util.Date"><![CDATA[$F{datum_bis}]]></textFieldExpression>
 </textField>
 <staticText>
 <reportElement x="204" y="0" width="86" height="13"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[Rechnungen von:]]></text>
 </staticText>
 <staticText>
 <reportElement x="264" y="13" width="26" height="13"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[bis:]]></text>
 </staticText>
 <staticText>
 <reportElement x="28" y="13" width="91" height="13"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[Zentralzahlerkonto:]]></text>
 </staticText>
 <staticText>
 <reportElement x="119" y="13" width="69" height="13"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[800002]]></text>
 </staticText>
 <staticText>
 <reportElement x="28" y="26" width="48" height="13"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[Konto Nr.:]]></text>
 </staticText>
 <staticText>
 <reportElement x="76" y="26" width="112" height="13"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[800002 / 800036]]></text>
 </staticText>
 <staticText>
 <reportElement x="28" y="0" width="59" height="13"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[Nordwest]]></text>
 </staticText>
 <staticText>
 <reportElement x="400" y="0" width="52" height="13"/>
 <textElement>
 
 </textElement>
 <text><![CDATA[erstellt am:]]></text>
 </staticText>
 <textField pattern="dd/MM/yyyy">
 <reportElement x="452" y="0" width="64" height="13"/>
 <textElement>
 
 </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>
 
 </textElement>
 <textFieldExpression class="java.lang.Integer"><![CDATA[$F{konto}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="181" y="0" width="253" height="16"/>
 <textElement>
 
 </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>
 
 </textElement>
 <textFieldExpression class="java.lang.Double"><![CDATA[$F{rwert_end}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="28" y="0" width="82" height="16"/>
 <textElement>
 
 </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>
 
 </textElement>
 <textFieldExpression class="java.lang.Double"><![CDATA[$V{variable1}]]></textFieldExpression>
 </textField>
 <staticText>
 <reportElement x="388" y="1" width="46" height="16"/>
 <textElement>
 
 </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.jar

4. My ireport.conf looks like this:

" # ${HOME} will be replaced by user home directory according to platform
default_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 switches
default_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> switch
jdkhome="\\b2apserver\tools\Java7\jre1.7.0_67"

# clusters' paths separated by path.separator (semicolon on Windows, colon on Unices)
#extra_clusters= "

iReport Designer

marek.margas

Joined: Aug 31 2017 - 12:05pm

Last seen: 5 years 6 months ago

3 Answers:

Posted on August 31, 2017 at 10:47pm

You have to add ifxjdbc.jar file using jasperserv webapp for the context can find it.

Mariano

mlopez_1

5531

Joined: Oct 21 2013 - 8:08am

Last seen: 2 weeks 3 days ago

Posted on August 31, 2017 at 11:00pm

@mlopez_1:

I do not understand your answer. I have ifxjdbc.jar in my classpath allready.

What do you mean?

marek.margas

Joined: Aug 31 2017 - 12:05pm

Last seen: 5 years 6 months ago

Posted on September 3, 2017 at 11:24pm

I understood you badly.

This happens to me with other class i use in preview.

It's seems to be a bug.

Sorry.

Mariano

mlopez_1

5531

Joined: Oct 21 2013 - 8:08am

Last seen: 2 weeks 3 days ago

Main menu

Can't open Preview with SQL-Database // Msg: com.informix.jdbc.IfxDriver

1. I am getting the following error and can't fix it:

2. My XML-Code looks like this:

3. My Classpath has the following entries:

4. My ireport.conf looks like this:

3 Answers:

@mlopez_1:

Tags

Main menu

You are here

Can't open Preview with SQL-Database // Msg: com.informix.jdbc.IfxDriver

1. I am getting the following error and can't fix it:

2. My XML-Code looks like this:

3. My Classpath has the following entries:

4. My ireport.conf looks like this:

3 Answers:

@mlopez_1:

Tags