This is the loop I used, as I'm inserting a file at a time.
drv <- JDBC("nl.cwi.monetdb.jdbc.MonetDriver","/Users/someuser/monetDB64/share/MonetDB/lib/monetdb-1.9-jdbc.jar")
conn <- dbConnect(drv, "jdbc:monetdb://localhost/bigdata","username","password")
for (i in 1:length(filenames)) {
str <- paste("copy into usrtable from '", wholename[i],"' using delimiters '|';", sep="")
try(dbSendUpdate(conn, str))
}
where filesnames are file names and wholename are same as filenames but has directory info as well.
Thanks.
Yue Sheng wrote:How big is the /Users partition on the disk?
> > !ERROR: logger_exit: could not open
> > /Users/someuser/MonetDB64/var/MonetDB5/sql_logs/bigdata/sql/log
> This looks as if the device on which you attempt to write
> is full.
# df -h
Tom
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users