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

On Wed, May 27, 2015 at 12:57 PM, James Wright <balugajames@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@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