cyrilic symbols in sql query

0

Hi! I have a promblem with cyrilic symbols in sql query in jasper report designer in ubuntu 13.10. There is no this problem in windows 7.. If i use cyrilic symbols i get null query result. It show me that there is no such fields in database, but there is. I changed encoding of database, tables. fields to utf-8 and cp1251 but it was get no results.

Example of query: select * from aggresult where aggOperator='СамараТелеком' and aggcity='Самара' and aggservice like '%СамараТелеком%' order by aggService

And i have same promlem when i try to generate report by using netbeans

        
        JasperPrint jasperPrint = JasperFillManager.fillReport("path/InterConnect.jasper", map, dbtestmx);
        JasperExportManager.exportReportToPdfStream(jasperPrint, outputStream);
It return me error:

Exception in thread "main" net.sf.jasperreports.engine.JRException: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.
        at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:247)
        at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226)
        at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214)
        at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:168)
        at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:152)
        at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:150)
        at easytest.EasyTest.renderReport(EasyTest.java:42)
        at easytest.EasyTest.main(EasyTest.java:69)
Caused by: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.
        at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(UTF8Reader.java:687)
        at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(UTF8Reader.java:557)
        at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(XMLEntityScanner.java:1753)
        at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.arrangeCapacity(XMLEntityScanner.java:1629)
        at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.skipString(XMLEntityScanner.java:1667)
        at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocVersion(XMLVersionDetector.java:196)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:812)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
        at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
        at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:649)
        at org.apache.commons.digester.Digester.parse(Digester.java:1745)
        at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239)
        ... 7 more
Java Result: 1

 

Thanks a lot!

alex.tukanov's picture
Joined: Dec 19 2013 - 10:49pm
Last seen: 5 years 9 months ago

0 Answers:

No answers yet
Feedback
randomness