JDBC DataSource charset problem

Hi!

hmm.. can you attach the contents of your Help \ System Properties dialog ? Can you maybe also attach an excel file with some sample data that is not coming out right?


regards!

/Ole
eviware.com

I exported 3 db records to a file. This file is attached.

I've also tried to use File DataSource and read this file. This way there is no problem with charset. Only direct database access makes troubles.

David


System Properties:

GRE_HOME=/opt/soapui/xulrunner-linux

apple.laf.useScreenMenuBar=true

com.apple.mrj.application.apple.menu.about.name=SoapUI

file.encoding=UTF-8
file.encoding.pkg=sun.io
file.separator=/

groovy.source.encoding=iso-8859-1

java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
java.awt.printerjob=sun.print.PSPrinterJob
java.class.path=/opt/soapui/bin/soapui-pro-3.0.1.jar:/opt/soapui/lib/activation-1.1.jar:/opt/soapui/lib/javamail-1.4.jar:/opt/soapui/lib/wsdl4j-1.6.2-fixed.jar:/opt/soapui/lib/junit-4.4.jar:/opt/soapui/lib/log4j-1.2.14.jar:/opt/soapui/lib/opencsv-1.8.jar:/opt/soapui/lib/rsyntaxtextarea-1.3.4.jar:/opt/soapui/lib/looks-2.2.0.jar:/opt/soapui/lib/binding-2.0.1.jar:/opt/soapui/lib/forms-1.0.7.jar:/opt/soapui/lib/jcalendar-1.3.2.jar:/opt/soapui/lib/commons-logging-1.1.1.jar:/opt/soapui/lib/commons-collections-3.2.1.jar:/opt/soapui/lib/commons-lang-2.4.jar:/opt/soapui/lib/commons-io-1.3.2.jar:/opt/soapui/lib/not-yet-commons-ssl-0.3.10.jar:/opt/soapui/lib/commons-cli-1.0.jar:/opt/soapui/lib/commons-beanutils-1.7.0.jar:/opt/soapui/lib/commons-httpclient-3.1.jar:/opt/soapui/lib/json-lib-2.2.2-jdk15.jar:/opt/soapui/lib/ezmorph-1.0.5.jar:/opt/soapui/lib/xom-1.1.jar:/opt/soapui/lib/swingx-soapui.jar:/opt/soapui/lib/l2fprod-common-fontchooser-7.3.jar:/opt/soapui/lib/l2fprod-common-directorychooser-7.3.jar:/opt/soapui/lib/commons-codec-1.3.jar:/opt/soapui/lib/groovy-all-1.6.4.jar:/opt/soapui/lib/js-1.7R2.jar:/opt/soapui/lib/jetty-6.1.15.jar:/opt/soapui/lib/jetty-util-6.1.15.jar:/opt/soapui/lib/servlet-api-2.5-20081211.jar:/opt/soapui/lib/jxl-2.6.10.jar:/opt/soapui/lib/idw-1.5.0.jar:/opt/soapui/lib/xbean-fixed-2.4.0.jar:/opt/soapui/lib/xbean_xpath-2.4.0.jar:/opt/soapui/lib/xmlpublic-2.4.0.jar:/opt/soapui/lib/jsr173_1.0_api-xmlbeans-2.4.0.jar:/opt/soapui/lib/soapui-3.0.1.jar:/opt/soapui/lib/soapui-xmlbeans-3.0.1.jar:/opt/soapui/lib/soapui-coverage-xmlbeans-3.0.1.jar:/opt/soapui/lib/license4j-1.3.jar:/opt/soapui/lib/ext-xmlbeans-1.1.jar:/opt/soapui/lib/policy-xmlbeans-1.5.jar:/opt/soapui/lib/soap-xmlbeans-1.2.jar:/opt/soapui/lib/wadl-xmlbeans-1.1.jar:/opt/soapui/lib/j2ee-xmlbeans-1.4.jar:/opt/soapui/lib/saxon-9.1.0.6j.jar:/opt/soapui/lib/saxon-dom-9.1.0.6j.jar:/opt/soapui/lib/xmlunit-1.2.jar:/opt/soapui/lib/xmlsec-1.4.3.jar:/opt/soapui/lib/xalan-2.7.1.jar:/opt/soapui/lib/xercesImpl-2.9.1.jar:/opt/soapui/lib/xml-apis-2.9.1.jar:/opt/soapui/lib/serializer-2.7.1.jar:/opt/soapui/lib/wss4j-1.5.8.jar:/opt/soapui/lib/opensaml-1.1.jar:/opt/soapui/lib/bcprov-jdk15-143.jar:/opt/soapui/lib/jtidy-r820.jar:/opt/soapui/lib/jxbrowser-1.3.21478.301.jar:/opt/soapui/lib/jniwrap-3.7.3.jar:/opt/soapui/lib/tuxpack-0.2.jar:/opt/soapui/lib/winpack-3.7.1.jar:/opt/soapui/lib/xulrunner-win32.jar:/opt/soapui/lib/xulrunner-linux-i686.jar:/opt/soapui/lib/xulrunner-mac-un-i386-ppc.jar:/opt/soapui/lib/MozillaGlue-jxbrowser-1.3.jar:/opt/soapui/lib/MozillaInterfaces-jxbrowser-1.3.jar:/opt/soapui/lib/netcomponents-1.3.8a.jar:/opt/soapui/lib/commons-digester-1.7.jar:/opt/soapui/lib/jasperreports-3.5.2.jar:/opt/soapui/lib/itext-2.1.0.jar:/opt/soapui/lib/jfreechart-1.0.13.jar:/opt/soapui/lib/jcommon-1.0.16.jar:/opt/soapui/lib/reports-1.0.jar:/opt/soapui/lib/wsi-test-tools-1.0.jar
java.class.version=50.0
java.endorsed.dirs=/opt/bea/jdk160_05/jre/lib/endorsed
java.ext.dirs=/opt/bea/jdk160_05/jre/lib/ext:/usr/java/packages/lib/ext
java.home=/opt/bea/jdk160_05/jre
java.io.tmpdir=/tmp
java.library.path=/opt/soapui/bin
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_05-b13
java.specification.name=Java Platform API Specification
java.specification.vendor=Sun Microsystems Inc.
java.specification.version=1.6
java.vendor=Sun Microsystems Inc.
java.vendor.url=http://java.sun.com/
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
java.version=1.6.0_05
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) Server VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Sun Microsystems Inc.
java.vm.specification.version=1.0
java.vm.vendor=Sun Microsystems Inc.
java.vm.version=10.0-b19

line.separator=


os.arch=i386
os.name=Linux
os.version=2.6.28-15-generic

path.separator=:

soapui.ext.actions=/opt/soapui/bin/actions
soapui.ext.libraries=/opt/soapui/bin/ext
soapui.ext.listeners=/opt/soapui/bin/listeners
soapui.home=/opt/soapui/bin
soapui.properties=soapui.properties

sun.arch.data.model=32
sun.awt.xembedserver=true
sun.boot.class.path=/opt/bea/jdk160_05/jre/lib/resources.jar:/opt/bea/jdk160_05/jre/lib/rt.jar:/opt/bea/jdk160_05/jre/lib/sunrsasign.jar:/opt/bea/jdk160_05/jre/lib/jsse.jar:/opt/bea/jdk160_05/jre/lib/jce.jar:/opt/bea/jdk160_05/jre/lib/charsets.jar:/opt/bea/jdk160_05/jre/classes
sun.boot.library.path=/opt/bea/jdk160_05/jre/lib/i386
sun.cpu.endian=little
sun.cpu.isalist=
sun.io.unicode.encoding=UnicodeLittle
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=UTF-8
sun.management.compiler=HotSpot Tiered Compilers
sun.os.patch.level=unknown

user.country=CZ
user.dir=/home/hisaak/soapui
user.home=/home/hisaak
user.language=cs
user.name=hisaak
user.timezone=Europe/Bratislava

wsi.dir=/opt/soapui/wsi-test-tools

I've just tried Data Connection instead of JDBC and it works! Again, the same driver, database, table, query, ...