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/func/FNSql.java[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