[Rd] rJava and RJDBC
I am desperate for help.
I am trying to get the RJDBC and rJava .5to work on both my windows xp
and linux Redhat EL5 Server. On both I get a
ava.lang.ClassNotFoundException when calling JDBC().
My example is
require(RJDBC)
classPath='C:\\libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar'
driverClass=c("com.mysql.jdbc.Driver")
drv <- JDBC(c("com.mysql.jdbc.Driver"),classPath,"`")
This returns a NULL value and a java exception.
> .jgetEx()
[1] "Java-Object{java.lang.ClassNotFoundException: com.mysql.jdbc.Driver}"
my java version is
> .jcall('java.lang.System','S','getProperty','java.version')
[1] "1.6.0_02"
jre
When I use java 1.5.0_11 jre I have the same problem but the .jgetEx()
is
> .jgetEx()
[1] "Java-Object{}
my class path is
> .jclassPath()
[1] "C:\\PROGRA~1\\R\\library\\rJava\\java"
[2] "."
[3]
"C:\\libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar"
[4] "C:\\libraries\\xmlbeans-2.0.0-beta1\\lib\\xbean.jar"
[5] "C:\\libraries\\POI\\poi-2.5.1-final-20040804.jar"
[6] "C:\\libraries\\POI\\poi-contrib-2.5.1-final-20040804.jar"
[7] "C:\\libraries\\POI\\poi-scratchpad-2.5.1-final-20040804.jar"
[8] "C:\\Libraries\\PJM\\eDataFeed.jar"
[9] "C:\\Libraries\\PJM\\webserviceclient.jar"
[10] "C:\\Java\\Libraries\\QTJava.zip"
My java_Home is
> .jcall('java.lang.System','S','getProperty','java.home')
[1] "C:\\Java\\jre1.6.0_02"
I have tried breaking down the JDBC as
.jinit() or .jinit(classPath)
v<-.jcall("java/lang/ClassLoader","Ljava/lang/ClassLoader;",
"getSystemClassLoader")
.jcall("java/lang/Class", "Ljava/lang/Class;",
"forName", as.character(driverClass)[1], TRUE, v)
to no avail.
I have tried different versions of the mysql jar.
I do not know if my java version not compatible, my java settings are
wrong, or I am just blind to the problem. This is the same for both my
Windows XP and Redhat EL5 Server.
I really appreciate any and all assistance.
Thank you
Joe
__
R-devel@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
Re: [Rd] rJava and RJDBC
Simon Urbanek r-project.org> writes:
>
> Joe,
>
> which version of R and RJDBC are you using? The behavior you describe
> should have been fixed in RJDBC 0.1-4. Please try the latest version
> from rforge
> install.packages("RJDBC",,"http://rforge.net/";)
> and please let me know if that solves your problem.
>
> Cheers,
> Simon
Simon,
Thank you so much. I have been working on this for a week.
I also have not been using rforge.net as a repository only the defaults to get
my package update. Usually the IL mirror.
This really rocks!.
Agains, Thank you and have a wonderful day.
Joe
__
R-devel@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
[Rd] Rexcelpoi
I was experimenting with Rexcelpoi from Armstrong Whit. I was able to
compile the package in my Redhat linux machine with a few warnings but
no errors. I was not able to get the package built on my windows xp
computer, but that is for another post.
I load R on the linux computer and type in the library call to Rexcelpoi
the receive the following error.
library(Rexcelpoi)
*** caught segfault ***
address (nil), cause 'memory not mapped'
Traceback:
1: dyn.load(file, ...)
2: library.dynam(lib, package, package.lib)
3: loadNamespace(package, c(which.lib.loc, lib.loc), keep.source =
keep.source)
4: doTryCatch(return(expr), name, parentenv, handler)
5: tryCatchOne(expr, names, parentenv, handlers[[1]])
6: tryCatchList(expr, classes, parentenv, handlers)
7: tryCatch(expr, error = function(e) {call <- conditionCall(e)
if (!is.null(call)) {if (identical(ca ll[[1]],
quote(doTryCatch))) call <- sys.call(-4)dcall <-
deparse(call)[1]prefix <- paste ("Error in", dcall, ": ")
LONGCALL <- 30if (nchar(dcall) > LONGCALL)
prefix <- paste(prefi x, "\n\t", sep = "")}else prefix <-
"Error : "msg <- paste(prefix, conditionMessage(e), "\n", sep = "")
.Internal(seterrmessage(msg[1]))if (!silent &&
identical(getOption("show.error.messages"), TRUE)) {
cat(msg, file = stderr()).Internal(printDeferredWarnings())
}invisible(structure(msg, class = "try -error"))})
8: try({ns <- loadNamespace(package, c(which.lib.loc, lib.loc),
keep.source = keep.source)dataPath <- file.p
ath(which.lib.loc, package, "data")env <- attachNamespace(ns, pos =
pos, dataPath = dataPath)})
9: library(Rexcelpoi)
Possible actions:
1: abort (with core dump, if enabled)
2: normal R exit
3: exit R without saving workspace
4: exit R saving workspace
Selection:
Some things I can figure out, but this one is beyond my capabilities.
Any thoughts or suggestions are greatly appreciated. If you think the
build warnings are important, I can rebuild the package and post those.
Everyone have a wonderful day.
Thank you
Joe
__
R-devel@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
[Rd] RPM Key in Readme file
The readme file on the cran website for linux EL5 contains the following RPMS for Red Hat Enterprise Linux created by Bob Kinney <[EMAIL PROTECTED]>. The RPMS are signed with the following key available from pgp.mit.edu Type bits /keyIDDate User ID pub 1024D/99B62126 2004/11/18 HMDC Linux Support <[EMAIL PROTECTED]> I went ot pgp.mit.edu and could not find the key. Any suggestions? Have a Happy Halloween all. Joe __ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
Re: [Rd] RPM Key in Readme file
Marc Schwartz wrote: > On Wed, 2007-10-31 at 22:35 -0500, Joe W. Byers wrote: > >> Marc Schwartz wrote: >> >>> On Wed, 2007-10-31 at 22:04 -0500, Joe W. Byers wrote: >>> >>> >>>> The readme file on the cran website for linux EL5 contains the following >>>> RPMS for Red Hat Enterprise Linux created by Bob Kinney >>>> <[EMAIL PROTECTED]>. The RPMS are signed with the following >>>> key available from pgp.mit.edu >>>> >>>> Type bits /keyIDDate User ID >>>> pub 1024D/99B62126 2004/11/18 HMDC Linux Support >>>> <[EMAIL PROTECTED]> >>>> >>>> I went ot pgp.mit.edu and could not find the key. >>>> >>>> Any suggestions? >>>> >>>> Have a Happy Halloween all. >>>> >>>> Joe >>>> >>>> >>> Joe, >>> >>> How did you search? >>> >>> Using gpg: >>> >>> $ gpg --keyserver pgp.mit.edu --search-keys >>> "[EMAIL PROTECTED]" >>> gpg: searching for "[EMAIL PROTECTED]" from hkp server >>> pgp.mit.edu >>> (1) HMDC Linux Support <[EMAIL PROTECTED]> >>> 1024 bit DSA key 99B62126, created: 2004-11-18 >>> Enter number(s), N)ext, or Q)uit > 1 >>> gpg: requesting key 99B62126 from hkp server pgp.mit.edu >>> gpg: key 99B62126: public key "HMDC Linux Support >>> <[EMAIL PROTECTED]>" imported >>> gpg: Total number processed: 1 >>> gpg: imported: 1 >>> >>> >>> >>> Using the web site with the e-mail address as the search string: >>> >>> http://pgp.mit.edu:11371/pks/lookup?search=linux_support%40latte.harvard.edu&op=vindex&fingerprint=on >>> >>> >>> Public Key Server -- Verbose Index [EMAIL PROTECTED] '' >>> Type bits /keyIDDate User ID >>> pub 1024D/99B62126 2004/11/18 HMDC Linux Support <[EMAIL PROTECTED]> >>> Key fingerprint = 352A C4ED 6B3C C121 53FA 61AE C8E0 D236 99B6 2126 >>> sig99B62126 HMDC Linux Support <[EMAIL PROTECTED]> >>> >>> >>> HTH, >>> >>> Marc Schwartz >>> >>> >>> >>> >> I just used the search engine with HMDC and 99B. I also went to the >> full list and looked by date as well as the two searches. I could >> have just completely missed it. I think I searched linux as well. >> >> I did not turn verbose on though. >> >> Sorry about this. >> >> Joe >> > > You cannot search using just part of the Key ID. Also, if you want to > search on the Key ID, which is of course a hex number, you need to > prefix it with '0x'. So: > > http://pgp.mit.edu:11371/pks/lookup?search=0x99B62126&op=index > > Public Key Server -- Index ``0x99B62126 '' > Type bits /keyIDDate User ID > pub 1024D/99B62126 2004/11/18 HMDC Linux Support <[EMAIL PROTECTED]> > > > You can however search using part of the User ID: > > http://pgp.mit.edu:11371/pks/lookup?search=HMDC&op=index > > Public Key Server -- Index ``HMDC '' > Type bits /keyIDDate User ID > pub 1024D/99B62126 2004/11/18 HMDC Linux Support <[EMAIL PROTECTED]> > > > HTH, > > Marc > > > Thank you very much, I just need to import it later this week. Joe [[alternative HTML version deleted]] __ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
