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
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