August 2008 - users-list

[MonetDB-users] [XQuery] Communicate with Java?
by Chaojing Yang 08 Aug '08

08 Aug '08

Dear all, I'm a totally newbie and try to implements an LDAP-application over MonetDB/XQuery due to efficient search performance of column-store. Like the example XQueryLoad.java does i have succeed to import a XML-file and now come my questions: * How can i manipulate my XML-files with JAVA? Like doing searches and changes over XML-files. * How is the performance of Subtree-search? Like doing searchs over the whole tree or any subtrees. As once discussed in http://comments.gmane.org/gmane.comp.db.monetdb.user/1027, i'm in the same situation. Best regards, Chaojing Yang -- ------------------------------------------------------------------------------------------------------------------------------------------ Email: chaojing.yang(a)gmail.com Blog: http://goethe-ist-taoist.blogspot.com/ §1 Ich widerspreche der Nutzung oder Übermittlung meiner Daten für Werbezwecke oder sowie andere unbefugte Verwendungszwecke. (§ 28 Abs. 4 BDSG=Bundesdatenschutzgesetz). §2 Durch die Datenübertragung bzw. Kommunikation per E-Mail liegt ein Verstoß gegen das BDSG vor, da ihre Daten insoweit nicht ausreichend geschützt sind. Ich bitte Sie daher, mir schriftlich zu bestätigen, dass Sie mit dem Verstoß gegen das BDSG einverstanden sind und keine Schadensersatzanspräche bzw. Unterlassungsanspräche mir gegenüber geltend machen. §3 Der Inhalt dieser Nachricht ist vertraulich und nur für den oben angegebenen Empfänger bestimmt.

5 8

[MonetDB-users] Does MonetDB's JDBC Driver support CachedRowSet??
by sateesh 07 Aug '08

07 Aug '08

Hi All, I am wondering what JDBC Spec does the MonetDB's JDBC Driver conform to ? (is it JDBC3.0 ,4.0) We would like to use the pagination at the Database level and hence i want to know whether the JDBC Driver has any implementation of CachedRowSet.. Thanks Sateesh -- View this message in context: http://www.nabble.com/Does-MonetDB%27s--JDBC-Driver-support-CachedRowSet---… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] protocol violation: unexpected line in data block
by toshiki.shiga＠alsi.co.jp 07 Aug '08

07 Aug '08

Hi, All Please explain this message? "protocol violation: unexpected line in data block: #02 #GDKmemchk (memcur=16870976,memmax=1741950382) (vmcur=1047527424,vmmax=1610612736)" Regards, Shiga

3 5

[MonetDB-users] Update statement to update from other table
by Cronje Fourie 05 Aug '08

05 Aug '08

Hi all... I'm testing MonetDB and evaluating all functionality. One item I've not been able to find much info on is updating table A from table B. ie... UPDATE PERSON SET SALARY = sal.newval FROM PERSON P, SAL_DATA sal WHERE p.id = sal.p_id Or something to that effect :) Is it possible? Thanks Cronje

2 1

[MonetDB-users] Is there a recommended OS for MonetDB?
by McKennirey.Matthew 04 Aug '08

04 Aug '08

2 1

[MonetDB-users] monetdb copy command
by ashokguruswamy 01 Aug '08

01 Aug '08

my seasonal compliments.. this is ashok. i am using monetdb for my application with java. just i need to copy the monetdb table to a csv file.. in an sql manual i read the syntax for copying from table to csvfile is Syntax: COPY <subquery> INTO <file_name> [ [USING] DELIMITERS tuple_separator [’,’ record_separator [ ’,’ string_quote ]]] [ NULL AS null_string ]; Operating System: Windows XP My query: copy select * from table_name into 'D:/file_name.csv' using delimiters '|'; but if i execute this, am facing the following problem.. any suggestion? asap... Error: Syntax error, unexpected SELECT, expecting INTO in: “copy select”.. Also the query specified below which having --with null as 'null_String"-- is not working.. copy select * from table_name into 'D:/file_name.csv' using delimiters '|' with null as ' '; I want a way to copy monetdb tables to csv files.. -- View this message in context: http://www.nabble.com/monetdb-copy-command-tp18752294p18752294.html Sent from the monetdb-users mailing list archive at Nabble.com.

4 4