Oracle blob

From: Erol Akarsu [mailto:eakarsu at gmail.com] Sent: Wednesday, May 07, 2014 12:56 PM To: Dirk Kirsten; Bednar, Scott E Cc: basex-talk at 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 at basex.org<mailto:dk at 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 at dedalus.eu<mailto:marco.lettere at dedalus.eu> > <mailto:marco.lettere at dedalus.eu<mailto:marco.lettere at 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

> 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 at gmail.com] > *Sent:* Wednesday, May 07, 2014 12:56 PM > *To:* Dirk Kirsten; Bednar, Scott E > *Cc:* basex-talk at 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 at 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 at dedalus.eu > > <mailto:marco.lettere at 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 > > >