Re: [basex-talk] Out of Main Memory; bytea type

-- | Alexander von Bernuth | alexander.von-bernuth@student.uni-tuebingen.de Am 24.06.2013 um 16:58 schrieb Christian Grün: > Hi Alex, > > the mapping of types is defined in the BaseX FNSql class [1]. "bytea" > seems to be a PostgreSQL-specific data type, so I’m not sure which > mapping would be appropriate here. Could you do some research for us > and try to find out which SQL types may give satifying results (see > [2] for the existing setters)? > > Thanks, > Christian > > [1] https://github.com/BaseXdb/basex/blob/master/src/main/java/org/basex/query/f... > [2] http://docs.oracle.com/javase/6/docs/api/java/sql/PreparedStatement.html > ___________________________ > >> thank you very much, I am going to test this as soon as I am at home. I >> think this is going to fix my issue. >> However, do you happen to know which sql:parameter type I have to use when I >> try to insert xs:base64binary into my bytea-column in postgres? >> >> Thank you again, >> Alex >> >> -- >> | Alexander von Bernuth >> | alexander.von-bernuth@student.uni-tuebingen.de >> >> Am 24.06.2013 um 11:48 schrieb Christian Grün: >> >> Hi Alexander, >> >> how does your XQuery/BaseX script look like? If you use the XQuery >> doc() function, you could try to replace it with >> parse-xml(fetch:text(...)), because the latter approach will close >> your documents and free memory if the processed document is not >> required anymore. >> >> Best, >> Christian >> ___________________________ >> >> 2013/6/24 Alexander von Bernuth >> alexander.von-bernuth@student.uni-tuebingen.de: >> >> Hello all, >> >> >> my basex-script should fetch 10.000something XML-files automatically from a >> >> website and insert their content into a external PostgreSQL-database. After >> >> about 8.000 files my script stops and I get "Out of Main Memory". >> >> I found your discussion with "kgfhjjgrn" [1] regarding this issue, but I'm >> >> not sure whether these options apply to my problem - I do not build a >> >> basex-database but an external one. Will autoflush=false and flushing by >> >> myself help with this? >> >> >> Second, I want to insert some xs:base64Binary into my PostgreSQL database, >> >> but I cannot find the correct sql:parameter type for the bytea-column. >> >> >> Could you please help me with my issues? >> >> >> Thank you very much, >> >> Alexander >> >> >> >> >> [1] http://comments.gmane.org/gmane.text.xml.basex.talk/2540 >> >> >> >> >> -- >> >> | Alexander von Bernuth >> >> | alexander.von-bernuth@student.uni-tuebingen.de >> >> >> >> _______________________________________________ >> >> BaseX-Talk mailing list >> >> BaseX-Talk@mailman.uni-konstanz.de >> >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >> >> >>