Oracle blob
Thursday, 8 May 2014 · 2 messages
EA
Erol Akarsu8 May 2014 00:37 #
Scott,
I want this setting for only importing blob data but doesn't need all other times,
Quoted text · 1 line
>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 at boeing.com>wrote:
Quoted text · 121 lines
> 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 > > >
EA
Erol Akarsu8 May 2014 00:55 #
Also,
I need to upload binary data into Oracle and can see I can not do it with current Basex. Am I wrong?
Probably, I need to use native method calls. How can I get Connection object from
sql:connect basex xquery method?
Then I can call creatBlob method on connection object as the following
http://docs.oracle.com/cd/E18283_01/java.112/e16548/jdbcvers.htm#BCFIDIEHConnection con = DriverManager.getConnection(url, props);
Blob aBlob = con.createBlob();
// Add data to the BLOB object.
aBlob.setBytes(...);Quoted text · Erol Akarsu · 145 lines
On Wed, May 7, 2014 at 4:37 PM, Erol Akarsu <eakarsu at gmail.com> wrote: > 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 at 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 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 >> >> >> > >
Written for BaseX 7.8. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery