Displaying 3 results from an estimated 3 matches for "db_server_lgn".
2012 Feb 15
1
Passing date as parameter while retrieving data from database using dbGetQuery
...d_dt are replaced
by '2010-11-01' 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=&quo...
2012 Feb 09
0
Java heap space Error while reading table from postgres database using RJDBC
...ssion using RJDBC, table
contains 150 columns 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 = ""),...
2012 Oct 30
2
Java Exception error while reading large data in R from DB using RJDBC.
...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",
"f...