Connection con = DriverManager.getConnection(url, props); Blob aBlob = con.createBlob(); // Add data to the BLOB object. aBlob.setBytes(...);
Erol AkarsuThanksScott,
I want this setting for only importing blob data but doesn't need all other times,
>set PROPS=-Doracle.jdbc.getObjectReturnsXMLType="false"
Is there a way to turn on and off for this setting in basex application instead of setting it globally?
On Wed, May 7, 2014 at 4:13 PM, Bednar, Scott E <scott.e.bednar@boeing.com> wrote:
My experience has been limited to extracting XML CLOBs from Oracle, however some of the setup information I posted may be of use:
https://mailman.uni-konstanz.de/pipermail/basex-talk/2014-March/006507.html
Also, you might take a look at the Oracle documentation for LOB creation in JDBC 4.0:
http://docs.oracle.com/cd/E18283_01/java.112/e16548/jdbcvers.htm#BCFIDIEH
I’m not sure BaseX supports this JDBC interface or not, but it did for XML extraction.
Thanks, Scott
From: Erol Akarsu [mailto:eakarsu@gmail.com]
Sent: Wednesday, May 07, 2014 12:56 PM
To: Dirk Kirsten; Bednar, Scott E
Cc: basex-talk@mailman.uni-konstanz.de
Subject: Re: [basex-talk] Oracle blob
Scott,
Can you please share your experience?
Thanks
On Wed, May 7, 2014 at 3:43 PM, Dirk Kirsten <dk@basex.org> wrote:
Hello Erol,
Some time ago we had a short discussion on the ML about using clob with
Oracle:
https://mailman.uni-konstanz.de/pipermail/basex-talk/2014-March/006481.html
Blob is even a standard java.sql type and should work fine. If not,
don't hesitate to report a bug here.
Cheers,
Dirk
PS: Next time you might want to start a new conversion with a different
title... makes stuff easier to find in the future for other people,
which might run into the same problem.
On 07/05/14 21:35, Erol Akarsu wrote:
> Thanks Marco,
>
> I have another question.
> I am trying to use Basex's SQL functions. I have tried some basic SQL
> commands for connecting and selecting some rows from table, it works fine.
>
> For my project, I need to upload and export pdf document/word
> doc/images form/into Oracle database that needs some special
> oracle-specific stuff.
> Has anybody tried to upload blob/digital document to Oracle with Basex?
> I appreciate any help
>
> Erol Akarsu
>
>
> On Tue, May 6, 2014 at 2:07 PM, Marco Lettere <marco.lettere@dedalus.eu
> <mailto:marco.lettere@dedalus.eu>> wrote:
>
> Hi Erol,.
> try
>
> element book {
>
> for $i in 1 to 4
> return attribute {xs:QName("isbn_" || $i)} { "value" || $i}
>
> }
>
> Regards,
> Marco.
>
>
> On 06/05/2014 19:48, Erol Akarsu wrote:
>
> I would like to create an xml element that will have dynamic
> number of attributes, something like this where n will change
> and $value_1 to $value_2 will be provided by outside
>
> element book {
> attribute isbn_1 {$value_1}
> attribute isbn_2 {$value_2}
> attribute isbn_3 {$value_3}
> .
> .
> .
> attribute isbn_n {$value_n}
> }
>
> Can we do it?
>
> Thanks
>
>
>
--
Dirk Kirsten, BaseX GmbH, http://basex.org
|-- Firmensitz: Blarerstrasse 56, 78462 Konstanz
|-- Registergericht Freiburg, HRB: 708285, Geschäftsführer:
| Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle
`-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22