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
