marek.margas

Members

View Profile See their activity

Posts
2
Joined
August 31, 2017
Last visited
September 11, 2017

marek.margas's Achievements

Newbie (1/14)

Rare
Rare

Recent Badges

Reputation

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

marek.margas replied to marek.margas's topic in Products

@mlopez_1:I do not understand your answer. I have ifxjdbc.jar in my classpath allready. What do you mean?
- September 1, 2017
- 3 replies
- - jdbc
  - sql
  - (and 1 more)
    Tagged with:
    
    jdbc
    
    sql
    
    iReport Designer
Can't open Preview with SQL-Database // Msg: com.informix.jdbc.IfxDriver

marek.margas posted a topic in Products

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 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_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="\b2apservertoolsJava7jre1.7.0_67" # clusters' paths separated by path.separator (semicolon on Windows, colon on Unices) #extra_clusters= "
- September 1, 2017
- 3 replies
- - jdbc
 - sql
 - (and 1 more)
 Tagged with:
 
 jdbc
 
 sql
 
 iReport Designer

Sign In

marek.margas

Posts

Joined

Last visited

marek.margas's Achievements

Newbie (1/14)

Recent Badges

Reputation

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

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

Activity

Products

Explore