Re: [basex-talk] Oracle blob

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.orgmailto: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.eumailto:marco.lettere@dedalus.eu <mailto:marco.lettere@dedalus.eumailto: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