R help - May 2012 - Java problem - XLConnect/xlsx package

Hi,

I hope you guys can help me, I already posted this question on
stackoverflow but did not get any help (which worked). And I need to solve
this problem as quick as possible:

In our firm we migrated to windows 7 (64-bit) and also updated the java
packages (1.6.0_24) and also R (to 2.15). Then I tried to install my
packages which i use daily and one of em is the xlsx package.

But if I load the package I get the following error:

"Error : .onAttach in attachNamespace() Error: .jnew(
"org/apache/poi/xssf/usermodel/XSSFWorkbook") "

I did seth a path variable to the java folder (where the jvm.dll is).

Then I tried to install the XLConnect package (which would not be that
difficult to re-write my code to that package), this package loads without
problems, but if I try to load a workbook an error comes up:

Error: NoSuchMethodError (Java): org.apache.xmlbeans.XmlOptions.
setSaveAggressiveNamespaces()Lorg/apache/xmlbeans/XmlOptions;

Since I've never worked with Java (not as a developer) I have no idea what
I can do to solve the problem.

I hope you can help me! Thank you very much.

Best regards
Rainer


Here's my sessionInfo():

R version 2.15.0 (2012-03-30)
Platform: i386-pc-mingw32/i386 (32-bit)

locale:
[1] LC_COLLATE=German_Austria.1252  LC_CTYPE=German_Austria.1252
[3] LC_MONETARY=German_Austria.1252 LC_NUMERIC=C
[5] LC_TIME=German_Austria.1252

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base

other attached packages:
[1] XLConnect_0.1-9     XLConnectJars_0.1-4 rJava_0.9-3
knitr_0.5

loaded via a namespace (and not attached):
 [1] codetools_0.2-8 digest_0.5.2    evaluate_0.4.2  formatR_0.4
highlight_0.3.1
 [6] parser_0.0-14   plyr_1.7.1      Rcpp_0.9.10     stringr_0.6
tools_2.15.0

	[[alternative HTML version deleted]]

Hi Rainer,

Looking at your sessionInfo() it looks like you are using 32-bit R on 64-bit
Windows 7. My guess is that the installed JVM is 64-bit. This leads to an
architecture clash between R and Java. It is important to make sure that the
architectures of R and the JVM match, i.e. either both are 32-bit or both
are 64-bit. Can you verify if this is the case? Run "java -version" on
the
command line to see whether you are using a 32-bit or 64-bit JVM.

Regards,
Martin

--
View this message in context:
http://r.789695.n4.nabble.com/Java-problem-XLConnect-xlsx-package-tp4631304p4631365.html
Sent from the R help mailing list archive at Nabble.com.