SQL Module
Wednesday, 27 May 2015 · 2 messages
JW
James Wright27 May 2015 20:57 #
Hey Everyone,
I am having issues with using the Oracle 1.7 JDBC driver.
I copied the ojdbc7.jar file into the lib directory
Ran the basexgui.bat to add to class path
Tried to run this script:
let $conn := sql:init('jdbc:oracle:thin:pnm/pnm at orc1n.giants')
return
(sql:execute($conn, 'SELECT owner, table_name FROM dba_tables '),
sql:close($conn))It states that it cannot initialize the jdbc:oracle:thin driver. Any ideas why that would be? Am I missing something?
- James
EA
Erol Akarsu27 May 2015 21:27 #
James,
I used it with ojdcs6 driver and it worked perfectly but I have not tested with 1.7 driver. I guess it should work.
Nice thing with Basex SQL module is that you can export any size of sql table to an xml file, there is no limitation.
I had to export huge SQL tables and BaseX did it perfectly,
Erol Akarsu
Quoted text · James Wright · 20 lines
On Wed, May 27, 2015 at 12:57 PM, James Wright <balugajames at gmail.com> wrote: > Hey Everyone, > > I am having issues with using the Oracle 1.7 JDBC driver. > > I copied the ojdbc7.jar file into the lib directory > Ran the basexgui.bat to add to class path > Tried to run this script: > > let $conn := sql:init('jdbc:oracle:thin:pnm/pnm at orc1n.giants') > return > (sql:execute($conn, 'SELECT owner, table_name FROM dba_tables '), > sql:close($conn)) > > It states that it cannot initialize the jdbc:oracle:thin driver. Any ideas > why that would be? Am I missing something? > > - James >
Written for BaseX 8.2. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery