Displaying 3 results from an estimated 3 matches for "db_server_pwd".
2012 Feb 15
1
Passing date as parameter while retrieving data from database using dbGetQuery
...9; and '2011-01-31' respectively in the query code works fine
without any errors.
#####################################################################
db_driver <- mydir$db_driver
db_jar_file <- mydir$db_jar_file
db_server <- mydir$db_server
db_server_lgn <- mydir$db_server_lgn
db_server_pwd <- mydir$db_server_pwd
library(RJDBC)
.jinit(classpath="myClasses.jar", parameters="-Xmx4096m")
drv <- JDBC(paste(db_driver, sep = ""),
paste(db_jar_file, sep = ""),
identifier.quote="`")
conn <- dbConnect(drv, pa...
2012 Feb 09
0
Java heap space Error while reading table from postgres database using RJDBC
...lumns and 200000 rows.
Sample code is as below, which works fine with smaller tables.
########################################################################
db_driver <- mydir$db_driver
db_jar_file <- mydir$db_jar_file
db_server <- mydir$db_server
db_server_lgn <- mydir$db_server_lgn
db_server_pwd <- mydir$db_server_pwd
library(RJDBC)
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 = "&q...
2012 Oct 30
2
Java Exception error while reading large data in R from DB using RJDBC.
...ing 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 "j...