[R-sig-DB] Java Exception error while reading large data in R from DB using RJDBC
ajit aher
@@j|t75 @end|ng |rom y@hoo@co@|n
Tue Oct 30 15:01:47 CET 2012
Dear List,
Java Exception error while reading large data in R from DB using RJDBC.
I am trying to read large data from DB table(Vectorwise), using RJDBC connection.
I have tested the connection with small size data and was able to fetch DB tables using same connection(conn as in my code). �
Please suggest where �am i going wrong or alternate option to solve such issues �while reading large DB table.
drv <- JDBC(paste(db_driver, �sep = ""),
� � � � � �paste(db_jar_file, �sep = ""),
� � � � � �identifier.quote="`")
conn <<- dbConnect(drv, paste(db_server, �sep = ""),
� � � � � � � � � � � � � � � � � � � � paste(db_server_lgn, �sep = ""),
� � � � � � � � � � � � � � � � � � � � paste(db_server_pwd, �sep = ""))
s <- sprintf("select * from �cypress_modeldev_account_info")
�temp <- dbGetQuery(conn, s)
Error in .jcheck() :
� Java Exception <no description because toString()
failed>.jcall(rp, "I", "fetch", stride)<S4 object of class
"jobjRef">
Thanks,
Ajit
[[alternative HTML version deleted]]
More information about the R-sig-DB
mailing list