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. On Thu, Mar 12, 2009 at 3:27 AM, Tom H <tom@limepepper.co.uk> wrote:
Yue Sheng wrote:
> !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.
How big is the /Users partition on the disk? # 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