SQL for Basex
Saturday, 1 October 2011 · 2 messages
CG
Hi Erol,
what does the error message say if you uncomment the
sql:init() call?
ChristianQuoted text · Erol Akarsu · 46 lines
> let $url := "jdbc:oracle:thin at xxx.com:1521/b2bdev" > (: let $l := sql:init("oracle.jdbc.driver.OracleDriver") :) > > let $ll := sql:connect($url) > > return $ll > > > Result > > > Query: let $url := "jdbc:oracle:thin at xxx.com:1521/b2bdev" > (: let $l := sql:init("oracle.jdbc.driver.OracleDriver") :) > > let $ll := sql:connect($url) > > return $ll > > Error: [FOSQ0001] An SQL exception occurred: 'No suitable driver found for > jdbc:oracle:thin at xxx.com:1521/b2bdev' > Thanks > > Erol Akarsu > > On Fri, Sep 30, 2011 at 8:30 PM, developer loke <developer.loke at gmail.com> > wrote: >> >> Hi. I am looking for options to configure the server as documented in >> the Wiki, but I can not find .basex file anywhere, and there seems to >> be no documentation on the Wiki. I am specifically looking for >> settings to bind the server to a particular IP address. >> >> Thanks >> Loke >> _______________________________________________ >> BaseX-Talk mailing list >> BaseX-Talk at mailman.uni-konstanz.de >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > >
EA
Erol Akarsu1 Oct 2011 21:58 #
I am testing SQL functions in upcoming basex 6.8. I downloaded snapshot and run it against oracle and provided oracle jdbc driver.
But it could not find driver. I am using MAC OSX Lion
Here is how I execute:
java -cp ~/workspace/lib/ojdbc14.jar -jar ~/Desktop/basex-6.8-SNAPSHOT.jar
let $url := "jdbc:oracle:thin at xxx.com:1521/b2bdev"
(: let $l := sql:init("oracle.jdbc.driver.OracleDriver") :)
let $ll := sql:connect($url)return $ll
Result
Query: let $url := "jdbc:oracle:thin at xxx.com:1521/b2bdev"
(: let $l := sql:init("oracle.jdbc.driver.OracleDriver") :)
let $ll := sql:connect($url)return $ll
Error: [FOSQ0001] An SQL exception occurred: 'No suitable driver found for jdbc:oracle:thin at xxx.com:1521/b2bdev'
Thanks
Erol Akarsu
On Fri, Sep 30, 2011 at 8:30 PM, developer loke <developer.loke at gmail.com>wrote:
Quoted text · 12 lines
> Hi. I am looking for options to configure the server as documented in > the Wiki, but I can not find .basex file anywhere, and there seems to > be no documentation on the Wiki. I am specifically looking for > settings to bind the server to a particular IP address. > > Thanks > Loke > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >
Written for BaseX 6.7. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery