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
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
basex-talk@mailman.uni-konstanz.de