Re: [basex-talk] BaseX and MySQL: Driver can't be initialized
Thanks everybody, starting the GUI from command line did the trick. Best regards, Ulrike.
Re: [basex-talk] BaseX and MySQL: Driver can't be initialized
Thanks everybody, starting the GUI from command line did the trick. Best regards, Ulrike.
[basex-talk] BaseX and MySQL: Driver can't be initialized
Hi everybody,
I know, that this issue has been discussed already, but I still have problems
concerning BaseX and MySQL:
Of course I read the documentation: I downloaded the Connector/J from the MySQL
website and put the .jar file (mysql-connector-java-5.1.36-bin.jar) into the
basex/lib folder. I closed and restarted the GUI and tried the following:
import module namespace sql="http://basex.org/modules/sql;;
sql:init("com.mysql.jdbc.Driver")
I receive the following error message:
[bxerr:BXSQ0007] Could not initialize supplied driver: 'com.mysql.jdbc.Driver'
Is there something obvious I'm missing?
Best regards,
Ulrike.
Re: [basex-talk] BaseX and MySQL: Driver can't be initialized
Hi Ulrike,
it seems the Connector/J .jar is not loaded.
What OS do you use?
How did you trigger the restart of BaseXGUI after putting
mysql-connector-java-5.1.36-bin.jar into the lib folder?
Here is a workflow you can try (using the .zip BaseX distribution and the
./bin/basex startup files):
$ wget http://files.basex.org/releases/latest/BaseX83-20150825.081504.zip
$ unzip BaseX83-20150825.081504.zip
$ ./basex/bin/basex -q 'sql:init("com.mysql.jdbc.Driver")'
Stopped at ., 1/10:
[bxerr:BXSQ0007] Could not initialize supplied driver: 'com.mysql.jdbc.Driver'
Download Platform Independent (Architecture Independent), Compressed TAR
Archive 'mysql-connector-java-5.1.36.tar.gz' from
https://dev.mysql.com/downloads/connector/j/
$ tar xvjf ~/Downloads/mysql-connector-java-5.1.36.tar.gz .
$ cp mysql-connector-java-5.1.36/mysql-connector-java-5.1.36-bin.jar basex/lib
$ ./basex/bin/basex -q 'sql:init("com.mysql.jdbc.Driver")'
$
All the best
Alex
> On 31.08.2015, at 09:27, Ulrike Schaper - SideStep Business Solutions GmbH
> wrote:
>
> Hi everybody,
>
> I know, that this issue has been discussed already, but I still have problems
> concerning BaseX and MySQL:
>
> Of course I read the documentation: I downloaded the Connector/J from the
> MySQL website and put the .jar file (mysql-connector-java-5.1.36-bin.jar)
> into the basex/lib folder. I closed and restarted the GUI and tried the
> following:
>
> import module namespace sql="http://basex.org/modules/sql;;
> sql:init("com.mysql.jdbc.Driver")
>
> I receive the following error message:
> [bxerr:BXSQ0007] Could not initialize supplied driver: 'com.mysql.jdbc.Driver'
>
> Is there something obvious I’m missing?
>
> Best regards,
> Ulrike.
Re: [basex-talk] BaseX and MySQL
Dear all,
You might have to add the following call before sql :connect() :
sql:init(com.mysql.jdbc.Driver)
I found it mandatory in xqm modules run inside Tomcat, for example.
If you start playing with the SQL module,
You will realize that BaseX rocks also on SQL repositories !
With RESTXQ+SQLMODULE you can write in a few lines a REST service exposing SQL
data.
Best regards,
Fabrice Etanchaud
Questel/Orbit
De : basex-talk-boun...@mailman.uni-konstanz.de
[mailto:basex-talk-boun...@mailman.uni-konstanz.de] De la part de Lizzi, Vincent
Envoyé : mercredi 19 novembre 2014 23:31
À : Hans-Juergen Rennau; basex-talk@mailman.uni-konstanz.de
Objet : Re: [basex-talk] BaseX and MySQL
Hans,
I had to do this a few days ago, so it’s fresh in my mind. Download Connector/J
from the MySQL website and place .jar file in the basex/lib folder. Restart
BaseX (if you’re using the server version) so it picks up the new .jar.
Queries can then be run like:
let $c := sql:connect('jdbc:mysql://localhost/database', 'user', 'password')
sql:execute($c, select …)
sql:execute($c, call stored_procedure…();)
Cheers,
Vincent
From:
basex-talk-boun...@mailman.uni-konstanz.demailto:basex-talk-boun...@mailman.uni-konstanz.de
[mailto:basex-talk-boun...@mailman.uni-konstanz.de] On Behalf Of Hans-Juergen
Rennau
Sent: Wednesday, November 19, 2014 5:20 PM
To:
basex-talk@mailman.uni-konstanz.demailto:basex-talk@mailman.uni-konstanz.de
Subject: [basex-talk] BaseX and MySQL
Dear BaseX team,
can you point me to some information about which steps I must take in order to
start accessing MySQL databases via the sql module?
Thank you for help,
Hans-Juergen
Re: [basex-talk] BaseX and MySQL
Vincent, cordial thanks for your concise instructions, you helped me a lot, it
works and I am glad. And also thanks to Fabrice.
Cheers,
Hans
Fabrice Etanchaud fetanch...@questel.com schrieb am 9:35 Donnerstag,
20.November 2014:
#yiv2295957486 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2
4;}#yiv2295957486 filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2
4;}#yiv2295957486 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2
4;}#yiv2295957486 filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2
4;}#yiv2295957486 p.yiv2295957486MsoNormal, #yiv2295957486
li.yiv2295957486MsoNormal, #yiv2295957486 div.yiv2295957486MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv2295957486 a:link,
#yiv2295957486 span.yiv2295957486MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv2295957486 a:visited,
#yiv2295957486 span.yiv2295957486MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv2295957486
p.yiv2295957486MsoAcetate, #yiv2295957486 li.yiv2295957486MsoAcetate,
#yiv2295957486 div.yiv2295957486MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv2295957486
span.yiv2295957486EmailStyle17 {color:#1F497D;}#yiv2295957486
span.yiv2295957486EmailStyle18 {color:#1F497D;}#yiv2295957486
span.yiv2295957486TextedebullesCar {}#yiv2295957486 .yiv2295957486MsoChpDefault
{font-size:10.0pt;}#yiv2295957486 filtered {margin:72.0pt 72.0pt 72.0pt
72.0pt;}#yiv2295957486 div.yiv2295957486WordSection1 {}#yiv2295957486 Dear all,
You might have to add the following call before sql :connect() :
sql:init(com.mysql.jdbc.Driver) I found it mandatory in xqm modules run
inside Tomcat, for example. If you start playing with the SQL module, You
will realize that BaseX rocks also on SQL repositories ! With RESTXQ+SQLMODULE
you can write in a few lines a REST service exposing SQL data. Best regards,
Fabrice Etanchaud Questel/Orbit De :
basex-talk-boun...@mailman.uni-konstanz.de
[mailto:basex-talk-boun...@mailman.uni-konstanz.de]De la part de Lizzi, Vincent
Envoyé : mercredi 19 novembre 2014 23:31
À : Hans-Juergen Rennau; basex-talk@mailman.uni-konstanz.de
Objet : Re: [basex-talk] BaseX and MySQL Hans, I had to do this a few
days ago, so it’s fresh in my mind. Download Connector/J from the MySQL website
and place .jar file in the basex/lib folder. Restart BaseX (if you’re using the
server version) so it picks up the new .jar. Queries can then be run like:
let $c := sql:connect('jdbc:mysql://localhost/database', 'user', 'password')
sql:execute($c, select …) sql:execute($c, call stored_procedure…();)
Cheers, Vincent From:basex-talk-boun...@mailman.uni-konstanz.de
[mailto:basex-talk-boun...@mailman.uni-konstanz.de]On Behalf Of Hans-Juergen
Rennau
Sent: Wednesday, November 19, 2014 5:20 PM
To: basex-talk@mailman.uni-konstanz.de
Subject: [basex-talk] BaseX and MySQL Dear BaseX team, can you point me
to some information about which steps I must take in order to start accessing
MySQL databases via the sql module? Thank you for help, Hans-Juergen
[basex-talk] BaseX and MySQL
Dear BaseX team, can you point me to some information about which steps I must take in order to start accessing MySQL databases via the sql module? Thank you for help,Hans-Juergen
Re: [basex-talk] BaseX and MySQL
Hans,
I had to do this a few days ago, so it’s fresh in my mind. Download Connector/J
from the MySQL website and place .jar file in the basex/lib folder. Restart
BaseX (if you’re using the server version) so it picks up the new .jar.
Queries can then be run like:
let $c := sql:connect('jdbc:mysql://localhost/database', 'user', 'password')
sql:execute($c, select …)
sql:execute($c, call stored_procedure…();)
Cheers,
Vincent
From: basex-talk-boun...@mailman.uni-konstanz.de
[mailto:basex-talk-boun...@mailman.uni-konstanz.de] On Behalf Of Hans-Juergen
Rennau
Sent: Wednesday, November 19, 2014 5:20 PM
To: basex-talk@mailman.uni-konstanz.de
Subject: [basex-talk] BaseX and MySQL
Dear BaseX team,
can you point me to some information about which steps I must take in order to
start accessing MySQL databases via the sql module?
Thank you for help,
Hans-Juergen
