Issue Get Data from XML file

[wesley.rocha]

Hello everybody

I'm running the Kettle 3.2.0 on a VM with OpenSUSE 11.2...
I'm trying to use the Get Data from XML and trying to configure that to read from a specific file.
The problem is when I try to open the BROWSE window (to browse the file), simply the window don't appear....
Anybody know something about this???

thanks a lot!!!

[slawomir.chodnicki]

Are you saying that you are using a non-sun vm? Which one is it exactly?

[wesley.rocha]

I'm using VMWare to run a Linux OpenSUSE 11.2...

thanks for reply!!!

[slawomir.chodnicki]

Sorry, my question was referring the Java-VM you have on your OpenSUSE 11.2. If you did not manually install the Sun JVM, it is likely that you have some version of OpenJDK installed. My experience is that you get all kinds of strange misbehaviour in Kettle 3.2.0 if you use OpenJDK. You need the Sun JVM.

http://wiki.opensuse.org/SDB:Installing_Sun's_Java_on_openSUSE

[wesley.rocha]

I've installed manually the package jre 1.5.22 on my system... it's not uptodate... do you think that I should get the latest version???

[slawomir.chodnicki]

Well, I think you should make sure you got the latest Sun VM installed and all other JVMS uninstalled. You should check the java.vendor system property inside kettle to be absolutely sure about what your Ketle runs on.

[wesley.rocha]

Ok... I'll try to run on an up to date JVM...
Thanks for your support....

Sooner I'll came back to post the result... :D

Thanks a lot

[wesley.rocha]

Hi,
I tried to update my VM, and install a diferent JRE.

wesley@linux-ei6e:~/Desktop> java -version
java version "1.6.0_0"
OpenJDK Runtime Environment (IcedTea6 1.6) (suse-5.9.4-i386)
OpenJDK Client VM (build 14.0-b16, mixed mode)
wesley@linux-ei6e:~/Desktop> rpm -qa | grep jre
jre-1.6.0_20-fcs.i586
wesley@linux-ei6e:~/Desktop>

But I'm still got the problem. Am I doing something wrong???

Thanks

[slawomir.chodnicki]

Well, it seems like you are still running on OpenJDK. You need the Sun JVM.

Check out this link: http://wiki.opensuse.org/SDB:Installing_Sun's_Java_on_openSUSE
And make sure OpenJDK is not installed

[wesley.rocha]

thank you again my friend!!!

But I don't have connection with internet on my machine running kettle. so I have some problems to get the packages.
I've searched for SUN on "available packages" but did'nt find.
I uninstalled the openJDK, and now it's like that...

linux-ei6e:/ # java -version
java version "1.5.0"
gij (GNU libgcj) version 4.4.1 [gcc-4_4-branch revision 150839]

Copyright (C) 2007 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

I think that still not a SUN version right???

But I downloaded the JRE from SUN site, and tried to install through RPM package manually...

and now i have this....

linux-ei6e:/ # rpm -qa | grep jre
jre-1.6.0_20-fcs.i586

I don't know if Im doing something wrong... I'm new on linux and kettle world...

thanks for your support.

[wesley.rocha]

ok!!! :D

Now I think that I have the correct JAVA version on my system...

orap@linux-ei6e:~> java -version
java version "1.6.0_20"
Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
Java HotSpot(TM) Client VM (build 16.3-b01, mixed mode, sharing)
orap@linux-ei6e:~> /var/orap/data-integration/spoon.sh

I removed the packages usig RPM tool... and installed the JDK from SUN.

But I'm still have the problem...

When I open the 'Get XML Data' in my Spoon, I can't open any window (like to browse files).
And I have noted that in the command line, a message like that pops up...

INFO 11-06 15:46:54,258 - RepositoriesMeta - Reading repositories XML file: /home/orap/.kettle/repositories.xml

(SWT:3873): Gtk-WARNING **: gtk_widget_size_allocate(): attempt to allocate widget with width -5 and height 17

(SWT:3873): Gtk-WARNING **: gtk_widget_size_allocate(): attempt to allocate widget with width -5 and height 17

(SWT:3873): Gtk-WARNING **: gtk_widget_size_allocate(): attempt to allocate widget with width -5 and height 17

(SWT:3873): Gtk-WARNING **: gtk_widget_size_allocate(): attempt to allocate widget with width -5 and height 17


And this just happen with the 'Get XML data' step.
With a step like 'Streaming XML Input' I don't have problem. I can browse my files easily....

Anybody has seen something like that???

Thanks a lot!!!

[slawomir.chodnicki]

Yeah, that looks good :-)

It might help to clear your kettle preferences. To do that you can shutdown Kettle, delete the file ~/.kettle/.spoonrc and reopen kettle.

Cheers
Slawo

[wesley.rocha]

Yeah!!! :D

It worked man!!!

Now seems to be everything fine

Thank you very much for your support.