Skip to content
Prev 1083 / 1559 Next
Original Raw

RJDBC and dbWriteTable

Joseph Magagnoli 
Hi all,
I recently installed RJDBC and successfully connected to the  Oracle
database.

I am now trying to append a dataframe named  "cancel" to an Oracle data
table "cust_scores_staging_restart"


jdbcConnectionString <- "jdbc:oracle:thin:@dfw2rs770.is.aserver.com:1521
:mkmt"
 ojdbcPath <- "/u01/home/oracle/product/11.2.0/jdbc/lib/ojdbc6.jar"
 drv <- JDBC("oracle.jdbc.driver.OracleDriver", ojdbcPath, "'")
 conn <- dbConnect(drv, jdbcConnectionString, user = "xxxxx",
                   password = "xxxxx")


rs <- dbWriteTable(conn,"cust_scores_staging_restart",cancel, append=T,
row.names=F)
append=TRUE, row.names=F)
Error in .local(conn, statement, ...) :
  execute JDBC update query failed in dbSendUpdate (ORA-00955: name is
already used by an existing object)
R version 2.12.1 (2010-12-16)
Platform: x86_64-unknown-linux-gnu (64-bit)
locale:
 [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C
 [3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8
 [5] LC_MONETARY=C              LC_MESSAGES=en_US.UTF-8
 [7] LC_PAPER=en_US.UTF-8       LC_NAME=C
 [9] LC_ADDRESS=C               LC_TELEPHONE=C
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C
attached base packages:
[1] grid      splines   stats     graphics  grDevices utils     datasets
[8] methods   base
other attached packages:
 [1] RJDBC_0.2-0          rJava_0.8-8          DBI_0.2-5

Any help would be greatly appreciated.

Joe