Scott,

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?

Thanks

Erol Akarsu

On Wed, May 7, 2014 at 4:13 PM, Bednar, Scott E scott.e.bednar@boeing.comwrote:

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

Erol, I don’t know of a way to set this dynamically (though there might be some method of doing this…) Are you saying you need to have the proprietary Oracle XMLType returned sometimes, and the JDBC standard SQLXML type object others? I’d stick with the standard if you can.

Scott

From: Erol Akarsu [mailto:eakarsu@gmail.com] Sent: Wednesday, May 07, 2014 1:37 PM To: Bednar, Scott E Cc: Dirk Kirsten; basex-talk@mailman.uni-konstanz.de Subject: Re: [basex-talk] Oracle blob

Scott,

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? Thanks Erol Akarsu

On Wed, May 7, 2014 at 4:13 PM, Bednar, Scott E <scott.e.bednar@boeing.commailto: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.commailto:eakarsu@gmail.com] Sent: Wednesday, May 07, 2014 12:56 PM To: Dirk Kirsten; Bednar, Scott E Cc: basex-talk@mailman.uni-konstanz.demailto: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

Sorry, I’m probably not much help with inserting BLOBs – it’s not something I’ve done before either in Oracle or BaseX.

Scott

From: Erol Akarsu [mailto:eakarsu@gmail.com] Sent: Wednesday, May 07, 2014 2:56 PM To: Bednar, Scott E Cc: Dirk Kirsten; basex-talk@mailman.uni-konstanz.de Subject: Re: [basex-talk] Oracle blob

Scott, Like to insert pdf document or image into one blob field of a table,

Erol Akarsu

On Wed, May 7, 2014 at 5:49 PM, Bednar, Scott E <scott.e.bednar@boeing.commailto:scott.e.bednar@boeing.com> wrote: Erol, I don’t know of a way to set this dynamically (though there might be some method of doing this…) Are you saying you need to have the proprietary Oracle XMLType returned sometimes, and the JDBC standard SQLXML type object others? I’d stick with the standard if you can.

Scott

From: Erol Akarsu [mailto:eakarsu@gmail.commailto:eakarsu@gmail.com] Sent: Wednesday, May 07, 2014 1:37 PM To: Bednar, Scott E Cc: Dirk Kirsten; basex-talk@mailman.uni-konstanz.demailto:basex-talk@mailman.uni-konstanz.de

Subject: Re: [basex-talk] Oracle blob

Scott,

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? Thanks Erol Akarsu

On Wed, May 7, 2014 at 4:13 PM, Bednar, Scott E <scott.e.bednar@boeing.commailto: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.commailto:eakarsu@gmail.com] Sent: Wednesday, May 07, 2014 12:56 PM To: Dirk Kirsten; Bednar, Scott E Cc: basex-talk@mailman.uni-konstanz.demailto: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