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
